Hands-On : Azure SQL Database Training for IT Architect
Hands-on training of Azure SQL Database for IT Architect with demonstrations, downloadable papers and scripts
Ratings 5.00 / 5.00
What You Will Learn!
- Understanding Service tiers and Availability models of Azure SQL Database
- Learning about how to do scale-up and read scale-out
- Understanding elastic pool and elastic query
- Gaining an understanding of high availability and disaster recovery
- Learning about security-related features
- Understanding how to do automated deployment
- Learning about tools for monitoring and troubleshooting
Description
Azure SQL Database is Platform as a Service for Relational Database Management System (RDBMS) developed by Microsoft. This comprehensive training will equip you with the skills and knowledge needed to design and manage "Performance & Scalability", "Redundancy and Fault-tolerance", "Security", "Portability and Deployment" and "Monitoring and Troubleshooting".
1. Introduction
Gain a fundamental understanding of Azure SQL Database. Understand the difference between Azure SQL Database, SQL Managed Instance and SQL virtual machine.
2. Performance & Scalability
Understand "Service tiers and Availability models" of Azure SQL Database. Learn how to do scale-up/read scale-out can be done on each availability model, and implementing elastic pool and elastic query.
3. Redundancy and Fault-tolerance
Understand architecture of each availability model, and how to implement "High Availability and Disaster Recovery". Learn Azure SQL Database backup/restore mechanism.
4. Security
Explore Azure SQL Database comprehensive security functionalities, including authentication/authorization, service/private endpoint, always encrypted, dynamic data masking, ledger table, auditing.
5. Portability and Deployment
Learn how to do automated-deployment of Azure SQL Database with Azure DevOps Pipeline. Integrate Azure Key Vault and Azure DevOps Pipeline to mask credential information.
6. Monitoring and Troubleshooting
Learn about Azure SQL Databases built-in monitoring and troubleshooting tools such as dashboard using metrics, alerts, dynamic management views (DMV) and extended events.
Who Should Attend!
- The course is ideal for IT Architects, Database Administrators, Developers, and anyone interested in designing and managing Azure SQL Database solutions.