DP-300: Administering Relational Databases

138

Lessons

All

Skill Level

14:21h

course Duration

English

Audio

Eng

Subtitles

Share This Class:

Overview

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

We concentrate for most of the course on Azure SQL Databases, and then look at the additional functionality for Managed Instances and SQL Server on Azure Virtual Machines.

Some prior knowledge is required, but not much. You’ll need to know how to use the Select statement; and it would be helpful, but not essential, if you had a little background in Microsoft Azure.

Additionally, prior knowledge of Azure, such as that shown in Microsoft’s DP-900 exam is helpful, but is not required.

Once you have completed this course, you will have a good knowledge of how to administer Azure SQL Databases, Azure SQL Managed Instances, and SQL Server on Azure Virtual Machines. And with some practice, you could even go for the official Microsoft certification DP-300 – wouldn’t that look good on your CV or resume?

Completing this course will help you:

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

By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft’s official DP-300 exam.

Learning Path

  • Getting a free trial of Microsoft Azure
  • Creating Azure SQL Database with sample data
  • Installing SSMS, connecting to Azure SQL Database, and quick look around SSMS
  • Review 6 principal clauses of the SELECT statement
  • Review JOINs
  • Optimize 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
  • 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
  • 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
  • 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

What people are saying

Are You Ready To Start?

More Courses

You might also be interested in these courses

Database Fundamentals in 8 hours

Learning Database Fundamentals with Microsoft SQL Server

Database Fundamentals in 8 hours

View Course

Microsoft SQL Server Reporting Services

Learn to create reports in SSRS

SQL Server Reporting Services

Learn how to create reports in SSRS
View Course