EssentialSQL: Stored Procedures Unpacked – Code in TSQL

Stored Procedures Database Programming, Write TSQL Server Stored Procs for Data Engineering, Data Analysis, and DBA's

Created by: Kris Wenzel
Let me teach you SQL using simple to understand English.

Created by: Essential Sql
Learn everything you need to use SQL in your next project

What Will I 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.

Requirements

• You should already be familiar with basic queries, such as SELECT, GROUP BY, and ORDER BY clauses.
• Knowledge of basic programming concepts, such as IF/THEN is a plus, but not mandatory.

Target audience

• Beginner SQL query authors curious about combining SQL statements into transactions.
• Anyone looking to take a class whose singular purpose is to teach you stored procedures.
• Anyone who thinks that stored procedures are really scary (they aren't!) 🙂
• Developers wanting to learn about database cursors.
• Analysts looking to create advanced data sources from SQL Server from Power BI.
• Developers looking to for a better way to develop and manage database code.