Learn SQL WITH MAGNUS

Magnus Ahlkvist is a long time SQL Server Specialist and Microsoft Data Platform MVP. He works a consultant and SQL trainer with his company, Transmokopter SQL AB. On this website, you can subscribe to Magnus' recorded SQL training classes. Scroll down to learn more and to sign up. Also check out Magnus' blog and the Transmokopter SQL AB website.

Product image

Query databases with T-SQL

Master the fundamentals of SQL Server and start writing real queries from day one.

Query Databases with T‑SQL is a practical, beginner‑friendly course that teaches you how to retrieve, filter, sort, and shape data using T‑SQL — the SQL dialect used across countless applications and enterprise systems.

You’ll learn essential skills like SELECT queries, WHERE filtering, ORDER BY sorting, JOINs, GROUP BY, subqueries, and CTEs — all explained clearly with real examples.

And when you’re ready, you’ll take the next step with table valued functions, the APPLY operator, and SET operators like UNION, INTERSECT, and EXCEPT.

Perfect for developers, analysts, and anyone starting their SQL journey — this course gives you the confidence and skills to query SQL Server databases effectively and professionally.

0 students enrolled

Last updated Aug 20th, 2026

Select a Pricing Plan
Buy now