This was originally a free weekly course introducing you to the Transact SQL language implemented in SQL Server, it takes you from newbie to a master of SELECT statements. Each class features a demo introducing a topic and a homework assignment to try on your own. In the following lesson we go over sample solutions for the homework, then introduce a new topic.

This course covers:
• SELECT statements and aliasing tables
• Using WHERE clauses and JOINs
• Aggregating data using GROUP BY and CASE statements
• Common Table Expressions, Subqueries, and Derived tables
• Scalar and Table Valued User Defined Functions
• An introduction to Stored Procedures

This course is taught by Kendra Little, a Microsoft Certified Master and Microsoft MVP. Kendra has been writing TSQL for more than 20 years, and still finds it to be great fun. She wants to share her love for this useful language, as well as tips and tricks on how to keep learning after the course.

The course will be held as a series of weekly livestreams and each lesson is approximately 45 minutes to one hour in duration. No registration is required.

Pre-requisites:
• To follow along, you will need an installation of Microsoft SQL Server Developer Edition (this is free from Microsoft)
• You will also need an installation of either Azure Data Studio or SQL Server Management Studio (both of which are free as well). Most demos will be shown in Azure Data Studio.