Courses Tech Library
About Contact

SQL Server Mastery

Have you ever written a SQL Server query that worked, but felt like there must be a better way?

Most of us learn the basics of SQL and stop there. But SQL Server has a lot of features that can replace several queries, or a chunk of application code, with one clear statement.

SQL Server Mastery builds on what you already know and shows you those features step by step, with exercises along the way, so you can become the go-to SQL Server person in your team.

You'll be able to:

  • Group your data in exactly the combinations you want, using GROUPING SETS, CUBE and ROLLUP
  • Use window functions with frames and window clauses to rank results and refer to other rows
  • Pivot and unpivot data, and write nested and recursive CTEs
  • Store, query and filter JSON data, and use CROSS APPLY and OUTER APPLY
  • Choose the right data types, including how to handle boolean and GUID values
  • Know when to use temp tables or table variables, and use the OUTPUT clause, SELECT INTO and INSERT INTO

What's included

  • 8 modules and 52 short video lessons (about 5 to 10 minutes each)
  • SQL scripts for every lesson, so you don't need to type them from the video
  • Exercises PDF with all the exercises in the course
  • The complete course as a PDF for offline reading and reference
  • Lifetime access, plus a comments section to ask me questions

"I like the real life examples, that we are doing actual and real stuff. there is a bit of theory - sure, but only essentials. And then we jump right to practice - it's nice." Michal Z

"It’s the best training material on SQL anywhere. You have a rare gift for making the complex simple." Brad C

30-Day Money Back Guarantee

If you're not happy with the course, let me know within 30 days of purchasing and I'll refund the full purchase price.

Frequently Asked Questions

How much SQL should I know first?

You should be comfortable creating tables, writing SELECT, INSERT, UPDATE and DELETE statements, using WHERE, GROUP BY, HAVING and ORDER BY, and joining tables. If you've completed SQL Simplified, this is the next step.

What software do you use?

I use SQL Server Management Studio with a SQL Server database on my computer. You can use another editor if you prefer, because everything shown is SQL.

Is this for other databases too?

The syntax and examples are all for SQL Server. Some concepts apply to other databases, and I have separate Mastery courses for Oracle and PostgreSQL.

My team doesn't use SQL Server. Will this help me?

You probably won't use it much in your current role. But it builds skills you can take into future roles, and you'll be ready if your team starts using SQL Server.

I don't have much time. Will I get through it?

The lessons are short, you get everything as soon as you enrol, and you keep access for life. The course PDF is there to refresh your memory when you need a feature weeks or months later.