Course Overview

This Microsoft DP-300 certification training course from CloudThat is designed to help candidates pass the Microsoft DP-300 certification exam to become Microsoft certified Azure Database Administrator Associate. Candidates taking DP-300 certification must understand all the concepts taught in the DP-900: Microsoft Azure Data Fundamentals certification. Candidates for this Azure DP-300 exam are database administrators and data management specialists responsible for the management, security, availability, optimization, and performance monitoring of modern relational database solutions. They also learn how to implement and manage operational aspects of hybrid data platforms and cloud-native solutions on Azure Data Services and SQL servers. They also learn how to use various tools and methods for administrative management purposes using T-SQL.

After completing this course, students will be able to:

  • Plan, deploy and configure Azure SQL offerings
  • Monitor database performance and tune a database and queries for optimum performance
  • Plan and configure a High Availability Solution

Upcoming Batches

India Online Enroll
Start Date End Date

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

03-07-2023

06-07-2023

05-06-2023

08-06-2023

05-06-2023

08-06-2023

05-06-2023

08-06-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

10-07-2023

13-07-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

12-06-2023

15-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

19-06-2023

22-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

26-06-2023

29-06-2023

To be Decided

Key Features

  • Our Azure DP-300 training modules have 50% -60% hands-on lab sessions to encourage Thinking-Based Learning (TBL).
  • Interactive-rich virtual and face-to-face classroom teaching to inculcate Problem-Based Learning (PBL).
  • Microsoft certified instructor-led training and mentoring sessions to develop Competency-Based Learning (CBL).
  • Well-structured use-cases to simulate challenges encountered in a Real-World environment.
  • Integrated teaching assistance and support through experts designed Learning Management System (LMS) and ExamReady platform.
  • Being a Microsoft Learning Partner provides us with the edge over competition.

Who Should Attend

  • Data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure
  • Data Architects
  • Application Developers

Prerequisites

Should have basic knowledge of:

  • Azure Fundamentals
  • Azure Data Fundamentals

Course Outline Download Course Outline

Lessons:

  • Azure Data Platform Roles
  • Azure Database Platforms and Options
  • SQL Server Compatibility Levels
  • Azure Preview Features

Hands-On:

  • Using the Azure Portal and SQL Server Management Studio
  • Provision a SQL Server on an Azure Virtual Machine
  • Connect to SQL Server and Restore a Backup

Lessons:

  • Deploying SQL Server using IaaS
  • Deploying SQL Server using PaaS
  • Deploying Open-Source Database Solutions on Azure

Hands-On:

  • Deploying Azure SQL Database
  • Deploy a VM using an ARM template
  • Configure resources needed prior to creating a database
  • Deploy an Azure SQL Database
  • Register the Azure SQL Database instance in Azure Data Studio and validate connectivity
  • Deploy PostgreSQL or MySQL using a client tool to validate connectivity

Lessons:

  • Configure Database Authentication
  • Configure Database Authorization
  • Implement Security for Data at Rest
  • Implement Security for Data in Transit
  • Implement Compliance Controls for Sensitive Data

Hands-On:

  • Implement a Secure Environment
  • Configure a server-based firewall rule using the Azure Portal
  • Authorize Access to Azure SQL Database with Azure Active Directory
  • Enable Advanced Data Security and Data Classification
  • Manage access to database objects

Lessons:

  • Baselines and Performance Monitoring
  • Major Causes of Performance Issues
  • Configuring Resources for Optimal Performance
  • User Database Configuration
  • Performance-related Maintenance Tasks

Hands-On:

  • Monitor and Optimize Resources
  • Isolate CPU Problems
  • Use Query Store observe blocking problems
  • Detect and correct fragmentation issues

Lessons:

  • Understanding SQL Server Query Plans
  • Explore Performance-based Database Design
  • Evaluate Performance Improvements

Hands-On:

  • Query Performance Troubleshooting
  • Identify issues with database design AdventureWorks2017
  • Isolate problem areas in poorly performing queries in AdventureWorks2017
  • Use Query Store to detect and handle regression in AdventureWorks2017
  • Use query hints to impact performance in AdventureWorks2017

Lessons:

  • Setting up Automatic Deployment
  • Defining Scheduled Tasks
  • Configuring Extended Events
  • Managing Azure PaaS resources Using Automated Methods

Hands-On:

  • Automating Tasks
  • Deploy an Azure template from a Quickstart template on GitHub
  • Configure notifications based on performance metrics
  • Deploy an Azure Automation Runbook (or elastic job) to rebuild indexes on an Azure SQL Database

Lessons:

  • High Availability and Disaster Recovery Strategies
  • IaaS Platform and Database Tools for HADR
  • PaaS Platform and Database Tools for HADR
  • Database Backup and Recovery

Hands-On:

  • Plan and Implement a High Availability and Disaster Recovery Environment
  • Create an Always On Availability Group
  • Enable Geo-Replication for Azure SQL Database
  • Backup to URL and Restore from URL

Certification

    • By earning DP-300 Azure certification, you will prove competency of Azure Database Administrator Associate.
    • Imbibe skills to Plan, deploy and configure Azure SQL offerings.
    • Demonstrate abilities to monitor database performance, plan and configure a high availability solution
    • On successful completion of Microsoft DP-300 training, aspirants receive a Course Completion Certificate from us.
    • By successfully clearing the exam DP-300: Administering Relational Databases on Microsoft Azure exam, aspirants earn Microsoft Certification.

Our Top Trainers

Course Fee

Select Course date

Add to Wishlist

Course ID: 13457

Course Price at

₹34900 + 18% GST

Enroll Now

Frequently Asked Questions

There are no mandatory prerequisite certifications to be completed before taking this exam. However, general IT knowledge will be beneficial. Candidates who develop applications that deliver content from SQL based relational databases are the appropriate target audience for the DP-300 Azure Database Administrator Associate Exam.

CloudThat’s Azure training course for the preparation of DP-300 certification exam can be taken up by: Data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure Data Architects Application Developers

Candidates appearing for the DP-300 exam will get 180 minutes (30 minutes reserved for feedback) to complete the Microsoft Azure Database Administrator Associate certification exam.

Candidates need to answer between 45-60 questions. However, the number of questions may change as and when changes in technology and job roles occur.

The cost of the DP-300 Microsoft Azure Database Administrator Associate certification exam is ₹4800 in Bangalore and other Indian cities. The exam cost is mostly priced according to the currency values in specific regions and countries. However, the exam prices are subject to change and may also vary depending on the additional taxes that may apply in some countries and regions.

Candidates need to score 700 (on a scale of 1-1000) on an approx. to pass the Microsoft DP-300 exam.

After completing CloudThat’s highly interactive DP-300 exam training in Bangalore or other cities, you will be able to: Plan and implement data platform resources Implement a secure environment Monitor and optimize operational resources Optimize query performance Perform automation of tasks Plan and implement a High Availability and Disaster Recovery (HADR) environment Perform administration by using T-SQL

Yes. Microsoft accredits our training courses. We are a Microsoft Gold Partner and the winner of the Microsoft Learning Partner 2020 of the Year Finalist award.

To prepare for the DP-300 certification and pass the exam successfully, candidates need to enroll in CloudThat’s Azure Database Administrator Associate certification training course in Bangalore. Our subject matter experts and certified Azure trainers offer training through online or instructor-led classes and provide relevant study material necessary to support your exam preparation. At CloudThat, you can strengthen your practical Azure skills through hands-on lab sessions and test your knowledge before the final exam through our test-prep platform. Besides our training and assistance, candidates can also: • Join online forum discussions and study groups to enrich your knowledge. • Have a detailed understanding of the exam structure. • Study Microsoft documentation along with relevant whitepapers and eBooks.

Once the candidate gets Azure certified, the certificate remains valid for two years.

CloudThat, a Microsoft Gold Partner and the winner of Microsoft Learning Partner 2020 of the Year Finalist award, is undoubtedly the best Azure training provider in Bangalore and other cities in India. CloudThat has trained over 350K+ IT professionals from fortune 500 companies in Cloud since 2012. From personalized mentoring to self-paced learning modules, we work towards providing a growth-oriented learning experience to nurture their future. • CloudThat’s training modules are equipped with 50%-60% hands-on lab sessions. • Highly interactive virtual and classroom teaching. • Qualified instructor-led training and mentoring sessions. • Practice lab and projects aligned to Azure learning modules. • Integrated teaching assistance and support.

Enquire Now