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. Wikipedia: 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:
   • 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).
• 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

See Also

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

References

Type classification: this is a lesson resource.

← Views

Database Fundamentals

Functions →