Get Started Querying with Transact SQL 

Introduction

Work with schemas

Explore the structure of SQL statements

Examine the SELECT statement

Work with data types

Handle NULLs

Exercise - Work with SELECT statements

Knowledge check

Summary

Introduction

Sort your results

Limit the sorted results

Page results

Remove duplicates

Filter data with predicates

Exercise - Sort and filter query results

Knowledge check

Summary

Introduction

Understand joins concepts and syntax

Use inner joins

Use outer joins

Use cross joins

Use self joins

Exercise - Query multiple tables with joins

Knowledge check

Summary

Introduction

Understand subqueries

Use scalar or multi-valued subqueries

Use self-contained or correlated subqueries

Exercise - Use subqueries

Knowledge check

Summary

Introduction

Categorize built-in functions

Use scalar functions

Use ranking and rowset functions

Use aggregate functions

Summarize data with GROUP BY

Filter groups with HAVING

Exercise - Use built-in functions

Knowledge check

Summary

Introduction

Insert data

Generate automatic values

Update data

Delete data

Merge data based on multiple tables

Exercise - Modify data

Knowledge check

Summary