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:
- Plan and implement data platform resources
- Monitor and optimize operational resources
- Perform automation of tasks
- Perform administration by using T-SQL
- Implement a secure environment
- Optimize query performance
- Plan and implement a High Availability and Disaster Recovery (HADR) environment
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
Azure SQL Database – Performance and Migrating to Azure
- 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
Azure SQL Database – Implement a secure environment and Monitor and optimize 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
Azure SQL Database – Other topics, including 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 and 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
What people are saying
“Great course at showing the content tested in the DP-300 course. … through taking this course (and applying the knowledge gained) I was able to get my certification on the first try.”
Steven
“Must say i didn’t expect to to provide such thorough Azure flavor from DBA standpoint….most of the courses on Udemy do have azure courses but they are from system admin standpoint(with dba portion added here n there)….this course is nicely crafted and most of nuances are explained clearly….also, there’s a pdf in resources which has the notes & its something to hold on to for quick reference for future…Thank you much for the course!!!”
Pardeep
“Explaination of basic concepts with examples is very interesting. This course is also putting more value for given subject like his other courses as well.”
Shahaji
Previous
Next
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
Microsoft SQL Server Reporting Services
Learn to create reports in SSRS
