DP-300 Administering Relational Databases on Microsoft Azure

DP-300 Administering Relational Databases on Microsoft Azure

Course Overview

DP-300 Administering Relational Databases on Microsoft Azure database administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions. The Azure database administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.

After completing this course, students will be able to:

  • Plan, deploy and configure Azure SQL offerings
  • Monitor database performance and tune a database and queries for optimum performance
  • Plan and configure a High Availability Solution

Key Features

  • Our training modules have 50% -60% hands-on lab sessions to encourage Thinking-Based Learning (TBL)
  • Interactive-rich virtual and face-to-face classroom teaching to inculcate Problem-Based Learning (PBL)
  • Microsoft certified instructor-led training and mentoring sessions to develop Competency-Based Learning (CBL)
  • Well-structured use-cases to simulate challenges encountered in a Real-World environment
  • Integrated teaching assistance and support through experts designed Learning Management System (LMS) and ExamReady platform
  • Being a Microsoft Learning Partner provides us with the edge over competition

Who this course is for:

  • Microsoft Certified: Azure Database Administrator Associate
  • DP-300 exam dumps
  • DP-300 with Latest and Updated Q&A
  • Administering Relational Databases on Microsoft Azure (beta) Exam

Prerequisites

Should have basic knowledge of:

  • Azure Fundamentals
  • Azure Data Fundamentals

Why Should I choose Lara Online Training?

  • Laraonlinetraining provide very in-depth course material with real time scenarios for each topic with its Solutions for DP-300 Administering Relational Databases on Microsoft Azure training.
  • We also provide production case studies during the training.
  • Schedule the sessions based upon your comfort by our Highly Qualified Trainers and Real-time Experts.
  • Get the Class recordings, immediately after the session for further Reference.
  • Avail flexibility with Normal Track, Fast Track, and Weekend Batches also for DP-300 Administering Relational Databases on Microsoft Azure Training.
  • Cost Effective and Flexible Payment Schemes.
  • 100% Placement assistance
  • We provide Assessment and Mock Interviews

Module 1 The Role of the Azure Database Administrator

1
Azure Data Platform Roles
2
Azure Database Platforms and Options
3
SQL Server Compatibility Levels
4
Azure Preview Features

Module 2 Plan and Implement Data Platform Resources

1
Deploying SQL Server using IaaS
2
Deploying SQL Server using PaaS
3
Deploying Open-Source Database Solutions on Azure

Module 3 Implement a Secure Environment

1
Configure Database Authentication
2
Configure Database Authorization
3
Implement Security for Data at Rest
4
Implement Security for Data in Transit
5
Implement Compliance Controls for Sensitive Data

Module 4 Monitor and Optimize Operational Resources

1
Baselines and Performance Monitoring
2
Major Causes of Performance Issues
3
Configuring Resources for Optimal Performance
4
User Database Configuration
5
Performance-related Maintenance Tasks

Module 5 Optimize Query Performance

1
Understanding SQL Server Query Plans
2
Explore Performance-based Database Design
3
Evaluate Performance Improvements

Module 6 Automation of Tasks

1
Setting up Automatic Deployment
2
Defining Scheduled Tasks
3
Configuring Extended Events
4
Managing Azure PaaS resources Using Automated Methods

Module 7 Plane and Implement a High Availability and Disaster Recovery Environment

1
High Availability and Disaster Recovery Strategies
2
IaaS Platform and Database Tools for HADR
3
PaaS Platform and Database Tools for HADR
4
Database Backup and Recovery

Be the first to add a review.

Please, login to leave a review
Add to Wishlist
Enrolled: 23234 students
Duration: 30hrs
Lectures: 28
Level: Beginner

Contact Us For Free Demo


    Quick Connect

    | |

     

    DP-300 Administering Relational Databases on Microsoft Azure
    Price:
    Free