Training: Microsoft Azure SQL Database

Azure SQL is a family of offerings on Azure that use SQL Server as the database engine. Azure SQL Database is one of those offerings and is a fully managed database service with a serverless option. Through this course, learn how to get started with Azure SQL and set up an Azure SQL Database instance. Explore relational and NoSQL databases, what Azure SQL is, and the primary benefits of Azure SQL. Next, learn about Azure SQL Databases, how to configure a database to manage performance and costs, and its purchasing models and service tiers. Finally, discover how to create, configure, connect to, and query database instances. Upon completion, you'll be able to outline Azure SQL and Azure SQL Database.

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.

Change data capture (CDC) is an Azure feature that records any modifications to the contents of a tracked table. Azure SQL Database integrates with change data capture, as well as many other Azure cloud services and features. Through this course, learn how Azure SQL Database integrates with change data capture, Azure Functions, and JSON data. Discover how to enable change data capture for a database and view the tracked changes. Next, practice using Azure Functions to respond to an HTTP request and set up a development environment with Visual Studio Code. Finally, learn how to create a table to store JSON data and query and modify that data. Upon completion, you'll be able to utilize some advanced features of Azure SQL Database.