Microsoft Azure Database Administrator Associate

This course provides learners with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

Course Intended Learning Outcomes:

Learners will be able to Plan and implement data platform resources
Learners will be able to Implement a secure environment
Learners will be able to Monitor and optimize operational resources
Learners will be able to Optimize query performance
Learners will be able to Perform automation of tasks
Learners will be able to Plan and implement a High Availability and Disaster Recovery (HADR) environment
Learners will be able to Perform administration by using T-SQL

Who should attend:

Data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure.
Learner holding a B.Sc. Qualification in (Computer Engineering, Network Engineering, Information System)

Personal Impact:

Professional skill development in Azure Database
Able to apply professional skills in to job
Certified professional certificate
Enhancing career development.

Organizational Benefits

Increase productivity
Works will be professional
Moves to cloud from on premises
Implementing new technology
Time saving.
Increasing reputation.

Certificate and Professional Qualification

Duration of the course: 32 Hours

Certification: Microsoft Certified: Azure Database Administrator Associate

Exam Code: DP-300

Daily Outline

Administering Relational Databases on Microsoft Azure

The Role of the Azure Database Administrator

Azure Data Platform Roles
Azure Database Platforms and Options
SQL Server Compatibility Levels
Azure Preview Features

Plan and Implement Data Platform Resources

Deploying SQL Server using IaaS
Deploying SQL Server using PaaS
Deploying Open Source Database Solutions on Azure

Implement a Secure Environment

Configure Database Authentication
Configure Database Authorization
Implement Security for Data at Rest
Implement Security for Data in Transit
Implement Compliance Controls for Sensitive Data

Monitor and Optimize Operational Resources

Baselines and Performance Monitoring
Major Causes of Performance Issues
Configuring Resources for Optimal Performance
User Database Configuration
Performance-related Maintenance Tasks

Optimize Query Performance

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

Automation of Tasks

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

Plan and Implement a High Availability and Disaster Recovery Environment

High Availability and Disaster Recovery Strategies
IaaS Platform and Database Tools for HADR
PaaS Platform and Database Tools for HADR
Database Backup and Recovery

Assessment Method

Exams require candidates to engage in on-the-job types of problem-solving. Question types include multiple-choice single answer, multiple-choice multiple answer, drag-and-drop, fill-in-the-blank, simulations, and lab Exercises which is mapping the objectives of the course which will analyses the learners Indented Learning Outcome (ILO)

Job Role

Database Administrator
Database Developer
DB Associate

Linked Programs

Azure Data Fundamentals
Azure Administrating Relational Database on MS Azure

Course Prerequisites

Azure Data Fundamentals.