EssentialSQL: Stored Procedures Unpacked - Code in TSQL (Udemy.com)
Stored Procedures Database Programming, Write TSQL Server Stored Procs for Data Engineering, Data Analysis, and DBA's
Created by: Kris Wenzel
Last updated February 2024
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.
How it compares
Against the other 388 rated Udemy courses in SQL on CourseDuck:
- Rating4.4 out of 5higher than 34% of them
- Reviews1,452#116 of 389 by number of reviews
- Length4.9 hoursshorter than 60% of them
- Last updatedFebruary 2024more recently than 53% of them
Course Description
Use TSQL to write stored procedures and scripts to automate data engineering and data analysis task. This is a great SQL course for a DBA to take if they want to stand out from other database administrators. Learn Database Programming concepts using SQL Server stored procedures.
Whether You're:
A developer looking to secure your app with stored procedures.
A consultant looking to expand your tool set
An IT professional looking to read and understand database code
An analyst looking to parametrize PowerBI queries for SQL data analysis
A sql server DBA looking to build their SQL server database administrator skills
You're in the right place and I'm going to tell you exactly how Stored Procedure Unpacked gives you the tools, inspiration, and unparalleled support on your journey to level up your SQL skills.
In this Course you will Learn to:
Use stored procedures to implement business logic.
Develop stored procedures from scratch!
Learn some basic troubleshooting skills.
Know the right way to use cursors.
Apply database transaction techniques to commit or rollback your database changes.
Trap and handle errors.
Nothing is worse than:
Being excited to learn something new but not knowing where to start.
Wasting time learning the wrong features.
Being overwhelmed with options and not know which to use.
Imagine having the knowledge to know how to quickly write stored procedures to take your SQL to the next level. The confidence confidence that you're on the right track. A sense of accomplishment, you have learned something most cannot.
By the time you’ve complete this course you’ll have an appreciation of developing stored procedures, overcome your fear, and able to write stored procedures that pass parameters, handle errors, and rollback unintended database changes.
Now that’s cool!
Instructor Details
- 4.4 Rating
1,452 Reviews
Kris Wenzel
If you're interested in learning SQL, you're in the right place.
I'm here to help you build a strong foundation in all aspects of SQL: from the very first steps to complex data architectures and designs. Many people struggle with where to begin learning SQL, but you don’t have to!! Essential SQL is my platform for bringing all aspects of SQL to you.
With more than 30 years of experience in SQL and a degree in Computer Engineering from the University of Michigan, I am passionate about helping others learn this valuable skill. As a blogger, I share SQL tips and how-to articles with over a million readers each year on my blog, Essential SQL. In addition, I have been teaching online for over eight years to people from various industries, including accounting, purchasing, and human resources.
In my professional life, I work with large corporations to design data warehouses that support business intelligence and data science activities. I believe that SQL is a valuable skill that is within reach for anyone, and my courses are designed to help you learn and grow with the technology.
So, what will you get out of my courses?
More courses by Kris Wenzel
EssentialSQL: Data Modeling & Relational Data Architecture (2024)
4.6 (769 Reviews)
Provider: Udemy
Time: 3.8h
$74.99
EssentialSQL: Subquery Magic - Master SQL Sub Queries. (2024)
4.6 (439 Reviews)
Provider: Udemy
Time: 2.2h
$64.99
EssentialSQL: Database Normalization Simplified (2024)
4.6 (119 Reviews)
Provider: Udemy
Time: 1h
$54.99
EssentialSQL: SQL Window Functions for Business Analytics (2024)
4.5 (116 Reviews)
Provider: Udemy
Time: 3.6h
$54.99
More SQL courses
SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2025)
4.8 (2,153 Reviews)
Provider: Udemy
Time: 19.7h
$94.99
SQL Server High Availability and Disaster Recovery (HA/DR) (2026)
4.8 (1,810 Reviews)
Provider: Udemy
Time: 88.3h
$16.99
70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (2025)
4.8 (1,094 Reviews)
Provider: Udemy
Time: 3.6h
$12.99
Modern Event-Driven Spring Boot: Kafka & Spring Cloud Stream (2026)
4.8 (494 Reviews)
Provider: Udemy
Time: 13.4h
$10.99
Oracle Database 12c Backup and Recovery using RMAN (2024)
4.8 (428 Reviews)
Provider: Udemy
Time: 20.1h
$34.99
Reviews
By Adeyinka Amole on 4/20/2024
The concepts are well explained and demonstrates that he is knowledgeable and vast with stored procedures. Industry applications is missing to drive home some of the concepts. I would love to see business use cases in addition to the examples given. Overall, he is able to communicate the module in a very easy way.
By Luis Esteban Fajardo Bravo on 3/12/2024
I am a database consultant with several years of experience, however all my experience is focused only with Oracle technologies, so I was looking for a quick course to get me on track to start working with T-SQL. I can say that this course is very easy to follow with, it doesn't bloat the student with database technicisms that might be cumbersome for first learners, however, it actually covers up all basic things to start working with T-SQL language needed to develop fully functional scripts and procedures. It's not a SQL course, so we won't find SQL operations like joins, aggregate functions or complex stuff, for me it met and exceeded my expectations and I recommend it.
By Brian Harder on 2/5/2024
It was a great course and gave me a better understanding on the design and functionality of stored procedures. There is tons of information, good examples, and great resources that will help in continuing to learn more about T-SQL, programming, and stored procedures.
By A B on 9/21/2023
You are great at teaching, you provide numerous examples, and explain everything in detail. I watch the videos again to gain the clarity I need, in the event I do not grasp it the first time around. Thank you for taking the time to adequately convey your wealth of knowledge and provide a great learning experience.
By Alessandro Gherardi on 2/15/2023
The course is really good in providing an overview of storedprocedures, explaining how to create them, when to use them and how to debug them and I recommend it. IMPORTANT: you need to have SQL knowledge in order to take this course as the teacher (in my opinion correctly) does not explain the SQL code being used, it is implied that you know SQL and what you want to achieve is how to "implement" SQL based stored procedures. It is not a SQL course. I'm specifying this because many people complain that the code is not explained, which in my opinion is not a fair critic for the course.
By Yael Markovich on 5/6/2021
So far this course teach me in a very short of time how to get confidence with Stored Procedures. I need to learn the subject quick for a job ineview . But it's not only basic staff. The lectural gave important example and teach us to use it in the most advantage way for SQL.
By ChengSee Lim on 11/22/2020
easy to follow and understand
By Simo Pedro Rocha Toga Machado on 11/15/2020
So far, so good
By Robles Duran on 11/15/2020
That excersices in this course not the same a this video, so I didn't practice
By John Wright on 11/8/2020
A great introduction to SQL.
By Eivar Rodriguez on 11/1/2020
very clear
By Julie Starling on 10/21/2020
It was frustrating that there is one unfinished lesson on debugging, which seems to be pointed out in the Q&A for months. Even after claiming to have fixed it, it still isn't. For that reason alone I have knocked it down a star as I didn't feel like I got anything out of the Debugging section, which is a shame as it was one of the reasons I bought the course as that was on the list of topics covered.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 88 / 100










