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!!!
Are you at the right place? I want you to take all of my courses but I want them to be right for you.
NULLS are strange creatures and there's a lot to learn surrounding their usage.
What is seeding and how do we seed and reseed?
This is the location for all of the course downloads
There are quite a few date and time options. Let's take a look at them.
Let's catch and error to two.
A more advanced example of using the much loved CASE statement.
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.
Let's learn how to force an index. Not recommended but a nice tool if you need it.
I don't like UDFs in joins and the more you see them I believe you won't either.
Using sp_executeSQL has several real world advantages over exec.
Let's look at RAISERROR.
Let's THROW an error instead of raising one.
The important lesson here is about updating the object underlying the view.
Let's take a look at some single variable declarations.
How do we control code that executes serially?
Let's cover ORDER BY at a more granular level.
A few final thoughts on learning transact.
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.