Inhalt des Trainings
This offering is designed to provide you with the knowledge and tools to understand the capabilities and usage of cloud databases. You will become familiar with Azure SQL Database concepts, including how to migrate, manage, monitor, and troubleshoot your Azure SQL Database solution.
Objectives
- Review different purchase models, service tiers compute and hardware generation
- Discuss the vertical and horizontal scaling options
- Learn how to monitor, troubleshoot and resolve issues and review migration methods
- Examine the administration, maintenance, disaster recovery options, security and encryption
Outcomes
- Move an SQL workload to Azure SQL Database and manage the workload
Detail-Inhalte
Day 1
Introduction to Azure SQL Database
- Azure SQL Database fundamentals and creating a database
Azure SQL Database Administration
- Various Tools to Manage Azure SQL Database
- Scaling Azure SQL Databases Up and Down and Azure SQL Database Read Scale-Out
Day 2
Azure SQL Database Business Continuity
- Business Continuity Features in Azure SQL Database
- Disaster Recovery Features in Azure SQL Database
Manage Security for Azure SQL Database
- Implement Azure Active Directory and Advanced Security
- Implement Firewall Rules and Virtual Networks, Transparent Data Encryption, Always Encrypted, Row Level Security, Dynamic Data Masking, Auditing for Azure SQL Database
Day 3
Monitoring and Tuning Azure SQL Database
- Monitor Query Performance using Query Performance Insight
- Azure SQL Database Tuning using Automatic Tuning
- Monitor Azure SQL Database Performance using Intelligent Insights and Extended Events and configuring alerts
Azure SQL Database Migration & Sync Data
- Fix database migration compatibility issues
- Identify the right Azure SQL Database SKU
- Migrate a compatible SQL Server database to Azure SQL Database
- Sync data across multiple cloud and on-premises databases