Hands-on training of Azure SQL Database for IT Architect with demonstrations, downloadable papers and scripts
What you'll 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
Requirements
No Microsoft Azure experience needed. You can learn how to create Azure tenant and account in this course.
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. IntroductionGain a fundamental understanding of Azure SQL Database. Understand the difference between Azure SQL Database, SQL Managed Instance and SQL virtual machine.2. Performance & ScalabilityUnderstand "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-toleranceUnderstand architecture of each availability model, and how to implement "High Availability and Disaster Recovery". Learn Azure SQL Database backup/restore mechanism.4. SecurityExplore Azure SQL Database comprehensive security functionalities, including authentication/authorization, service/private endpoint, always encrypted, dynamic data masking, ledger table, auditing.5. Portability and DeploymentLearn 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 TroubleshootingLearn about Azure SQL Databases built-in monitoring and troubleshooting tools such as dashboard using metrics, alerts, dynamic management views (DMV) and extended events.
Who this course is for
The course is ideal for IT Architects, Database Administrators, Developers, and anyone interested in designing and managing Azure SQL Database solutions.
Homepage

https://www.udemy.com/course/hands-on-azure-sql-database-training-for-it-architect/

Related Downloads :

{related-news}