- Introduction to Transact-SQL.
- Using the SELECT statement.
Lab: Get started with SQL Server query tools and writing queries in T-SQL.
Module 2: Sorting and Filtering Query Results
- Sorting query results.
- Filtering the data.
Lab: Sort and filter data returned by SELECT queries.
Module 3: Using Joins and Subqueries
- Using JOIN operations.
- Using subqueries.
Lab: Write queries with JOIN operations.
Lab: Write SELECT statements using subqueries.
