DP-080: Querying Data with Microsoft Transact-SQL Training

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.

After completing this module, you'll be able to:

• Understand what SQL is for
• Identify database objects in schemas
• Identify SQL statement types
• Use the SELECT statement
• Work with data types
• Handle NULLs

Learn how to sort and filter query results

After completing this module, you will be able to:

• Sort your results
• Limit the sorted results
• Return paged results
• Remove duplicates
• Filter data with predicates

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

After completing this module, you will be able to:

• Describe join concepts and syntax
• Write queries that use inner and outer joins
• Write queries that use cross joins
• Write queries that use self joins

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

After completing this module, you will be able to:

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

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

After completing this module, you will be able to:

• Categorize built-in functions
• Use scalar functions
• Use ranking and rowset functions
• Use aggregate functions
• Summarize data with GROUP BY
• Filter groups with HAVING

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

After completing this module, you will be able to:

• Insert data into a table
• Generate automatic values
• Update data in a table
• Delete data from a table
• Merge data based on multiple tables