This training is designed for professionals who manage or plan to manage SQL Server databases within Microsoft Azure. It covers deployment, configuration, security, performance tuning, and high availability solutions for both cloud-native and hybrid environments. Students also gain hands-on skills in T-SQL-based administrative tasks.
Basic Azure knowledge (Azure Fundamentals)
Familiarity with T-SQL and Azure Data Fundamentals
Basic querying and interpreting SQL results
Azure database administrators
Data professionals managing hybrid/cloud data platforms
Developers working with SQL-based systems
Engineers focused on performance, security, and continuity
By the end of this training, you will have gained knowledge and skills in the following areas:
Administering Azure SQL via portal, PowerShell, CLI, ARM
Manual and scripted deployment of SQL resources
Configuring authentication & authorization
Implementing security (at rest & in transit)
Monitoring performance metrics and optimization
Scheduling tasks and creating alert systems
Implementing High Availability and Disaster Recovery strategies
Overview of SQL options in Azure, compatibility levels, and Azure DB types.
Hands-on deployment of Azure SQL Database, Managed Instance, PostgreSQL, and MySQL.
Encryption methods, AAD integration, firewalls, and data compliance policies.
Performance metrics, baselines, tuning tools, and fragmentation resolution.
Execution plan analysis, Query Store, indexing strategies, and database design review.
Using templates, automation scripts, alerts, and scheduled maintenance jobs.
Geo-replication, backup strategies, RPO/RTO planning, and implementation labs.
Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.