Administering Microsoft Azure SQL Solutions (DP-300)
About This Course
This course, Administering Microsoft Azure SQL Solutions (DP-300), provides comprehensive training on maintaining, securing, and optimizing SQL databases on Azure. Participants will develop efficient data processes, design secure environments, and implement robust data integration procedures tailored to business requirements.
The course covers a wide range of topics, including deploying SQL Server in Azure, migrating SQL workloads, configuring database security, monitoring performance, and automating database tasks. Additionally, it emphasizes high availability and disaster recovery strategies, ensuring participants are well-equipped to handle various database scenarios in Azure environments.
What You'll Learn
LO1: Develop efficient processes and data warehouse process models for Azure SQ in accordance to business requirements.
LO2: Design data validation and staging databases for Azure SQL.
LO3: Design and verify an extraction process for Azure SQL that consolidates in accordance to business rules.
LO4: Design a transformation and loading process for Azure SQL in accordance to business rules.
LO5: Develop data integration procedure and translate business requirements into Azure SQL data structure.
Topics Covered:
LU1: Introduction to Azure Database Administration
LU2: Implement a Secure Environment for a Database Service
LU3: Monitor and Optimize Operational Resources in Azure SQL
LU4: Automate Database Tasks for Azure SQL
LU5: Plan and Implement a High Availability and Disaster Recovery Environment
Entry Requirements
Knowledge and Skill
• Able to operate using computer functions
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
• Positive Learning Attitude
• Enthusiastic Learner
Experience
• Minimum of 1 year of working experience
Target age group: 21-65 years old