Advanced Transact-SQL Programming
3.4 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
150 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Advanced Transact-SQL Programming to your Wishlist.

Add to Wishlist

Advanced Transact-SQL Programming

Moving Beyond the Basics
3.4 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
150 students enrolled
Created by Mike West
Last updated 8/2016
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1 hour on-demand video
  • 4 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • You'll learn more than the basics of of how to manipulate SQL Server data.
  • You'll be able to begin crafting more complex stored procedures with hands on exercises.
  • You'll learn how to craft cleaner code that's properly optimized.
View Curriculum
  • Students should already have their test environments set up and have written basic transact.
  • Students should have a solid foundations with SQL Server and transact-sql.

Transact-SQL is integral to the power of SQL Server. 

Transact-SQL features allow developers to create scalable, distributed applications to meet the demanding requirements of modern organizations.

In this course we will move beyond the basics of Transact and learn advanced coding techniques that you can immediately integrate into your real world code. 

The code for each lesson will be available in the course download lecture so you can cut and paste example into your learning environment. 

This isn’t a structured course that walks you through all the basics categories of the language. 

This course will be a hodgepodge of real world questions taken from sundry SQL Server forums that answer real world problems specific to transact-sql. 

For example, did you know you can use the CASE statement in the ORDER BY clause? I have a short lesson on how to do just that. 

While this course isn’t a true expert level course I would highly recommend you have some basic experience with transact or have taken my introductory level course and worked through the example. 

Thanks for your interest in “Advanced Transact-SQL Programming.”

The first 10 minutes are free on every Udemy course. Please take a moment to watch all ten minutes to ensure this course is right for you. 

It's also a good idea to read over the lecture titles. The titles will provide you with insight into what's really in the course.

See you in the course!!!

Who is the target audience?
  • If you understand the basics of Transact-SQL and want to dive deeper into learning transact then this course is for you.
Compare to Other T-SQL Courses
Curriculum For This Course
Course Overview
8 Lectures 14:37

What are you going to learn in this course? 

Preview 01:33

Are you at the right place? I want you to take all of my courses but I want them to be right for you. 

Preview 01:40

What is a timestamp and when do we use it? 

Preview 01:55

NULLS are strange creatures and there's a lot to learn surrounding their usage. 

Nulls and Functions

What does SET ANSI_NULLS on do? 

Preview 01:31

What is seeding and how do we seed and reseed? 

Preview 06:03

This is the location for all of the course downloads

Course Downloads


5 questions
Advanced Tips
16 Lectures 44:30

There are quite a few date and time options. Let's take a look at them. 

The Right Date Data Type

Let's catch and error to two. 

The Try Catch Block

A more advanced example of using the much loved CASE statement. 

Using Case In The ORDER BY Clause

Let's use a CTE to update the top X number of rows. 


Let's create a self join for deleting. 


The new CASE function. 

The CHOOSE Function. The New Case?

Let's learn how to force an index. Not recommended but a nice tool if you need it. 

Forcing an Index Hint

I don't like UDFs in joins and the more you see them I believe you won't either. 

UDFs in Joins. It's Possible. Not Recommended.

Using sp_executeSQL has several real world advantages over exec. 

Variables and sp_executeSQL

Let's look at RAISERROR. 

Quick Tip: Custom Errors Using RAISERROR

Let's THROW an error instead of raising one. 


The important lesson here is about updating the object underlying the view. 

The Synonym Versus the View

Let's take a look at some single variable declarations. 

Single Value Declarations

How do we control code that executes serially? 

Control Flow

Let's cover ORDER BY at a more granular level. 



10 questions
1 Lecture 00:22

A few final thoughts on learning transact. 

Final Thoughts
About the Instructor
Mike West
4.2 Average rating
2,988 Reviews
49,542 Students
42 Courses
SQL Server and Machine Learning Evangelist

I've been a production SQL Server DBA most of my career.

I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.

Experience, education and passion

I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.


Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).


Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.