{"product_id":"administering-microsoft-azure-sql-solutions-dp-300-certification-training","title":"Implement scalable database solutions using Azure SQL (DP-300)","description":"\u003cdiv\u003e\u003cp\u003eThis Implement scalable database solutions using Azure SQL (DP-300)\u003cb\u003e \u003c\/b\u003e\u003cb\u003ecertification \u003c\/b\u003ecourse provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be helpful to individuals who develop applications that deliver content from SQL-based relational databases.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eImplement scalable database solutions using Azure SQL (DP-300) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cb\u003eIn this Administering Microsoft Azure SQL Solutions (DP-300) course, you will learn how to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePlan, deploy and configure Azure SQL offerings.\u003c\/li\u003e\n\u003cli\u003eMonitor database performance and tune a database and queries for optimum performance.\u003c\/li\u003e\n\u003cli\u003ePlan and configure a High Availability Solution.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cb\u003eAdministering Microsoft Azure SQL Solutions (DP-300) Prerequisites\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eSuccessful Azure Database Administrators start this role with professional experience in database management and technical knowledge of cloud technologies. Specifically: \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWorking with, maintaining, and developing with SQL Server \u003c\/li\u003e\n\u003cli\u003eExperience with Azure, such as deploying and managing resources \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eAt a minimum, you should know the information in the following courses before attending the course:\u003ca title=\"Microsoft Azure Data Fundamentals Training (DP-900)\" href=\"https:\/\/www.learningtree.com\/courses\/microsoft-azure-data-dp-900-training\/\"\u003e\u003c\/a\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIntroduction to Cloud Infrastructure (AZ-900)\u003c\/li\u003e\n\u003cli\u003eMicrosoft Azure Data Fundamentals Training (DP-900)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cb\u003eAdministering Microsoft Azure SQL Solutions (DP-300) Exam Information\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eThis course can help you prepare for the following Microsoft role-based certification exam — \u003ca title=\"Exam DP-300: Microsoft Certified: Azure Database Administrator Associate\" target=\"_blank\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/exams\/dp-300\" rel=\"nofollow noopener\"\u003eExam DP-300: Microsoft Certified: Azure Database Administrator Associate\u003c\/a\u003e.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eDP-300 Certification Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLearning Objectives\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003ePlan and implement data platform resources\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003ePrepare to maintain SQL Server-based databases on Azure\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the role of Azure Database Administrator as it fits in with other data platform roles.\u003c\/li\u003e\n\u003cli\u003eDescribe the key differences between the SQL Server-based database options in Azure.\u003c\/li\u003e\n\u003cli\u003eDescribe other features for Azure SQL platforms available.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDeploy IaaS solutions with Azure SQL\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eExplore the basics of SQL Server in an Infrastructure as a Service (IaaS) offering\u003c\/li\u003e\n\u003cli\u003eLearn the available options for provisioning and deployment\u003c\/li\u003e\n\u003cli\u003eDeploy SQL Server into an Azure Virtual Machine\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDeploy PaaS solutions with Azure SQL\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eGain an understanding SQL Server in a Platform as a Service (PaaS) offering\u003c\/li\u003e\n\u003cli\u003eUnderstand PaaS provisioning and deployment options\u003c\/li\u003e\n\u003cli\u003eUnderstand elastic pools\u003c\/li\u003e\n\u003cli\u003eExamine Azure SQL Managed Instances\u003c\/li\u003e\n\u003cli\u003eConfigure a template for PaaS deployment\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eMigrate SQL Server workloads to Azure SQL Database\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eExplore the advantages, capabilities, and migration possibilities offered by Azure SQL Database.\u003c\/li\u003e\n\u003cli\u003eMigrate databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities.\u003c\/li\u003e\n\u003cli\u003eUse transactional replication as an online method to migrate to Azure SQL Database.\u003c\/li\u003e\n\u003cli\u003eExplore several other methods for migrating SQL Server databases to Azure SQL Database.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eMigrate SQL Server workloads to Azure SQL Managed Instance\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eExplore the advantages, capabilities, and migration possibilities offered by Azure SQL Managed Instance.\u003c\/li\u003e\n\u003cli\u003eLearn how Log Replay Service works to migrate to Azure SQL Managed Instance.\u003c\/li\u003e\n\u003cli\u003eUnderstand how Managed Instance link feature works in a migration scenario.\u003c\/li\u003e\n\u003cli\u003eLoad and move data to and from Azure SQL Managed Instance.\u003c\/li\u003e\n\u003cli\u003eExplore several other methods for migrating SQL Server databases to Azure SQL Database.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eImplement a secure environment for a database service\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eConfigure database authentication and authorization\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eLearn about authentication options for Azure SQL\u003c\/li\u003e\n\u003cli\u003eCreate various security principals\u003c\/li\u003e\n\u003cli\u003eConfigure permissions within a SQL database\u003c\/li\u003e\n\u003cli\u003eIdentify authentication and authorization failures\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eProtect data in-transit and at rest\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the data encryption options available in the various platforms\u003c\/li\u003e\n\u003cli\u003eImplement object level encryption\u003c\/li\u003e\n\u003cli\u003eUnderstand the difference between database and server firewall rules for Azure SQL Database\u003c\/li\u003e\n\u003cli\u003eExplore Always Encrypted with secure enclaves\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eImplement compliance controls for sensitive data\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003ePlan and implement data classification in Azure SQL Database\u003c\/li\u003e\n\u003cli\u003eUnderstand and configure row-level security and dynamic data masking\u003c\/li\u003e\n\u003cli\u003eUnderstand the usage of Microsoft Defender for SQL\u003c\/li\u003e\n\u003cli\u003eExplore how Ledger works\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eMonitor and optimize operational resources in Azure SQL\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDescribe performance monitoring\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eReview potential performance issues.\u003c\/li\u003e\n\u003cli\u003eIdentify critical Azure metrics.\u003c\/li\u003e\n\u003cli\u003eLearn how to collect metrics for an established baseline.\u003c\/li\u003e\n\u003cli\u003eUse extended events for performance analysis.\u003c\/li\u003e\n\u003cli\u003eUnderstand database watcher for Azure SQL Database and Azure SQL Managed Instance.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eConfigure SQL Server resources for optimal performance\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand your options for configuration of Azure storage\u003c\/li\u003e\n\u003cli\u003eLearn how to configure TempDB data files in SQL Server\u003c\/li\u003e\n\u003cli\u003eLearn how to choose the right type of VM for SQL Server workloads\u003c\/li\u003e\n\u003cli\u003eUnderstand the use cases and configuration of Resource Governor in SQL Server\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eConfigure databases for optimal performance\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand database scoped configuration options\u003c\/li\u003e\n\u003cli\u003eUnderstand maintenance tasks related to indexing and statistics\u003c\/li\u003e\n\u003cli\u003eUnderstand the features of Intelligent Query Processing (IQP)\u003c\/li\u003e\n\u003cli\u003eExplore the automatic tuning feature in Azure\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eOptimize query performance in Azure SQL\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eExplore query performance optimization\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eGenerate and save execution plans\u003c\/li\u003e\n\u003cli\u003eCompare the different types of execution plans\u003c\/li\u003e\n\u003cli\u003eUnderstand how and why query plans are generated\u003c\/li\u003e\n\u003cli\u003eExplain the purpose and benefits of the Query Store\u003c\/li\u003e\n\u003cli\u003eInvestigate the available reports and data in the Query Store\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eExplore performance-based database design\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eExplore normal forms and how they affect database design\u003c\/li\u003e\n\u003cli\u003eChoose appropriate datatypes for your data\u003c\/li\u003e\n\u003cli\u003eEvaluate appropriate index types\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eEvaluate performance improvements\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eDetermine when changing indexes or defining new ones can affect performance\u003c\/li\u003e\n\u003cli\u003eEvaluate wait statistics as an aid in finding areas for performance improvement\u003c\/li\u003e\n\u003cli\u003eUnderstand how query hints work, and when to use them\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eAutomate database tasks for Azure SQL\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eAutomate database deployment\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe the deployment models available on Azure\u003c\/li\u003e\n\u003cli\u003eDeploy database resources using PowerShell and Azure CLI\u003c\/li\u003e\n\u003cli\u003eDeploy an Azure Resource Manager template and Bicep\u003c\/li\u003e\n\u003cli\u003eUnderstand the difference between multiple command-line options\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eCreate and manage SQL Agent jobs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eSchedule necessary maintenance activities for your databases.\u003c\/li\u003e\n\u003cli\u003eConfigure notifications and alerts on SQL Server Agent jobs, and SQL Server.\u003c\/li\u003e\n\u003cli\u003eConfigure alerts based on performance monitor values.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eManage Azure PaaS tasks using automation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the benefits of Azure policy\u003c\/li\u003e\n\u003cli\u003eExplore the capabilities of Azure Automation\u003c\/li\u003e\n\u003cli\u003eConfigure elastic jobs\u003c\/li\u003e\n\u003cli\u003eUse Logic Apps for database workflow\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003ePlan and implement a high availability and disaster recovery environment\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe High Availability and Disaster Recovery Strategies\u003c\/li\u003e\n\u003cli\u003eDescribe recovery time objective (RTO) and recovery point objective (RPO)\u003c\/li\u003e\n\u003cli\u003eExplore high availability and disaster recovery options\u003c\/li\u003e\n\u003cli\u003eDescribe Azure high availability and disaster recovery features for Virtual Machines\u003c\/li\u003e\n\u003cli\u003eDescribe high availability and disaster recovery for PaaS deployments\u003c\/li\u003e\n\u003cli\u003eExplore high availability and disaster recovery solutions for IaaS\u003c\/li\u003e\n\u003cli\u003eDescribe hybrid solutions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eExplore IaaS and PaaS Solutions for High Availability and Disaster Recovery\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe failover clusters in Windows Server\u003c\/li\u003e\n\u003cli\u003eConfigure Always On Availability Groups\u003c\/li\u003e\n\u003cli\u003eDescribe active geo-replication for Azure SQL Database\u003c\/li\u003e\n\u003cli\u003eExplore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance\u003c\/li\u003e\n\u003cli\u003eMonitor availability\u003c\/li\u003e\n\u003cli\u003eExercise: Configure geo-replication for Azure SQL Database\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eBack Up and Restore Databases\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBack up and restore SQL Server running on Azure virtual machines\u003c\/li\u003e\n\u003cli\u003eBack up a SQL Server virtual machine\u003c\/li\u003e\n\u003cli\u003eBack up and restore a database for SQL Database and SQL Managed Instance\u003c\/li\u003e\n\u003cli\u003eExercise: Backup to URL\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"268B95US \/ 2026-08-04T09:00:00 \/ Herndon, VA","offer_id":47534216970459,"sku":"US-8576-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26AB24US \/ 2026-10-27T09:00:00 \/ Herndon, VA","offer_id":48216592351451,"sku":"US-8576-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"272A92US \/ 2027-02-02T09:00:00 \/ Herndon, VA","offer_id":48216592384219,"sku":"US-8576-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"275B26US \/ 2027-05-04T09:00:00 \/ Herndon, VA","offer_id":48738855518427,"sku":"US-8576-IL","price":2512.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/administering-microsoft-azure-sql-solutions-dp-300-certification-training","provider":"Learning Tree International","version":"1.0","type":"link"}