Database Fundamentals/Stored Procedures

This lesson introduces stored procedures.

Objectives and Skills

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

1. Read Wikipedia: Stored procedure.

Multimedia

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

Activities

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

• 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

SQL injection

stored procedure

See Also

• Microsoft: Create a Stored Procedure
• Microsoft TechNet: Creating Stored Procedures (Database Engine)
• MSSQL: SQL Server Stored Procedures Tutorial

References

Resource type: this resource is a lesson.