Interested in a private company training? Request it here.
Azure SQL is a relational database service in the Microsoft cloud based on Microsoft SQL Server. In this introduction module, participants are introduced to the Azure SQL offering and concepts like Service Tiers, DTU's and the pricing of Azure SQL.
In this module, participants will learn how to create Azure SQL Servers and Databases. Once the Azure SQL Server and Azure SQL Databases are up and running, Firewall rules must be configured to allow client applications to connect to the Azure SQL Databases.
Azure SQL Managed Instance is a cloud database service that combines the broadest SQL Server database engine compatibility. Students will learn about the key differences between an On-Premises SQL Server and and Azure SQL Managed Instance, how to provision and configure an Azure SQL Managed Instance,....
Before you can create and manage databases, you should understand how data is stored in them, know about the different types of files that SQL Server can utilize.
In this module students will learn how on-premises SQL Server databases can be migrated to Azure SQL.
A common application pattern in building SaaS applications is to provision a single database for each customer. But different customers often have varying usage patterns making it difficult to predict the resource requirements for each individual database. Elastic Database Pools solve this problem by allowing you to purchase resources for a pool of databases. Within a Database Pool, each database can then request resources between specified minimum and maximum parameters.
Authentication requires that users must prove their identity before they can login to an Azure SQL Server or Database. Authorization is used to control what users can do and see inside an Azure SQL Database. Participants will learn how they can work Logins and Users to configure the security of Azure SQL
Azure SQL Database and Azure SQL Managed Instance secure customer data by providing auditing and threat detection capabilities. This module covers how you can secure your data using features like Always Encrypted, Azure Defender for SQL,... You will also learn how you can audit user access to Azure SQL
Azure SQL provides several ways for you to monitor your databases for issues, as well as look for ways to improve performance. You can create alerts using Microsoft Azure Monitor with metrics such as DTU, Database size percentage, and Deadlocks. You can also help improve your performance by using tools such as Query Performance Insight.
This chapter will introduce you to backup and restore with Azure SQL Databases and Azure SQL Managed Instances. You'll learn about automated and manual backups, explore automated backup features, and perform the manual backup of an Azure SQL Managed Instance
This module describes the capabilities that Azure SQL Database provides for business continuity and disaster recovery. Students will learn about the backup and restore features of an Azure SQL Database, how to setup geo-replication of Azure SQL Databases.
Participants of this course will learn from both a DBA and database developer's perspective how to setup and implement Azure SQL databases. The complete database lifecycle from creating and configuring your servers and databases, developing new database objects or migrating existing databases and client applications will be covered.
This 4-day course is intended for database administrators and database developers who want to create and manage Azure SQL databases or managed instances. Also those considering migrating on-premises solutions to the cloud will benefit from this training. Participants of this course are advised to have a basic understanding of relational databases.