Working with Microsoft Azure SQL: Using Transact-SQL for Queries & Transactions
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 youll be able to use Transact-SQL to query data and launch transactions for Azure SQL Database.