Certification Based
Cloud

DP-300: Administering Relational Databases on Microsoft Azure

Intermediate
6h

By: David Winegar

Overview

In this instructor-led, online training course, students will learn the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

Skills Learned

  • After completing this online training course, students will be able to:
  • Understand the differences between Azure SQL offerings and how best to leverage their features
  • Implement a secure database environment
  • Monitor database and server performance
  • Optimize database and server performance
  • Automate database tasks
  • Implement high availability and disaster recovery
  • Use T-SQL to perform database administration tasks

Modules

1. Topic: Plan and Implement Data Platform Resources - Class Recordings

1.1 Deploy IaaS Solutions with Azure SQL41 min
1.2 Deploy PaaS Azure SQL47 min
1.3 Migrate to Azure SQL11 min
1.4 Migrate SQL Workloads to Azure SQL8 min
1.5 Migrate SQL Workloads to Azure Managed Instance15 min

2. Topic: Implement a Secure Environment - Class Recordings

2.1 Configure Database Authentication and Authorization23 min
2.2 Data Encryption At Rest vs In-Flight33 min
2.3 Implement Compliance Controls for Sensitive Data31 min

3. Topic: Configure, Monitor and Optimize Database Resources in Azure - Class Recordings

3.1 Performance Monitoring30 min
3.2 Configure SQL Server Resources for Optimal Performance16 min
3.3 Configure Databases for Optimal Performance15 min

4. Topic: Configure and Manage Automation of Tasks - Class Recordings

4.1 Automate Deployment of Database Resources9 min
4.2 Create and Manage SQL Agent Jobs22 min
4.3 Manage Azure PaaS Tasks Using Automation44 min

5. Topic: Plan and Configure a High Availability and Disaster Recovery (HA/DR) Environment - Class Recordings

5.1 Describe High Availability and Disaster Recovery Strategies13 min
5.2 Explore IaaS and PaaS Solutions for High Availability and Disaster Recovery10 min
5.3 Backup and Restore8 min

Ready to Elevate Your Team's Learning?

Talk with our sales team to see how StormWind can transform the way your organization trains and grows.

CONTACT SALES