DP-300T00: Administering Microsoft Azure SQL Solutions

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

The DP-300T00: Administering Microsoft Azure SQL Solutions course is designed for individuals who aspire to the role of Azure Database Administrator and want to learn about administering the data platform technologies that are available on Microsoft Azure. This course teaches the participants how to plan and implement data platform resources, manage and secure data, monitor and optimize operational resources, optimize query performance, and automate tasks.Through a comprehensive curriculum, learners will gain in-depth knowledge of various Azure database platforms and options, including IaaS and PaaS deployment models, SQL Server compatibility levels, and the implementation of high availability and disaster recovery strategies. The course includes practical labs such as using Azure Portal and SQL Server Management Studio, deploying Azure SQL Database, and configuring security and performance features.By completing this course, learners will be prepared to manage Azure SQL databases effectively and ensure their optimal performance, security, and compliance. Additionally, they will be equipped with the necessary skills to automate tasks, optimize query performance, and implement a high availability and disaster recovery environment, thus ensuring business continuity and data protection.

Show More

What Will You Learn?

  • Understand the roles and responsibilities of an Azure Database Administrator, including managing data platform resources on Azure.
  • Provision and configure SQL Server instances on both Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS) offerings.
  • Implement and manage security measures for authentication, authorization, data at rest, and data in transit within Azure SQL environments.
  • Monitor performance, establish baselines, and configure resources for optimal database operation and maintenance.
  • Optimize query performance by analyzing SQL Server query plans, database design, and applying performance improvements.
  • Automate routine tasks using Azure services and tools such as ARM templates, Azure Automation Runbooks, and Elastic Jobs.
  • Develop and implement high availability and disaster recovery strategies for Azure SQL databases utilizing IaaS and PaaS tools, including Always On Availability Groups and Geo-Replication.
  • Deploy and manage open-source database solutions on Azure, ensuring compatibility and connectivity with existing client tools.
  • Enforce compliance and manage sensitive data through advanced security features like data classification and advanced data security.
  • Apply knowledge to real-world scenarios in hands-on labs, including deploying Azure SQL Database, configuring firewalls, managing performance issues, and executing disaster recovery plans.