DP-300 : Administering Relational Database on Microsoft Azure


DP-300 : Administering Relational Database on Microsoft Azure Certification Training Course Overview

This course participants will be trained to implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on Microsoft Azure data services and Microsoft SQL Server. You will be learning the variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.

This role works with the Azure Data Engineer role to manage operational aspects of data platform solutions and optimization of modern relational data base solutions

Audience

  • Database Administrators
  • Data Management Specialist
  • Administrators working on cloud relational databases built on top of SQL Server and Azure Data Services.

 

This course prepares you for Exam DP-300.

DP-300 : Administering Relational Database on Microsoft Azure (32 Hours) Download Course Contents

Instructor - Led Online Training Fee For Both Group Training & 1-on-1 Training 1450
Group Training

26,27,28,29,30 Apr,03,04,05 May GTR
09:00 AM - 01:00 PM CST
(4 Hours/Day)

07,08,09,10 Jun
09:00 AM - 05:00 PM CST
(8 Hours/Day)

GTR=Guaranteed to Run
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End


Start Time : At any time

12 AM
12 PM


Classroom training is available in select Cities

Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Course Modules

  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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

Request More Information

Course Prerequisites

  • Initial experience in Azure
  • Upon completion of this course , you will be able to accomplish:
  • To plan, deploy and configure on Azure SQL offerings
  • Monitoring  performance on database
  • Tuning a database and queries for optimum performance
  • Planning and configuring a High Availability Solution

Upon completion of this course, you will be able to accomplish:

  • To plan, deploy and configure Azure SQL offerings
  • Monitoring a database performance and tune a database queries for optimum performance
  • Planning and configuring a High Availability Solution