Objectives of the training
At the end of this course, the participant will be able to administer, secure, and optimize SQL Server and Azure SQL databases in cloud, on‑premises, and hybrid environments, while ensuring the performance, availability, and reliability of the solutions.Targeted audience
This training is intended for data professionals, architects, and application developers who want to master the administration and use of Microsoft Azure data platform technologies.Prerequisite
Technical knowledge of Azure Fundamentals and Azure Data Fundamentals.Trainers
Benefits for Participants
• Plan, deploy, and configure Azure SQL offerings
• Explain database performance monitoring and the configuration of a database and queries for optimal performance
Course architecture
Role of the Azure database administrator
• Azure Data Platform Roles
• Azure database platforms and options
• SQL Server compatibility level
• Azure Preview features
Plan and implement data platform resources
• Deploying SQL Server on a virtual machine
• Deploying a PaaS solution
• Deploying MariaDB, MySQL, and PostgreSQL on Azure
Implement a secure environment for a database service
• Configure database authentication
• Configure database authorization
• Implement security for data at rest
• Implement security for data in transit
• Implement compliance controls for sensitive data
Monitor and optimize operational resources
• Performance baselines and monitoring
• Main causes of performance issues
• Configure resources for optimal performance
• Configure the user database
• Maintenance tasks related to performance
Optimize query performance
• Overview of SQL Server query plans
• Explore performance‑based database design
• Evaluate performance improvements
Task automation
• Configure automated deployment
• Define scheduled tasks with SQL Server Agent
• Configure extended events
• Manage Azure PaaS resources using automated methods
Plan and implement a high availability and disaster recovery environment
• High availability and disaster recovery strategies
• IaaS platform and database tools for HADR
• PaaS platform and database tools for HADR
• Database backup and recovery
Pedagogical details
Type of training
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quotePrivate or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote