Deploy, secure, optimize, and manage high-performance Azure SQL solutions
The course covers the fundamentals of SQL Server and Azure SQL, the planning and deployment of solutions in cloud, on‑premises, and hybrid environments, database administration and security, performance monitoring and optimization, as well as backup, high availability, and disaster recovery strategies.
Is it for you ?
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.
Prerequisites
Technical knowledge of Azure Fundamentals and Azure Data Fundamentals.
What You'll Walk Away With
- ✓ Deploy and configure Azure SQL solutions across IaaS and PaaS environments
- ✓ Implement comprehensive security controls including authentication, authorization, encryption, and compliance
- ✓ Monitor and optimize database and query performance using best practices and tools
- ✓ Automate administrative tasks with SQL Server Agent and Azure automation methods
- ✓ Design high availability and disaster recovery strategies including backup and restore
Training content
1 Role of the Azure database administrator
- Azure Data Platform Roles
- Azure database platforms and options
- SQL Server compatibility level
- Azure Preview features
2 Plan and implement data platform resources
- Deploying SQL Server on a virtual machine
- Deploying a PaaS solution
- Deploying MariaDB, MySQL, and PostgreSQL on Azure
3 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
4 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
5 Optimize query performance
- Overview of SQL Server query plans
- Explore performance‑based database design
- Evaluate performance improvements
6 Task automation
- Configure automated deployment
- Define scheduled tasks with SQL Server Agent
- Configure extended events
- Manage Azure PaaS resources using automated methods
7 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
📌 Practical information
Our training sessions are offered in Montreal or Quebec City, in person or in a virtual classroom. Dates and locations are specified when you select your session below. If you have any questions, check out our FAQ.