DP-300: Administering Relational Databases on Microsoft Azure Training

Name: DP-300: Administering Relational Databases on Microsoft Azure Training
Brand: Microtek Learning
Price: 2149 USD
Rating: 4.9 (1642 reviews)

4.9

(4.9)

Database management has turned out a significant requirement for companies around the globe. Hence, those aspiring for the position of database management specialist and database administrator go for authentic certifications.

Accredited By :
Category : Azure

Course Price : $2149 Per Participant

Enroll Now download

Course PDF

Check Schedule

Course Description

Among the various prominent cloud training courses and certifications for database administration management, the DP-300 certification exam is the better alternative. If you are seeking better guidance on opting for a career as a database administrator on Azure Cloud, then this certification is the right pick for you!

This allows candidates to improve their skills and understanding to administer a SQL Server database infrastructure for on-premises, cloud, and hybrid relational databases and typically who work with the MS Platform as a Service (PaaS) relational database offerings. Besides, it can be beneficial for those who develop apps that bring content from SQL-based relational databases.

Candidates for this exam are data management specialists and database administrators that manage cloud and on-premises relational databases built on top of MS Azure data services and MS SQL Server.

The Azure Database Administrator executes & manages the operational factors of hybrid data and cloud-native platform solutions built on SQL Server and Azure data services. This position is responsible for security, availability, management, and performance evaluation and optimization of updated date relational database solutions.

This training is designed based on the objectives of the course variant DP-300T00-A.

Training Exclusives

Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
Access to Microsoft Official Courseware (MOC).
Real-time Virtual Lab Environment.
Experience 24*7 Learner Support.
Self-paced learning and flexible schedules.

500+

Courses

20+

Years of Experience

95K+

Global Learners

What you will learn

Configuring, planning and deploying Azure SQL offerings.
Configuring and planning the higher availability solution.
Learn how to monitor database performance and tuning queries and database for enhance optimum performance.

Prerequisites

It is recommended to complete the following prerequisites before enrolling in this training:-

Azure Data Fundamentals.
Azure Fundamentals.

Who should attend this course?

This course is intended for the data professionals who know how to manage the databases and data about administer data platform technologies based upon the availability on Microsoft Azure.

This training is also recommended for application developers and data architects who knew how to understand about technologies availability for data platform.

Microsoft Learning Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

Dec 19, 2023
9:00 am - 5:00 pm EST
online

Enroll Now

Can’t Find The Batch You’re Looking For?

Request a Batch

Curriculum

Module 1: The Role of the Azure Database Administrator

Azure Data Platform Roles

Azure Database Platforms and Options

SQL Server Compatibility Levels

Azure Preview Features

Lab: 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

After completing this module, students will:

Understand the role of Azure Database Administrator as it fits in with other data platform roles

Be able to describe the key differences between the SQL Server-based database op

Be able to describe the difference between versions and compatibility levels

Know how to enable and disable preview features

Module 2: Plan and Implement Data Platform Resources

Deploying SQL Server using IaaS

Deploying SQL Server using PaaS

Deploying Open Source Database Solutions on Azure

Lab: Deploying Azure SQL Database

Deploy a VM using an ARM template

Configure resources needed prior to creating a database

Deploy an Azure SQL Database

Deploy PostgreSQL or MySQL using a client tool to validate connectivity

After completing this module, students will:

Deploy resources using manual methods

Recommend an appropriate database offering based on requirements

Configure database resources

Evaluate and implement a strategy for moving a database to Azure

Module 3: Implement a Secure Environment

Configure Database Authentication

Configure Database Authorization

Implement Security for Data at Rest

Implement Security for Data in Transit

Implement Compliance Controls for Sensitive Data

Lab: 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

After completing this module, students will:

Understand the differences between Windows, SQL Server and Azure Active Directory Authentication

Describe and configure both data-at-rest encryption solutions as well as data-in-transit encryption

Implement a data sensitivity solution

Module 4: Monitor and Optimize Operational Resources

Baselines and Performance Monitoring

Major Causes of Performance Issues

Configuring Resources for Optimal Performance

User Database Configuration

Performance-related Maintenance Tasks

Lab: Monitor and Optimize Resources

Isolate CPU Problems

Use Query Store observe blocking problems

Detect and correct fragmentation issues

After completing this module, students will:

Monitor activity and compare to a baseline

Define maintenance tasks related to performance

Identify major causes of performance problems

Configure resources for optimal performance

Configure a user database for optimal performance

Module 5: Optimize Query Performance

Understanding SQL Server Query Plans

Explore Performance-based Database Design

Evaluate Performance Improvements

Lab: 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

After completing this module, students will:

Analyze query plans and identify problem areas

Evaluate potential query improvements

Review table and index design

Determine whether query or design changes have had a positive effect

Module 6: Automation of Tasks

Setting up Automatic Deployment

Defining Scheduled Tasks

Configuring Extended Events

Managing Azure PaaS resources Using Automated Methods

Lab: 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

After completing this module, students will:

Deploy resources using automated deployment scripts

Create scheduled tasks

Create notifications and alerts

Configure automation for PaaS services

Module 7: Plan and Implement a High Availability and Disaster Recovery Environment

High Availability and Disaster Recovery Strategies

IaaS Platform and Database Tools for HADR

PaaS Platform and Database Tools for HADR

Database Backup and Recovery

Lab: 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

After completing this module, students will understand:

The difference between recovery time and recovery point objectives

The available HADR options for both IaaS and PaaS

The considerations for planning and configuring HADR solutions including how backup and restore fi

The factors that comprise a HADR strategy

How to configure a high availability solution via a hands-on lab

What Exam Do I Need To Get Certified?

Exam DP-300

About the Certifications

MS Certified: Azure Database Administrator Associate Certification course provides candidates with the knowledge and expertise to administer a SQL Server database infrastructure for hybrid relational, cloud, and on-premises databases and to those who work with the MS PaaS relational database offerings. The Microsoft Azure Database Administrator uses a range of tools and techniques to implement day-to-day operations, counting applying skills of using T-SQL for administrative management reasons.

Moreover, it will be of use to individuals who develop apps that deliver content from SQL-based relational databases. Candidates are majorly database administrators and data management specialists that manage cloud relational and on-premises databases built on top of MS Azure data services and MS SQL Server.

Certification Details

Azure Database Administrator

Step 1: Review the skills and knowledge required to certify.

Step 2: Recommended training for certification:

DP-300: Administering Relational Databases on Microsoft Azure

Step 3: Take this exam and get certified.

Exam DP-300

Who Should Attend?

Database Administrator

Skills Measured

Design 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

Certification Latest Updates

Microsoft Recertification Update:

Previously, Microsoft role-based certifications were valid for two years.
Starting June 2021, certifications are valid for one year, but they can be renewed online for free at Microsoft Learn.
The renewal window begins six months before the cert expires. During this window, before the cert expires, you can take a free online assessment and get the cert extended by one additional year from the current expiration date.
Want the best of both worlds, old and new? Certifications earned before June 2021 will be valid for two years and eligible for the new renewal process.