Database Fundamentals/Stored Procedures

From Wikiversity
Jump to navigation Jump to search

This lesson introduces stored procedures.

Objectives and Skills[edit | edit source]

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 | edit source]

  1. Wikipedia: Stored procedure

Multimedia[edit | edit source]

  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 | edit source]

  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 | edit source]

  • 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 | edit source]

SQL injection
stored procedure

See Also[edit | edit source]

References[edit | edit source]

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