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:
 * Create database objects
 * Create stored procedures and functions
 * Select, insert, update, or delete data

Readings

 * 1)  Stored procedure

Multimedia

 * 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

 * 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:
 * 3) * Apply the INSERT statement in a stored procedure to insert a new record into the Student table.
 * 4) * Apply the UPDATE statement in a stored procedure to update the first name field in the previous step in the Student table.
 * 5) * 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).
 * 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).

Key Terms

 * SQL injection
 * stored procedure