Hi, 
DP-300: Administering Microsoft Azure SQL Solutions
Minimum cohort size: 10 learners
Book a free consultation to enroll & feel free to bring a friend along!
Course
DP-300: Administering Microsoft Azure SQL Solutions
Build the knowledge and skills you need to administer SQL Server database infrastructure for cloud, on-premises, and hybrid relational databases. Plus, work with the Microsoft PaaS relational database engine.
Benefit from instructor-led preparation for the DP-300 certification exam with tips, tricks, guidance, and mentored support.
Online Live Classes
Intermediate Level
Mentor Support
DP-300 Administering Microsoft Azure SQL Solutions is a 4-day instructor-led intermediate course. This course helps you to gain knowledge and skills on how to administer SQL Server database infrastructure and how to work with the Microsoft PaaS relational database engine. This DP-300 course is of particular benefit to professionals who develop applications that deliver content from SQL-based relational databases.
Learners who wish to take this DP-300 Administering Microsoft Azure SQL Solutions course should have basic Azure SQL and Azure Fundamentals (AZ-900) knowledge, plus two years experience in Azure data fundamentals.
During this course, you will gain insights into the role of the Azure database administrator. You will learn how to implement a secure environment, as well as how to monitor and optimize operational resources. You will discover how to optimize query performance and troubleshoot. Plus, you will learn how to automate tasks and plan and configure a high availability solution.
Overall, this online training course will prepare you for taking the DP-300 Administering Microsoft Azure SQL Solutions certification exam. It will also give you the base you need to consider other role-based courses and certifications next. Please note, it does not include entry for the exam. However, you will get a clear overview of the Microsoft certification process, plus you will get tips and tricks, testing strategies, practice questions, and valuable information to help you pass the exam successfully.
This course comprises seven purposely designed modules that take you on a carefully defined learning journey.
It is an instructor-led course which runs to a fixed schedule, with set start and finish dates. It is driven forward by your instructor and features live sessions that are aired at a set time. You will, however, have time to complete certain activities at your own pace outside of the live sessions.
The materials for each module are accessible from the start of the course and will remain available for the duration of your enrollment. Methods of learning and assessment will include reading material, hands-on labs and online practice exam questions.
As part of our mentoring service you will have access to valuable guidance and support throughout the course. We provide a dedicated discussion space where you can ask questions, chat with your peers, and resolve issues.
Once you have successfully completed the course, you will earn your Certificate of Completion.
After completing this course, you will be able to:
- Plan, deploy and configure Azure SQL.
- Monitor database performance and tune a database and queries for optimum performance.
- Plan and configure a high availability solution.
- IT professionals seeking to build on their expertise in administering relational databases on Microsoft Azure.
- Data architects.
- Application developers.
- Individuals looking to prepare for Microsofts DP-300 certification exam.
- Experience working with, maintaining, and developing with SQL Server.
- Experience with Azure, such as deploying and managing resources.
This course will help you to prepare for the DP-300: Administering Microsoft Azure SQL Solutions exam.
It is ideal for learners who want to work in SQL Server database infrastructure for cloud on-premises and hybrid relational databases, and who work with the Microsoft PaaS relational database offerings.
- You will become familiar with the aspects of cloud-native and hybrid data platform solutions built on Azure Data Services and SQL Server.
- You will build your knowledge of SQL Server database infrastructure for cloud.
- You will gain experience in Azure SQL offerings and high availability solutions.
When you take this course, you will also get information and guidance on the Microsoft certification process, knowledge checks and practice questions, and useful tips on how to pass the exam. This certification then lays the foundation for the following certifications: Microsoft Certified Azure Solutions Architect Expert, Microsoft Certified Azure DevOps Engineer Expert, Microsoft Certified Azure Security Engineer Associate and Microsoft Data Analyst Associate.
Course Outline
Introduction
Grading Scheme
Pre-Requisite
Exam and Certification Details
About this module
Prepare to maintain SQL databases on Azure
Knowledge Check
About this module
Deploy IaaS solutions with Azure SQL
Deploy PaaS solutions with Azure SQL
Evaluate strategies for migrating to Azure SQL
Migrate SQL workloads to Azure SQL Databases
Migrate SQL workloads to Azure Managed Instances
Knowledge Check
About this module
Configure database authentication and authorization
Protect data in-transit and at rest
Implement compliance controls for sensitive data
Knowledge Check
About this module
Describe performance monitoring
Configure SQL Server resources for optimal performance
Configure databases for optimal performance
Knowledge Check
About this module
Explore query performance optimization
Explore performance-based database design
Evaluate performance improvements
Knowledge Check
About this module
Automate deployment of database resources
Create and manage SQL Agent jobs
Manage Azure PaaS tasks using automation
Knowledge Check
About this module
High Availability and Disaster Recovery Strategies
IaaS Platform and Database Tools for HADR
PaaS Platform and Database Tools for HADR
Database Backup and Recovery
Knowledge Check
Instructions
Using the Azure Portal and SQL Server Management Studio
Deploying Azure SQL Database
Implement a Secure Environment
Monitor and Optimize Resources
Query Performance Troubleshooting
Automate Resources
Planning and Implementing a High Availability and Disaster Recovery Environment
Practice Set 1
Download your certificate
Related Courses
Why Learn with SkillUp Online?
We believe every learner is an individual and every course is an opportunity to build job-ready skills. Through our human-centered approach to learning, we will empower you to fulfil your professional and personal goals and enjoy career success.
Reskilling into tech? We’ll support you.
Upskilling for promotion? We’ll help you.
Cross-skilling for your career? We’ll guide you.
Personalized Mentoring & Support
1-on-1 mentoring, live classes, webinars, weekly feedback, peer discussion, and much more.
Practical Experience
Hands-on labs and projects tackling real-world challenges. Great for your resumé and LinkedIn profile.
Best-in-Class Course Content
Designed by the industry for the industry so you can build job-ready skills.
Job-Ready Skills Focus
Competency building and global certifications employers are actively looking for.
FAQs
Learners can get certification in DP-300: Administering Microsoft Azure SQL Solutions by following these steps:
Step 1: Complete the recommended training for DP-300 with a Microsoft authorized training partner. SKillUp Online is a Microsoft authorized training partner.
Step 2: After completing your training, visit Microsoft's official website. Register for the Microsoft Azure Fundamentals exam, and schedule it with Pearson VUE.
Step 3: Take the exam, pass it, and get certified!
It is recommended that learners have at least two years hands-on experience in database administration and management and basic hands-on experience working with Microsoft Azure.
DP-300 labs comprise theories from the course objectives. This will help you to deploy a virtual machine using an ARM template, Azure SQL database, Azure Automation Runbook, and much more.
The Azure DP-300 certification is valid for 2 years. Candidates must then recertify to keep their certification updated from the date they originally qualified for the exam.
DP-300 is an associate-level course for database administrators, which helps them administer data platform technologies available on Azure. Therefore, it is recommended that individuals get DP-300 certification by passing the DP-300 exam provide proof to employers that the have the competencies required for the role.
DP-300 certification is ideally suited to individuals who have technical knowledge that is equivalent to Azure and prior experience in SQL Server. This course will prepare you for the role of database administrator. Moreover, the DP-300 exam will also prepare you for taking Associate level courses in the future.
If you sign up with SkillUp Online, our Microsoft Certified Trainers (MCTs) will walk you through all the modules as per the Microsoft Official Curriculum (MOC). As long as you meet the prerequisites for the course, you do not need to prepare in advance.
Type of certificate
Certificate of completion
About this course
07 Modules
02 Skills
Includes
Discussion space
07 Labs
07 Knowledge checks
01 Practice exam
01 Project
Create
Azure SQL database
Storage
Virtual machine
Firewall
Create a CPU status alert for a SQL Server
Exercises to explore
Deploy Azure SQL database
Configure Azure SQL database
Load data into Azure SQL database
Configure auditing
Provision a SQL Server on an Azure virtual machine
Azure defender
Deploy a PostgreSQL database server
Deploy an automation runbook to automatically rebuild a databases indexes
You’ll learn with these experts
Microsoft
This course is led by experienced Microsoft Certified Trainers (MCTs).
Newsletters & Updates
Subscribe to get the latest tech career trends, guidance, and tips in your inbox.