Sessions

Querying with Transact-SQL: (00) Course Introduction

Querying with Transact-SQL: (00) Course Introduction

2 years ago
Learn about the goals of the course and how to set up an Azure SQL Database environment for the labs that you will complete during subsequent modules.
Querying with Transact-SQL: (01) Introduction to Transact-SQL

Querying with Transact-SQL: (01) Introduction to Transact-SQL

2 years ago
Find out how to set up a sample database in Microsoft Azure SQL Database to use in the supplementary labs for this course. Then, learn how to use the SELECT statement in Transact-SQL to create basic queries that return data from tables in a database.
Querying with Transact-SQL: (02) Querying Tables with SELECT

Querying with Transact-SQL: (02) Querying Tables with SELECT

2 years ago
Build on the basic SELECT syntax discussed in the previous module to learn how to sort and filter query results with the ORDER BY and WHERE clauses.​ ​
Querying with Transact-SQL: (03) Querying Multiple Tables with Joins

Querying with Transact-SQL: (03) Querying Multiple Tables with Joins

2 years ago
Explore the concept of joins in relational database queries, and then hear how to implement inner, outer, cross, and self joins by using the JOIN clause.
Querying with Transact-SQL: (04) Using Set Operators

Querying with Transact-SQL: (04) Using Set Operators

2 years ago
Learn how to combine sets of data returned by queries by using the UNION operator.​
Querying with Transact-SQL: (05) Using Functions and Aggregating Data

Querying with Transact-SQL: (05) Using Functions and Aggregating Data

2 years ago
Get to know commonly used built-in functions, and find out how to use them. Learn to use aggregate functions to summarize data, and work with the GROUP BY clause to retrieve grouped aggregations.​
Querying with Transact-SQL: (06) Using Subqueries and APPLY

Querying with Transact-SQL: (06) Using Subqueries and APPLY

2 years ago
Get the details on including subqueries within a query, and see how to work with correlated subqueries and the APPLY operator to use the results from one query in another.​
Querying with Transact-SQL: (07) Using Table Expressions

Querying with Transact-SQL: (07) Using Table Expressions

2 years ago
Learn various techniques that can be used to create tabular structures in Transact-SQL, including views, temporary tables, table variables, table-valued functions, and common table expressions (CTEs).
Querying with Transact-SQL: (08) Grouping Sets and Pivoting Data

Querying with Transact-SQL: (08) Grouping Sets and Pivoting Data

2 years ago
Find out how to use the GROUPING SET subclause of the GROUP BY clause to specify multiple groupings in a single query. Then, see how to use the PIVOT and UNPIVOT operators to switch the orientation of data between column-oriented and row-oriented.
Querying with Transact-SQL: (09) Modifying Data

Querying with Transact-SQL: (09) Modifying Data

2 years ago
Get the details on modifying data in tables by using the INSERT, UPDATE, and DELETE statements.
Querying with Transact-SQL: (10) ​Programming with Transact-SQL

Querying with Transact-SQL: (10) ​Programming with Transact-SQL

2 years ago
Learn to create Transact-SQL scripts that include programmatic constructs, such as conditional logic and loops.
Querying with Transact-SQL: (11) Error Handling and Transactions

Querying with Transact-SQL: (11) Error Handling and Transactions

2 years ago
Find out how to create Transact-SQL code that includes error handling. Learn about concept of a transaction and how to implement explicit transactions in Transact-SQL code.