• Online, Self-Paced

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

Specialty Areas have been removed from the NICE Framework. With the recent release of the new NICE Framework data, updates to courses are underway. Until this course can be updated, this historical information is provided to give better context as to how it can help you with your cybersecurity goals.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.