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.52 (1298 reviews)
7 453
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.
Course Gallery
Loading charts...
Comidoc Review
Our Verdict
Delve into the world of T-SQL stored procedures with this course that offers comprehensive coverage and a knowledgeable instructor. Though minor improvements could be made to audio, structure, and resources, the numerous examples given aid in learning the concepts and writing your own procedures. While increasing quizzes and task exercises would enhance understanding, valuable information is present for those seeking mastery of T-SQL stored procedures.
What We Liked
- Covers all basic things needed to start working with T-SQL stored procedures
- Instructor is knowledgeable and explains concepts in detail
- Numerous examples provided for hands-on learning
- Industry applications presented to drive home some concepts
Potential Drawbacks
- Quality of life aspects can be improved (audio, structure, resources)
- Some parts may feel rushed with not enough explanation
- Limited quizzes and 'do this task' type exercises
- Code examples sometimes provided without full context
Related Topics
1756916
udemy ID
19/06/2018
course created date
22/03/2020
course indexed date
Bot
course submited by