Welcome to this hands-on Lab focused on Azure SQL Database - the intelligent, fully managed relational cloud database service built for developers. Accelerate app development and make maintenance easy and productive using the SQL tools you love to use.
You will need the following things in order to go through all the exercises:
- An Azure subscription. Your instructor will provide access credentials.
- SQL Server Management Studio 17.9 or newer, installed on your machine.
If you intend to also perfom a lift-and-shift database migration (Lab 2. Migrate Your On-premises Database to Azure), you will also need the following:
- A SQL Server instance, with an AdventureWorks database (2012 version) ready to be migrated to Azure SQL. Your instructor will provide access credentials to the server.
- Data Migration Assistant 3.4 or newer, installed on your machine.
This hands-on lab contains the following topics:
- Back up and restore an Azure SQL Database
- Performance troubleshooting for Azure SQL Database
- Scale Azure SQL Database
- Configure active geo-replication for Azure SQL Database
- Automatic Tuning
- Manage database access to SQL Database
- Audit an Azure SQL database
- Classify your Data for GDPR
- Vulnerability Assessment with Azure SQL Database
- Threat Detection with Azure SQL Database
- Encrypt the entire database with Transparent Data Encryption
- Reduce data exposure with Dynamic Data Masking
- Limit access to data with Row-Level Security
- Client-side encryption with Always Encrypted
- Track historical data with Temporal Tables