• Online, Self-Paced
Course Description

Transact-SQL (T-SQL) is a powerful query language that applies to all databases with a SQL engine. It can be used to run a variety of different operations against Azure SQL Database. Through this course, learn about the Transact-SQL language and how to query data, create table partitions, and launch transactions against Azure SQL Database.

Discover how to load CSV file data into a new Azure SQL Database table and query and execute aggregations on that data. Next, learn how to implement and validate table partitioning, use Transact-SQL to define and execute transactions, and use rollbacks and savepoints. Finally, practice setting isolation levels for transactions.

After course completion, you'll be able to use Transact-SQL to query data and launch transactions for Azure SQL Database.

Learning Objectives

{"discover the key concepts covered in this course"}

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Network Services