Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-464): Designing and Implementing Stored Procedures

A stored procedure is a named collection of Transact-SQL statements that is stored on the server within the database itself. Be introduced to stored procedures and all its potential benefits. This course will be covering how to pass parameters to stored procedures and receive output, as well as how to control the execution context of a stored procedure. This course will be paired with several demos that will give the students a real world example of the concepts that will be discussed.

Description

A stored procedure is a named collection of Transact-SQL statements that is stored on the server within the database itself. This "Designing and Implementing Stored Procedures" LearnSmart course will introduce your to stored procedures and all its potential benefits. This course will be covering how to pass parameters to stored procedures and receive output, as well as how to control the execution context of a stored procedure. This course will be paired with several demos that will give the students a real world example of the concepts that will be discussed.


Topics Covered Include:
-Stored Procedure
-Working with Stored Procedures
-Parameters in Stored Procedures
-Execution Context

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Designing and Implementing Stored Procedures: Supplemental Materials
    "Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-464): Designing and Implementing Stored Procedures"" Course."
  • Stored Procedures
    Introduction
    0:44
    Stored Procedures and Applications
    3:18
    Knowledge Check
    0:57
    Transact-SQL and Managed Code
    2:14
    Knowledge Check
    1:44
    Knowledge Check
    1:37
    System Stored Procedures
    3:11
    Knowledge Check
    1:37
    SHOW ME Demonstration: Working with System Stored Procedures
    2:14
  • Working with Stored Procedures
    Creating Stored Procedures
    4:24
    Knowledge Check
    1:23
    SHOW ME Demonstration: Working with System Stored Procedures
    1:43
    Execute Stored Procedures
    3:07
    SHOW ME Demonstration: Alter Stored Procedure
    0:47
    SHOW ME Demonstration: Drop Stored Procedure
    0:41
    User-Defined Stored Procedure
    2:01
    Knowledge Check
    1:01
  • Parameters in Stored Procedures
    Parameters in Stored Procedures
    1:36
    Input Parameters
    1:29
    Output and Return Parameters
    2:01
    SHOW ME Demonstration: Stored Procedures with Input and Output Parameters
    2:28
    Query Plans
    2:26
  • Execution Context
    Controlling Execution Context
    1:13
    Knowledge Check
    0:31
    Tokens
    1:16
    Using EXECUTE AS
    2:03
    SHOW ME Demonstration: Execution Context
    1:23
    Best Practices
    1:20
    Knowledge Check
    0:46
    Conclusion
    1:36

Skills

  • Database Management
  • Database Management System (DBMS)
  • SQL Server

Similar Courses

More Courses by this Instructor