Advanced Transact-SQL Programming
3.5 (21 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.
141 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.5 (21 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.
141 students enrolled
Created by Mike West
Last updated 8/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 4 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
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
Requirements
  • 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.
Description

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.
Students Who Viewed This Course Also Viewed
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
01:11

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
00:01

Summary
00:43

Quiz
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
02:59

Let's catch and error to two. 

The Try Catch Block
05:22

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

Using Case In The ORDER BY Clause
01:22

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

UPDATE TOP 10 Using a CTE
01:18

Let's create a self join for deleting. 

DELETE TOP 10 Rows
01:22

The new CASE function. 

The CHOOSE Function. The New Case?
02:12

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

Forcing an Index Hint
03:46

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.
02:06

Using sp_executeSQL has several real world advantages over exec. 

Variables and sp_executeSQL
02:32

Let's look at RAISERROR. 

Quick Tip: Custom Errors Using RAISERROR
01:19

Let's THROW an error instead of raising one. 

THROWING out RAISERROR
01:46

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

The Synonym Versus the View
02:56

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

Single Value Declarations
05:59

How do we control code that executes serially? 

Control Flow
04:19

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

ORDER BY
04:00

Summary
01:12

Quiz
10 questions
+
Conclusion
1 Lecture 00:22

A few final thoughts on learning transact. 

Final Thoughts
00:22
About the Instructor
Mike West
4.2 Average rating
2,587 Reviews
42,701 Students
40 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

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

Personal

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