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