Course HighlightsCOURSE
DP-300: Administering Relational Databases on Microsoft Azure

DP-300: Administering Relational Databases on Microsoft Azure

Build the knowledge and skills you need to administer SQL Server database infrastructure and 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.

DP-300: Administering Relational Databases on Microsoft Azure Highlights

Course Enrollment

Starts on

06 September 2022

Enrollment closes on
14 August 2022

  Course duration

Duration

  • 4 days, online
    8 hours/day
  Course Fee

Fee

US$ 2,220

Course Enrollment

Starts on

06 September 2022

Enrollment closes on
14 August 2022

Course duration

Duration

  • 4 days, online
    8 hours/day
Course Fee

Fee

US$ 2,220

DP-300 Administering Relational Databases on Microsoft Azure is a 4-day instructor-led intermediate course. This course helps learners gain knowledge and skills on how to administer SQL Server database infrastructure and work with the Microsoft PaaS relational database engine. This DP-300 course is of benefit to professionals who develop applications that deliver content from SQL-based relational databases.

The learners who wish to take this DP-300 Administering Relational Databases on Microsoft Azure course should have basic Azure SQL and Azure Fundamentals knowledge and 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 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 Relational Databases on Microsoft Azure certification exam, and it will give you the base you need to consider other role-based courses and certifications next. It does not include entry for the exam. 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 exams 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.

You will understand how to:

  • Plan and implement data platform resources.
  • Implement a secure environment.
  • Monitor and optimize operational resources.
  • Optimize query performance.
  • Perform automation of tasks.
  • Plan and implement a High Availability and Disaster Recovery (HADR) environment.
  • Perform administration by using T-SQL.
  • IT professionals seeking to build on their expertise in administering relational databases on Microsoft Azure.
  • Data architects
  • Application developers
  • Individuals looking to prepare for Microsoft’s DP-300 certification exam.
  • Specifically:
    • 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 Relational Databases on Microsoft Azure 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 solution.

    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

    Enrollment is Closed
    Introduction
    Grading Scheme
    Pre-Requisite
    Exam and Certification Details
    About this module
    Azure Data Platform Roles
    Azure Database Platforms and Options
    SQL Server Compatibility Levels
    Azure Preview Features
    Knowledge Check
    Deploying SQL Server using IaaS
    Deploying SQL Server using PaaS
    Deploying Open Source Database Solutions on Azure
    Knowledge Check
    Configure Database Authentication
    Configure Database Authorization
    Implement Security for Data at Rest
    Implement Security for Data in Transit
    Implement Compliance Controls for Sensitive Data
    Knowledge Check
    Baselines and Performance Monitoring
    Major Causes of Performance Issues
    Configuring Resources for Optimal Performance
    User Database Configuration
    Performance-related Maintenance Tasks
    Knowledge Check
    Understanding SQL Server Query Plans
    Explore Performance-based Database Design
    Evaluate Performance Improvements
    Knowledge Check
    About this module
    Setting up Automatic Deployment
    Defining Scheduled Tasks
    Configuring Extended Events
    Managing Azure PaaS resources Using Automated Methods
    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
    Download your certificate
    Course Certificate

    Earn your certificate

    Once you have completed this course, you will earn your certificate.

    Preview digital certificate
    DP-300: Administering Relational Databases on Microsoft Azure
    Enrollment is Closed

    FAQs

    Learners can get certification in DP-300: Administering Relational Databases on Microsoft Azure 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 fo2 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 ServerThis 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.