DP-300: Administering Microsoft Azure SQL SolutionsAs a candidate for this certification, you should have subject matter expertise in building database solutions that are designed to support multiple workloads built with:SQL Server on-premisesAzure SQL servicesYou’re a database administrator who manages on-premises and cloud databases built with SQL Server and Azure SQL services.As the Azure database administrator, you implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services. You use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes.You’re responsible for the following concerning database solutions:ManagementAvailabilitySecurityPerformance monitoring and optimizationYou evaluate and implement migration strategies for moving databases between Azure and on-premises. Plus, you work with Azure data engineers, Azure solution architects, Azure developers, data scientists, and other professionals to manage operational aspects of data platform solutions.As a candidate for this certification, you should have knowledge of and experience with:Azure SQL DatabaseAzure SQL Managed InstanceSQL Server on Azure Virtual Machines (Windows and Linux)DP-300 Exam Topics :-Plan and implement data platform resources (20–25%)Plan and deploy Azure SQL solutionsDeploy database offerings on selected platformsUnderstand automated deploymentApply patches and updates for hybrid and infrastructure as a service (IaaS) deploymentDeploy hybrid SQL Server solutionsReco
What you'll learn
understanding Azure SQL Database
implementing migration strategies
managing database performance
using Transact-SQL for administrative tasks
Course objectives
prepare for the DP-300 certification exam
learn to deploy and manage Azure SQL solutions
understand operational management of database solutions