DP-300T00: Administering Relational Databases On Microsoft Azure
4 Days
RM 3,420 (before SST)
Remark:
Including labs & exams
Private in-house training applicable start from a minimum 5 pax up to maximum 25 pax per session.
The DP-300T00-A: Administering Microsoft Azure SQL Solutions course is a 4-day hands-on training designed for data professionals managing SQL databases in cloud, on-premises, and hybrid environments. It is ideal for database administrators, data architects, and developers seeking to optimize SQL workloads using Microsoft Azure tools and platforms.
Participants will explore both Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) options including Azure SQL Virtual Machines, Azure SQL Database, and Azure SQL Managed Instance. You'll gain practical experience in migrating SQL workloads using tools like Azure Data Studio, Log Replay Service, and transactional replication. Additionally, the course covers authentication and authorization models, data protection, and compliance controls such as Always Encrypted, Microsoft Defender for SQL, and Dynamic Data Masking.
Other key topics include performance monitoring with Query Store, Intelligent Query Processing, and automatic tuning, as well as index and storage optimization strategies. Learners also develop a solid foundation in database security, governance, and auditing using Azure-native features.
By the end of the course, you'll be equipped to manage and troubleshoot SQL environments efficiently and confidently in any deployment model. This course also supports preparation for the Microsoft Certified: Azure Database Administrator Associate certification.