Database Fundamentals/Stored Procedures

From Wikiversity
Jump to navigation Jump to search

This lesson introduces stored procedures.

Objectives and Skills[edit]

Objectives and skills for the stored procedures portion of Microsoft Exam 98-364 Database Fundamentals include:[1]

  • Create database objects
    • Create stored procedures and functions
      • Select, insert, update, or delete data


  1. Wikipedia: Stored procedure


  1. Microsoft Virtual Academy: Creating Databases and Database Objects
  2. YouTube: SQL Stored Procedures
  3. YouTube: SQL Server Programming Part 1 - Stored Procedure Basics
  4. YouTube: Stored procedures in sql server Part 18


  1. Use SQL Server to create stored procedures to update record information in the Student table in your College database.
  2. Create the following stored procedures:
    • Apply the INSERT statement in a stored procedure to insert a new record into the Student table.
    • Apply the UPDATE statement in a stored procedure to update the first name field in the previous step in the Student table.
    • Apply the DELETE statement in a stored procedure to remove the record that you just added in the Student table.

Lesson Summary[edit]

  • A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDMS). [2]
  • A SQL injection is a code injection technique, used to attack data-driven applications, in which malicious SQL statements are inserted into an entry field for execution (e.g. to dump the database contents to the attacker). [3]

Key Terms[edit]

SQL injection
stored procedure

See Also[edit]


Nuvola apps edu miscellaneous.svg Type classification: this is a lesson resource.