Course DP-300T00: Administering Microsoft Azure SQL Solutions

• Recognize how the Azure Database Administrator role interacts with other roles on data platforms.
• Explain the key differences between the SQL Server-based database options in Azure.
• Explain other features for Azure SQL platforms available.

• Investigate SQL Server's fundamentals through an Infrastructure as a Service (IaaS) program.
• Learn the available options for provisioning & Deployment
• Deploy SQL Server into an Azure Virtual Machine

• Gain an understanding of SQL Server in a Platform as a Service (PaaS) offering
• Understand PaaS provisioning & deployment options
• Understand elastic pools
• Examine Azure SQL Managed Instances
• Explore Azure SQL Edge
• Configure a template for PaaS deployment

• Evaluate different Azure migration options when moving your SQL environment to the Cloud.
• Understand how SQL Server compatibility level affects database behavior.
• Understand the differences between private & public preview options.

• Explain the considerations for a SQL Server to Azure SQL Database migration.
• Explain the methods & steps to perform an offline migration to Azure SQL Database.
• Explain the methods & steps to perform an online migration to Azure SQL Database.
• Explore the post-migration steps required to ensure service continuity of your database in backup, high availability, disaster recovery, & scalability.

• Explain the considerations for a SQL Server to Azure SQL Database migration.
• Explain the methods & steps to perform an offline migration to Azure SQL Database.
• Explain the methods & steps to perform an online migration to Azure SQL Database.
• Explore the post-migration steps required to ensure service continuity of your database in backup, high availability, disaster recovery, & scalability.

• Evaluate migration scenarios to Azure SQL Database Managed Instance
• Migrate to Azure SQL Database Managed Instance
• Load & move data to Azure SQL Database Managed Instance

• Learn about authentication options for Azure SQL Database
• Create various security principals
• Configure permissions within a SQL database
• Identify authentication & authorization failures

• Understand the data encryption options available in the various platforms
• Implement object-level encryption
• Understand the difference between database & server firewall rules for Azure SQL Database
• Explore Always Encrypted with secure enclaves

• Plan & implement data classification in Azure SQL Database
• Understand & configure row-level security & dynamic data masking
• Understand the usage of Microsoft Defender for SQL
• Explore how Azure SQL Database Ledger works

• Review potential performance issues.
• Identify critical Azure metrics.
• Learn how to collect metrics for an established baseline.
• Use extended events for performance analysis.
• Understand Azure SQL Database Intelligent Insights.

• Understand your options for the configuration of Azure storage
• Learn how to configure TempDB data files in SQL Server
• Understand how to choose the right type of VM for SQL Server workloads
• Understand the use cases & configuration of Resource Governor in SQL Server

• Understand database-scoped configuration options
• Understand maintenance tasks related to indexing & statistics
• Understand the features of Intelligent Query Processing (IQP)
• Explore the automatic tuning feature in Azure

• Generate & save execution plans
• Compare the different types of execution plans
• Understand how & why query plans are generated
• Explain the purpose & benefits of the Query Store
• Investigate the available reports & data in the Query Store

• Determine when changing or creating new indexes can have an impact on performance.
• Analyze for statistics to assist in identifying areas for performance improvement.
• Understand how query hints work, & when to use them

• Explore standard forms & how they affect database design
• Choose appropriate datatypes for your data
• Evaluate appropriate index types

• Explain the deployment models available on Azure
• Deploy database resources using PowerShell & Azure CLI
• Deploy an Azure Resource Manager template & Bicep
• Understand the difference between multiple comm&-line options

• Schedule necessary maintenance activities for your databases.
• Configure notifications & alerts on SQL Server Agent jobs, & SQL Server.
• Configure alerts based on performance monitor values.

• Understand the benefits of Azure policy
• Explore the capabilities of Azure Automation
• Configure elastic jobs
• Use Logic Apps for database workflow

• Define recovery time objective & recovery point objective
• Explore the available high availability & disaster recovery options for both IaaS & PaaS
• Devise an appropriate high availability & disaster recovery strategy

• Define recovery time objective & recovery point objective
• Explore the available high availability & disaster recovery options for both IaaS & PaaS
• Devise an appropriate high availability & disaster recovery strategy

• Explore options for deploying a WSFC in Azure
• Explore options for deploying an AG in Azure
• Implement Temporal Tables
• Plan active geo-replication & auto-failover groups

• Explore backup & restore options for IaaS
• Implement backup & fix for PaaS

Azure Fundamentals certification allows you to demonstrate your understanding of cloud concepts, Azure services, Azure workloads, Azure security and privacy, and Azure pricing and support.

Microsoft Azure, renamed Windows Azure in 2014, is a cloud computing platform created by Microsoft to enable the successful development, Deployment, and management of applications and services across a global network of data centers.

After successfully completing the Microsoft Azure Fundamentals exam, IT pros earn the Microsoft Certified Azure qualification. While this certification is not necessary to pursue more specialized Azure training but on the other h& it does provide essential knowledge & skills to streamline learning & completion.

PaaS is a computing platform that includes an operating system, programming language execution environment, database, or web services. Developers, as well as application providers, use this type of Azure service.

To attend the training session, you should have operational Desktops or Laptops with the required specification and a good internet connection to access the labs. 

We would always recommend you attend the live session to practice & clarify the doubts instantly & get more value from your investment. However, if, due to some contingency, you have to skip the class, Radiant Techlearning will help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption & NOT for distribution or commercial use.

Radiant Techlearning has a data center containing the Virtual Training environment for participants' h&-on-practice. 

Participants can easily access these labs over Cloud with the help of a remote desktop connection. 

Radiant virtual labs allow you to learn from anywhere in the world & in any time zone.

The learners will be enthralled as we engage them the real-world & industry Oriented projects during the training program. These projects will improve your skills & knowledge & you will gain a better experience. These real-time projects will help you a lot in your future tasks & assignments.