EssentialSQL: Stored Procedures Unpacked - Code in TSQL

Stored Procedures Database Programming, Write TSQL Server Stored Procs for Data Engineering, Data Analysis, and DBA's
4.54 (1270 reviews)
Udemy
platform
English
language
Databases
category
instructor
EssentialSQL: Stored Procedures Unpacked - Code in TSQL
7,262
students
5 hours
content
Feb 2024
last update
$84.99
regular price

What you will learn

Understand what a stored procedure is and how it differs from other types of SQL queries.

Understand how to pass parameters to and from stored procedures.

Know how to use variables and control structures such as IF/ELSE and WHILE loops within stored procedures.

Learn how to debug, that is troubleshoot, a stored procedure.

Setup transactions, detect errors, and automatically rollback changes

Understand how to use cursors in stored procedures.

Screenshots

EssentialSQL: Stored Procedures Unpacked - Code in TSQL - Screenshot_01EssentialSQL: Stored Procedures Unpacked - Code in TSQL - Screenshot_02EssentialSQL: Stored Procedures Unpacked - Code in TSQL - Screenshot_03EssentialSQL: Stored Procedures Unpacked - Code in TSQL - Screenshot_04
1756916
udemy ID
6/19/2018
course created date
3/22/2020
course indexed date
Bot
course submited by