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!