Look, we've all been there. You write what seems like a perfectly reasonable query, hit F5, and then... nothing happens. Or worse, everything happens, including your phone blowing up with angry users.
This course will teach you how T-SQL actually works, not just how the docs say it works. Designed specifically for folks bridging the gap from novice to intermediate, you'll learn to write queries that don't make your server cry or your users wonder if they've made a huge mistake.
I've packed over 24 hours of streaming video content (complete with scripts and slides!) with all the stuff I wish I'd known when I first opened SQL Server Management Studio back in 2008. This treasure trove works with SQL Server 2016+, Azure SQL Database, and Azure SQL Managed Instance.
What's on the menu? All the fundamentals explained in plain English:
The SELECT statement that does more than just "select everything"
JOINs that actually make sense (and don't accidentally create cartesian products)
Subqueries and table expressions that solve problems instead of creating them
Window functions without the headache
Basic transactions that don't lock up the entire database
Data modifications that don't leave your tables looking like abstract art
Perfect for folks who know enough T-SQL to be dangerous (to their own servers) but want to level up to the kind of queries that make your DBA send you thank-you notes instead of passive-aggressive monitoring alerts.
You'll gain insights into relational theory, query optimization, and set-based thinking – all explained like you're a human, not a computer.
Ready to write T-SQL that doesn't make users wonder if they've made a huge mistake?
Let's do this!
In this section we'll cover data modifications in T-SQL:
INSERT
Identity
Sequence
DELETE
TRUNCATE
UPDATE
MERGE
OUTPUT
Very few areas of databases in general, but SQL Server in particular, suffer as many misconceptions and outright misinformation as these. Developers seem to maintain these nagging mental injuries, like row versioning isolation levels allow dirty reads, or locking isolation levels guarantee snapshot-type consistency of reads, that are simply wrong. In these modules, I'm going to show you the truth.
SQL is for queries, not programming! Well, kind of. Turns out, you can do a lot whole of procedural programming in your declarative language. In these modules, I'll cover all the major types of modules you can create, along with things like cursors, loops, control-flow logic, dynamic SQL, and temporary objects. Get ready for fun.