Microtek Learning Logo

DP-300: Administering Relational Databases on Microsoft Azure Training

4.9
(4.9)

Database management has turned out a significant requirement for companies around the globe. Hence, those aspiring for the position of database management specialist and database administrator go for authentic certifications.

  • Accredited By : Microsoft Partner Logo
  • Category : Azure

Course Price : $2149 Per Participant

Course Description

Database management has turned out a significant requirement for companies around the globe. Hence, those aspiring for the position of database management specialist and database administrator go for authentic certifications.

Among the various prominent cloud training courses and certifications for database administration management, the DP-300 certification exam is the better alternative. If you are seeking better guidance on opting for a career as a database administrator on Azure Cloud, then this certification is the right pick for you! 

This allows candidates to improve their skills and understanding to administer a SQL Server database infrastructure for on-premises, cloud, and hybrid relational databases and typically who work with the MS Platform as a Service (PaaS) relational database offerings. Besides, it can be beneficial for those who develop apps that bring content from SQL-based relational databases. 

Candidates for this exam are data management specialists and database administrators that manage cloud and on-premises relational databases built on top of MS Azure data services and MS SQL Server. 

The Azure Database Administrator executes & manages the operational factors of hybrid data and cloud-native platform solutions built on SQL Server and Azure data services. This position is responsible for security, availability, management, and performance evaluation and optimization of updated date relational database solutions. 

This training is designed based on the objectives of the course variant DP-300T00-A.

 

Training Exclusives

  • Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
  • Access to Microsoft Official Courseware (MOC).
  • Real-time Virtual Lab Environment.
  • Experience 24*7 Learner Support.
  • Self-paced learning and flexible schedules.
Microsoft Course Microsoft Course
500+

Courses

experience experience
20+

Years of Experience

learners learners
95K+

Global Learners

What you will learn

  • green-tick Configuring, planning and deploying Azure SQL offerings.
  • green-tick Configuring and planning the higher availability solution.
  • green-tick Learn how to monitor database performance and tuning queries and database for enhance optimum performance.

Prerequisites

It is recommended to complete the following prerequisites before enrolling in this training:-

  • Azure Data Fundamentals.
  • Azure Fundamentals.

Who should attend this course?

This course is intended for the data professionals who know how to manage the databases and data about administer data platform technologies based upon the availability on Microsoft Azure.

This training is also recommended for application developers and data architects who knew how to understand about technologies availability for data platform.

Microsoft Learning Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

  • Dec 19, 2023
  • 9:00 am - 5:00 pm EST
  • online

Can’t Find The Batch You’re Looking For?

Request a Batch

Curriculum

  • Azure Data Platform Roles
  • Azure Database Platforms and Options
  • SQL Server Compatibility Levels
  • Azure Preview Features
  • Lab: Using the Azure Portal and SQL Server Management Studio

  • Provision a SQL Server on an Azure Virtual Machine
  • Connect to SQL Server and Restore a Backup
  • After completing this module, students will:

  • Understand the role of Azure Database Administrator as it fits in with other data platform roles
  • Be able to describe the key differences between the SQL Server-based database op
  • Be able to describe the difference between versions and compatibility levels
  • Know how to enable and disable preview features
  • Deploying SQL Server using IaaS
  • Deploying SQL Server using PaaS
  • Deploying Open Source Database Solutions on Azure
  • Lab: Deploying Azure SQL Database

  • Deploy a VM using an ARM template
  • Configure resources needed prior to creating a database
  • Deploy an Azure SQL Database
  • Register the Azure SQL Database instance in Azure Data Studio and validate connectivity
  • Deploy PostgreSQL or MySQL using a client tool to validate connectivity
  • After completing this module, students will:

  • Deploy resources using manual methods
  • Recommend an appropriate database offering based on requirements
  • Configure database resources
  • Evaluate and implement a strategy for moving a database to Azure
  • Configure Database Authentication
  • Configure Database Authorization
  • Implement Security for Data at Rest
  • Implement Security for Data in Transit
  • Implement Compliance Controls for Sensitive Data
  • Lab: Implement a Secure Environment

  • Configure a server-based firewall rule using the Azure Portal
  • Authorize Access to Azure SQL Database with Azure Active Directory
  • Enable Advanced Data Security and Data Classification
  • Manage access to database objects
  • After completing this module, students will:

  • Understand the differences between Windows, SQL Server and Azure Active Directory Authentication
  • Describe and configure both data-at-rest encryption solutions as well as data-in-transit encryption
  • Implement a data sensitivity solution
  • Baselines and Performance Monitoring
  • Major Causes of Performance Issues
  • Configuring Resources for Optimal Performance
  • User Database Configuration
  • Performance-related Maintenance Tasks
  • Lab: Monitor and Optimize Resources

  • Isolate CPU Problems
  • Use Query Store observe blocking problems
  • Detect and correct fragmentation issues
  • After completing this module, students will:

  • Monitor activity and compare to a baseline
  • Define maintenance tasks related to performance
  • Identify major causes of performance problems
  • Configure resources for optimal performance
  • Configure a user database for optimal performance
  • Understanding SQL Server Query Plans
  • Explore Performance-based Database Design
  • Evaluate Performance Improvements
  • Lab: Query Performance Troubleshooting

  • Identify issues with database design AdventureWorks2017
  • Isolate problem areas in poorly performing queries in AdventureWorks2017
  • Use Query Store to detect and handle regression in AdventureWorks2017
  • Use query hints to impact performance in AdventureWorks2017
  • After completing this module, students will:

  • Analyze query plans and identify problem areas
  • Evaluate potential query improvements
  • Review table and index design
  • Determine whether query or design changes have had a positive effect
  • Setting up Automatic Deployment
  • Defining Scheduled Tasks
  • Configuring Extended Events
  • Managing Azure PaaS resources Using Automated Methods
  • Lab: Automating Tasks

  • Deploy an Azure template from a QuickStart template on GitHub
  • Configure notifications based on performance metrics
  • Deploy an Azure Automation Runbook (or elastic job) to rebuild indexes on an Azure SQL Database
  • After completing this module, students will:

  • Deploy resources using automated deployment scripts
  • Create scheduled tasks
  • Create notifications and alerts
  • Configure automation for PaaS services
  • High Availability and Disaster Recovery Strategies
  • IaaS Platform and Database Tools for HADR
  • PaaS Platform and Database Tools for HADR
  • Database Backup and Recovery
  • Lab: Plan and Implement a High Availability and Disaster Recovery Environment

  • Create an Always On Availability Group
  • Enable Geo-Replication for Azure SQL Database
  • Backup to URL and Restore from URL
  • After completing this module, students will understand:

  • The difference between recovery time and recovery point objectives
  • The available HADR options for both IaaS and PaaS
  • The considerations for planning and configuring HADR solutions including how backup and restore fi
  • The factors that comprise a HADR strategy
  • How to configure a high availability solution via a hands-on lab
  • What Exam Do I Need To Get Certified?

    • Exam DP-300

    About the Certifications

    MS Certified: Azure Database Administrator Associate Certification course provides candidates with the knowledge and expertise to administer a SQL Server database infrastructure for hybrid relational, cloud, and on-premises databases and to those who work with the MS PaaS relational database offerings. The Microsoft Azure Database Administrator uses a range of tools and techniques to implement day-to-day operations, counting applying skills of using T-SQL for administrative management reasons.

    Moreover, it will be of use to individuals who develop apps that deliver content from SQL-based relational databases. Candidates are majorly database administrators and data management specialists that manage cloud relational and on-premises databases built on top of MS Azure data services and MS SQL Server.

    Certification Details

    Azure Database Administrator

    Step 1: Review the skills and knowledge required to certify.

    Step 2: Recommended training for certification:

    DP-300: Administering Relational Databases on Microsoft Azure

    Step 3: Take this exam and get certified.

    • Exam DP-300

     

    Who Should Attend?

    • Database Administrator

     

    Skills Measured

    • Design 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

     

    Certification Latest Updates

    Microsoft Recertification Update:

    1. Previously, Microsoft role-based certifications were valid for two years.
    2. Starting June 2021, certifications are valid for one year, but they can be renewed online for free at Microsoft Learn.
    3. The renewal window begins six months before the cert expires. During this window, before the cert expires, you can take a free online assessment and get the cert extended by one additional year from the current expiration date.
    4. Want the best of both worlds, old and new? Certifications earned before June 2021 will be valid for two years and eligible for the new renewal process.

    Course Details

    • skill skill-green
      Skill Level: Intermediate
    • enroll enroll-green
      Enrolled: 1642
    • duration duration green
      Duration: 4 Days

    Talk to Learning Advisor