TOIT Training

DP-300: Administering Relational Databases on Microsoft Azure

DP-300: Administering Relational Databases on Microsoft Azure
  • Overview
  • Curriculum
  • Reviews

 

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.

  • 5 Sections
  • 17 Lessons
  • 0 Quizzes
  • 6h 10m Duration
Expand All

Plan and implement data platform resources

5 Lessons 0 Quizzes
  • Deploy IaaS solutions with Azure SQL 
  • Deploy PaaS Azure SQL 
  • Migrate to Azure SQL 
  • Migrate SQL Workloads to Azure SQL 
  • Migrate SQL Workloads to Azure Managed Instance 

Implement a secure environment

3 Lessons 0 Quizzes
  • Configure database authentication and authorization 
  • Data encryption – At rest vs in-flight 
  • Implement compliance controls for sensitive data 

Configure, monitor and optimize database resources in Azure

3 Lessons 0 Quizzes
  • Performance monitoring 
  • Configure SQL Server resources for optimal performance 
  • Configure databases for optimal performance 

 Configure and manage automation of tasks

3 Lessons 0 Quizzes
  • Automate deployment of database resources 
  • Create and manage SQL Agent jobs 
  • Manage Azure PaaS tasks using automation  

Plan and configure a high availability and disaster recovery (HA/DR) environment

3 Lessons 0 Quizzes
  • Describe high availability and disaster recovery strategies  
  • Explore IaaS and PaaS solutions for high availability and disaster recovery  
  • Backup and restore 

0

0 Ratings
5 Star 0%
4 Star 0%
3 Star 0%
2 Star 0%
1 Star 0%

Reviews

Free

Start Course

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.

Course Includes

  • 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

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

DP-300: Administering Relational Databases on Microsoft Azure
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)