Center for Advancement: Empowering Excellence, Inspiring Growth

Pay Now

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.

Course Inquiry