DP-300T00: Administering Microsoft Azure SQL Solutions

Duration: 4 Days (32 Hours)

DP 300 : Administering Microsoft Azure SQL Solutions Course Overview:

The DP-300 course provides students with the knowledge and skills required to administer a SQL Server database infrastructure effectively. It covers deployment scenarios including cloud, on-premises, and hybrid relational databases, with a focus on Microsoft’s Platform as a Service (PaaS) offerings.

The course primarily focuses on database management and maintenance in various environments. Participants will learn essential administrative tasks such as database installation, configuration, and security implementation. They will also gain skills in monitoring and optimizing database performance, ensuring data availability and integrity.

The DP-300 course also caters to individuals involved in application development that relies on content delivery from SQL-based relational databases. Students will learn best practices for developing applications that efficiently utilize SQL Server databases, enabling them to deliver robust and high-performing content-driven solutions.

By the end of the course, students will have a comprehensive understanding of administering SQL Server database infrastructures in different deployment scenarios. Whether in the cloud, on-premises, or in hybrid environments, they will be equipped with the skills to ensure the smooth operation and optimal performance of relational databases. This knowledge will empower them to support a wide range of applications that rely on SQL-based content delivery.

Audience Profile:

The DP-300 course is primarily targeted towards data professionals who are responsible for managing data and databases and are interested in gaining knowledge about administering data platform technologies available on Microsoft Azure. This course is designed to provide these professionals with the necessary skills to effectively administer and maintain data platform solutions on Azure.
In addition to data professionals, the course also benefits data architects who need to understand the available technologies within the Azure data platform. It helps them gain insights into the capabilities and functionalities offered by Azure for data management and administration. This knowledge enables data architects to make informed decisions about designing data platform solutions using Azure services.
Furthermore, application developers will find value in this course as it provides an understanding of the various data platform technologies available on Azure and how to work with them through applications. This knowledge allows developers to leverage Azure’s data platform services effectively, ensuring efficient and seamless integration of data functionalities into their applications.
Overall, the DP-300 course caters to a wide range of professionals, including data professionals, data architects, and application developers. It equips them with the knowledge and skills required to administer data platform technologies on Microsoft Azure and effectively work with these technologies through applications.

Job role: Database Administrator

Certification Path:

Prepare to maintain SQL databases on Azure
  • Understand the role of Azure Database Administrator as it fits in with other data platform roles.
  • Describe the key differences between the SQL Server-based database options in Azure.
  • Describe other features for Azure SQL platforms available.
  • Explore the basics of SQL Server in an Infrastructure as a Service (IaaS) offering
  • Learn the available options for provisioning and deployment
  • Deploy SQL Server into an Azure Virtual Machine
  • Gain an understanding SQL Server in a Platform as a Service (PaaS) offering
  • Understand PaaS provisioning and 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 and public preview options.
  • Describe the considerations for a SQL Server to Azure SQL Database migration.
  • Describe the methods and steps to perform an offline migration to Azure SQL Database.
  • Describe the methods and 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, and scalability.
  • Evaluate migration scenarios to Azure SQL Database Managed Instance
  • Migrate to Azure SQL Database Managed Instance
  • Load and 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 and authorization failures
  • Understand the data encryption options available in the various platforms
  • Implement object level encryption
  • Understand the difference between database and server firewall rules for Azure SQL Database
  • Explore Always Encrypted with secure enclaves
  • Plan and implement data classification in Azure SQL Database
  • Understand and configure row-level security and 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 configuration of Azure storage
  • Learn how to configure TempDB data files in SQL Server
  • Learn how to choose the right type of VM for SQL Server workloads
  • Understand the use cases and configuration of Resource Governor in SQL Server
  • Understand database scoped configuration options
  • Understand maintenance tasks related to indexing and statistics
  • Understand the features of Intelligent Query Processing (IQP)
  • Explore the automatic tuning feature in Azure
  • Generate and save execution plans
  • Compare the different types of execution plans
  • Understand how and why query plans are generated
  • Explain the purpose and benefits of the Query Store
  • Investigate the available reports and data in the Query Store
  • Determine when changing indexes or defining new ones can affect performance
  • Evaluate wait statistics as an aid in finding areas for performance improvement
  • Understand how query hints work, and when to use them
  • Explore normal forms and how they affect database design
  • Choose appropriate datatypes for your data
  • Evaluate appropriate index types
  • Describe the deployment models available on Azure
  • Deploy database resources using PowerShell and Azure CLI
  • Deploy an Azure Resource Manager template and Bicep
  • Understand the difference between multiple command-line options
  • Schedule necessary maintenance activities for your databases.
  • Configure notifications and alerts on SQL Server Agent jobs, and SQL Server.
  • Configure alerts based on performance monitor values.
  • Undersand the benefits of Azure policy
  • Explore the capabilities of Azure Automation
  • Configure elastic jobs
  • Use Logic Apps for database workflow
  • Define recovery time objective and recovery point objective
  • Explore the available high availability and disaster recovery options for both IaaS and PaaS
  • Devise an appropriate high availability and 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 and auto-failover groups
  • Explore backup and restore options for IaaS
  • Implement backup and restore for PaaS

DP 300 : Administering Microsoft Azure SQL Solutions Course Overview:

Successful Azure Database Administrators start this role with professional experience in database management and technical knowledge of cloud technologies.  

Specifically: 

  • Working with, maintaining, and developing with SQL Server 
  • Experience with Azure, such as deploying and managing resources 

At a minimum, you should know the information in the following online training before attending the course:

Q: What is DP-300 Training?

A: DP-300 Training is a comprehensive program designed to provide participants with the knowledge and skills required to administer and manage Microsoft SQL Server databases. It covers various topics related to database installation, configuration, security, backup and recovery, high availability, and performance tuning.

A: DP-300 Training is intended for database administrators, system administrators, and IT professionals who are responsible for managing and administering SQL Server databases. It is suitable for individuals who have a basic understanding of SQL Server and want to deepen their expertise in database administration.

A: To fully benefit from DP 300 Training, participants should have a fundamental understanding of SQL Server and experience with database administration tasks. Familiarity with concepts such as database design, SQL queries, and database management systems will be helpful.

A: DP 300 Training covers a wide range of topics, including SQL Server installation and configuration, database security, backup and recovery strategies, high availability solutions such as Always On Availability Groups, database maintenance, performance tuning, and troubleshooting.

A: The duration of DP 300 Training can vary depending on the training provider and the format of the course. It can range from a few days to several weeks, with part-time or full-time study options available.

A: Yes, we offer DP300 Training in an online format, allowing you to learn at your own pace and convenience.

A: Yes, DP300 Training typically includes hands-on exercises that allow participants to practice database administration tasks in a simulated environment. These exercises may involve tasks such as database configuration, security implementation, backup and recovery procedures, and performance tuning.

A: Yes, upon completing DP300 Training, you may receive a certificate of completion or participation from the training provider. However, it’s important to note that the DP300 certification is obtained by passing the official Microsoft DP300 exam, which is separate from the training course.

A: DP 300 Training is designed to cover the topics and concepts relevant to the DP 300 exam. However, it is recommended to supplement the training with additional study materials, practice exams, and hands-on experience to ensure thorough preparation for the exam.

A: In addition to DP300 Training, you can find additional study materials on the official Microsoft Learning website, including exam guides, documentation, and online resources. Microsoft also offers practice exams and official study guides specifically tailored for the DP 300 exam.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability

Classroom

  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention

Onsite

  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Microsoft Certified Trainers (MCT).
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.
×