Share Description
In this course, you will learn:
- Introduces Azure SQL. Learn about the different deployment choices and service tiers, as well as which ones are best for your organization.
- Set up servers, instances, and databases for Azure SQL.
- Azure SQL helps you secure your data.
- Azure SQL provides constant performance.
- Learn how to deploy highly available systems with Azure SQL. You will also investigate architectures and how they impact availability.
- Putting it all together with Azure SQL.
Syllabus:
- Introduction to Azure SQL
- Azure SQL history
- Azure SQL deployment options
- Purchasing models, service tiers, and hardware choices
- Management interfaces for Azure SQL
- Deploy and configure servers, instances, and databases for Azure SQL
- Plan, deploy, and verify Azure SQL
- Exercise - Deploy Azure SQL Database
- Exercise - Verify Azure SQL Database
- Configure Azure SQL Database and Azure SQL Managed Instance
- Exercise - Configure Azure SQL Database
- Load data into Azure SQL
- Exercise - Load data into Azure SQL Database
- Secure your data with Azure SQL
- Security capabilities and tasks
- Exercise - Configure auditing
- Exercise - Secure your network
- Exercise - Configure authentication
- Protect your data
- Manage your security
- Exercise - Manage security and Microsoft Defender for Cloud
- Exercise - Data classification, dynamic data masking, and SQL audit
- Deliver consistent performance with Azure SQL
- Performance capabilities
- Configure and maintain performance
- Monitor and troubleshoot performance
- Exercise - Monitor and troubleshoot performance
- Accelerate and tune performance
- Exercise - Scale the performance of your workload
- Exercise - Optimize application performance
- Intelligent performance
- Deploy highly available solutions by using Azure SQL
- Backup and restore
- Exercise - Restore to a point in time
- High availability by service tier
- Exercise - General purpose high availability
- Exercise - Business critical high availability
- Going further with availability
- Exercise - Geo-distributed auto-failover groups with read-scale
- Availability and consistency
- Configure and monitor availability
- Putting it all together with Azure SQL
- Scenario 1 - Architect global scale and secure access
- Scenario 1 solution - Architect global scale and secure access
- Scenario 2 - Mission-critical application
- Scenario 2 solution - Mission-critical application
- Opportunities in Azure
