Loading...

Course Description

This course introduces SQL Server programming stored procedures. Understand how stored procedures, also known as stored procs or procs, are queries and commands (select/update/delete/insert) permanently stored in the database, making them always available. Learn how to use pre-compiled stored procedures to speed up slower queries. Discover how to use If, existence checks, and returns to handle business logic, so queries return what is needed, when it is needed. Additional topics include using Variables and parameters to make commands more universal for ease with runs on different dates or accounts.

In this course, you will learn to: 

  • Identify the benefits of writing stored procedures 

  • Create stored procedures to select and manipulate data in a SQL Server database 

  • Define and reference local variables and parameters in your stored procedures 

  • Alter already existing procedures 

  • Select, manipulate, and process data in stored procedures 

  • Test for the existence of data 

  • Process data conditionally, using IF statements and the CASE function 

  • Use the GUI to look at the stored procedures 

  • Use system stored procedures to learn about the database stored procedures 

Prerequisites

Intermediate Applications of SQL or equivalent experience.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Introduction to SQL Stored Procedures
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Mar 19, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 17, 2024
Transfer Request Deadline
Mar 17, 2024
Section Title
Introduction to SQL Stored Procedures
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Mar 19, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 17, 2024
Transfer Request Deadline
Mar 17, 2024
Section Title
Introduction to SQL Stored Procedures
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
May 24, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
May 22, 2024
Transfer Request Deadline
May 22, 2024
Section Title
Introduction to SQL Stored Procedures
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
May 24, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
May 22, 2024
Transfer Request Deadline
May 22, 2024
Required fields are indicated by .