DP-300: Administering Relational Databases

138

LESSONS

ALL

SKILL LEVEL

14:21 hr

DURATION

ENGLISH

AUDIO

ENG

SUBTITLES

.

OVERVIEW

This course teaches the requirements for the Microsoft Certificate DP-300 Administering Relational Databases on Microsoft Azure. It focuses on administering Azure SQL Databases, Azure SQL Managed Instances, and SQL Server on Azure Virtual Machines.

Some prior knowledge is required: you will need to know how to use the Select statement. Some background knowledge of Microsoft Azure is recommended. The knowledge of Azure contained within the DP-900 exam is desirable but not essential.

Once you have completed this course, you will know how to administer Azure SQL Databases, Azure SQL Managed Instances, and SQL Server on Azure Virtual Machines.

.

WHO IS THE COURSE FOR?

This course is for you if you want to implement or manage the operational aspects of cloud-native and hybrid data platform solutions built on Azure Data Services and SQL Server

You could be a database administrator or data management specialist that manage on-premises and cloud relational databases built with Microsoft SQL Server and Microsoft Azure Data Services.

..

LEARNING PATH

INTRODUCTION

  • Download free trial of Microsoft Azure.
  • Create Azure SQL Database with sample data.
  • Install SSMS, connecting to Azure SQL Database, and quick look around SSMS.
  • Review 6 principal clauses of the SELECT statement.
  • Review JOINs.

PERFORMANCE AND MIGRATNG TO AZURE

  • Optimise query performance.
  • Evaluate performance improvements.
  • Plan and implementation Data Platform resources.
  • Configure Azure SQL Database resources for scale and performance.
  • Evaluate a strategy for migrating to Azure.

SECURE ENVIRONMENT & OPERATIONAL RESOURCES

  • Configure database AuthN and AuthZ by using platform and database tools.
  • Implement security for data at rest and in transit.
  • Implement compliance controls for sensitive data.
  • Monitor activity and performance.

OTHER TOPICS IN HA/DR

  • Implement performance-related maintenance tasks.
  • Identify performance-related issues.
  • Automate tasks and perform backup and restore a database by using database tools.
  • Recommend an HADR strategy for a data platform solution.
  • Perform Administration by Using T-SQL.

VIRTUAL MACHINES & MANAGED INSTANCES

  • Introduction to Virtual Machines and Managed Instances (MI).
  • Upgrade strategy, configure database authentication, and filegroups.
  • Evaluate and implement an alert and notification strategy.
  • Identify performance-related issues.
  • Create scheduled tasks.
  • Perform backup and restore a database by using database tools – VMs.
  • Recommend and test HA/DR strategies, and configure HA/DR.

.

REVIEWS

“Explanations and detail is very good. The step by step progress is good… The instructor is great, learning more than I expected. Well worth it for a start into Azure.” Mohamed

“Gives proper hands on tutorial videos and also talks about supporting information, he’s not just reading from books online like a robot. His information is more ‘real world'” Luke

“Great course! Phillip Burton is a first-class instructor! So much light shed on so many dark corners in less than 20 hours. Highly recommended.” Eric

READY TO START?