Introduction to Transact-SQL

This module provides an introduction to relational databases, the SQL language and Transact-SQL. You'll learn what kinds of statements make up the SQL language and look at the SELECT statement in detail.

• Work with schemas
• Explore the structure of SQL statements
• Examine the SELECT statement
• Work with data types
• Handle NULLs
• Exercise - Work with SELECT statements

Sort and filter results in T-SQL

Learn how to sort and filter query results

• Sort your results
• Limit the sorted results
• Page results
• Remove duplicates
• Filter data with predicates
• 3 min
• Exercise - Sort and filter query results

Combine multiple tables with JOINs in T-SQL

Explore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations.

• Understand joins concepts and syntax
• Use inner joins
• Use outer joins
• Use cross joins
• Use self joins
• Exercise - Query multiple tables with joins

Write Subqueries in T-SQL

Learn how to use subqueries to combine multiple SELECT statements and compose nested queries.

• Understand subqueries
• Use scalar or multi-valued subqueries
• Use self-contained or correlated subqueries
• Exercise - Use subqueries

Use built-in functions and GROUP BY in Transact-SQL

Learn how to use functions in Transact-SQL, and how to group aggregated results.

• 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

Modify data with T-SQL

Learn how to use Transact-SQL to insert, update, and delete data in a database.

• Insert data
• Generate automatic values
• Update data
• Delete data
• Merge data based on multiple tables
• Exercise - Modify data
• Module assessment