Skip to content
UdemySQLPaid courseIntermediate levelCertificate

Learn Advanced T-SQL For SQL Server Administrator (Udemy.com)

Getting to understand stored procedures

Created by: Raphael Asghar

Last updated April 2017

icon
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

icon
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.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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.

icon
More courses by Raphael Asghar

$11.99

$11.99

$69.99

$10.99

$69.99

$10.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.6

1,063 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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.

Showing all 10 reviews on CourseDuck

Read all 1,063 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100