Hands-On : Azure SQL Database Training for IT Architect

Hands-On : Azure SQL Database Training for IT Architect free download

Hands-on training of Azure SQL Database for IT Architect with demonstrations, downloadable papers and scripts

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.