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

Course Description

Database management has turned out as significant requirements for companies around the globe. Hence, those aspiring for the position of database management specialists and database administrators go for authentic certifications. 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

Prerequisites for this training

It is recommended to complete following prerequisite 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.

Schedules

GTR

Jun 20, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

Jul 04, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

GTR

Jul 18, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

GTR

Aug 08, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

Aug 22, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

Sep 05, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

GTR

Sep 26, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

Oct 10, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

GTR

Oct 31, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

GTR

Dec 19, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

What you will learn

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

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

Register the Azure SQL Database instance in Azure Data Studio and validate connectivity

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

Recommended Certifications

With Microtek Learning, you’ll receive:

Certified Instructor-led training
Industry Best Trainers
Official Training Course Student Handbook
Pre and Post assessments/evaluations
Collaboration with classmates (not available for a self-paced course)
Real-world knowledge activities and scenarios
Exam scheduling support*
Learn and earn program*
Practice Tests
Knowledge acquisition and exam-oriented
Interactive online course.
Support from an approved expert
For Government and Private pricing*

* For more details call: +1-800-961-0337 or Email: info@microteklearning.com

Our Clients

For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.