Database Fundamentals/Stored Procedures

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

Readings

edit
  1. Wikipedia: Stored procedure

Multimedia

edit
  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

Activities

edit
  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

References

edit
  Type classification: this is a lesson resource.