Learn Advanced T-SQL For SQL Server Administrator (Udemy.com)
Getting to understand stored procedures
Created by: Raphael Asghar
Last updated April 2017
What you will learn
- The student will learn about stored procedures, If Else, While Loop, cursors, derived tables, CTEs, sproc permissions, temp tables, sproc parameters and much more. The student at the end of this course will gain valuable information about sprocs and how to read and follow them in the production environment.
How it compares
Against the other 388 rated Udemy courses in SQL on CourseDuck:
- Rating4.6 out of 5higher than 69% of them
- Reviews1,063#141 of 389 by number of reviews
- Length5.2 hoursshorter than 58% of them
- Last updatedApril 2017earlier than 85% of them
Course Description
The student will learn about stored procedures, If Else, While Loop, cursors, derived tables, CTEs, sproc permissions, temp tables, sproc parameters and much more. The student at the end of this course will gain valuable information about sprocs and how to read and follow them in the production environment. In addition, the student will be given examples of block statements, transactions commands, recursive CTEs, error handling, variables, and much more. This course will greatly help those students that want to understand how to read, modify, and execute from simple to complex stored procedures. By creating stored procedures, the developer has greater control in the execution of SQL commands, permissions, and greater flexibility in updating the sproc.
Instructor Details
- 4.6 Rating
1,063 Reviews
Raphael Asghar
Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA. I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.
More courses by Raphael Asghar
Learn T-SQL From Scratch For SQL Server Administrator (2020)
4.6 (2,904 Reviews)
Provider: Udemy
Time: 8.7h
$10.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 Antonia Corbalán Galindo on 2/10/2025
Ciertos recursos están desactualizados, pero buscando en internet se pueden encontrar, les recomiendo usar SQL Server sin tener que instalar una máquina virtual, por otro lado, siento que el curso podría incluso más corto, a no ser que se vean ejemplos más complicados.
By Jecris Morcillos on 10/25/2023
Speaks quite fast but enough to get understood. I like the detailed explanation which serves to be immediate answers to my question(s) while watching the lessons. Quite short but a good learning materials.
By Hector Chicas Castillo on 1/22/2023
This is course is very very good. I just can't give it a full 5 stars bc of the lax script formatting and some of the resources where shortcuts to files rather than actual files. Raf is a good teacher but it's obvious he kinda stumble through some of the lessons. When you're a noob nomenclature is very important and he didnt get it right a little bit too often. I still recommend it.
By Joe Huallpa on 11/4/2021
It's a good course for understanding SQL stored procedures. I learned how to understand, read and code them. I'd recommend this to anybody that already has a beginner understanding of SQL server.
By Fobester Chadehumbe on 1/12/2020
The course was captivating, though the instructor was dealing with advanced topics, managed to breakdown the couse in such a way that it is easy to follow. His lectures on CTE are the best I have seen so far. Great job!
By Herbert H Smith on 9/15/2019
I have experience with SQL Server. I took this course to fill in knowledge gaps and as a prep for an upcoming interview. I very much appreciate RAF sharing some Excel tips. This will be helpful, as I'm often asked to import data from Excel.
By Ivan Grishchenko on 7/9/2019
The course is a good general overview of stored procedures, CTEs, and other advanced T-SQL applications. It will not make you a developer, but it is useful to anyone who has a solid understanding of basic T-SQL and wishes to improve their knowledge or explore other T-SQL topics. The presentation is clear and to the point.
By Aymeric Nys on 10/26/2018
You will be introduced to more advanced T-SQL constructs than the previous class, like IF and WHILE, store procedures, CTE, cursors, transactions and errors handling. All of these are essential constructs for a better understanding of SQL code you could find in your corporate database. The instructor does a good job at presenting the concepts and uses simple, to the point, examples to show how it is done.
By Angel Rivas on 4/27/2018
"...so my name is Raphael and this is How to Become a Production SQL Database Administrator, see ya in the next video... *5, 4, 3, 2...* Welcome to How to Become a Production SQL Database Administrator, my name is Raphael..."
By John Derek Campbell on 12/8/2017
I enjoyed this course as it is a good overview of CTEs, stored procedures, transactions, error handling, et cetera. I will have to explore these concepts in more depth outside of this course, however, as I am geared primarily toward development and I wanted to better understand some of the concepts first.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100












