Microsoft Azure Database Administrator Associate

Home > Courses > Microsoft Azure Database Administrator Associate

Course Objectives

After completing this course, students will be able to:

Plan 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

Who Should Attend?

None

Pre-requisite

None

Module 01: Plan and Implement Data Platform Resources

Deploy resources by using manual methods

deploy database offerings on selected platforms
configure customized deployment templates
apply patches and updates for hybrid and IaaS deployment

Recommend an appropriate database offering based on specific requirements

evaluate requirements for the deployment
evaluate the functional benefits/impact of possible database offerings
evaluate the scalability of the possible database offering
evaluate the HA/DR of the possible database offering
evaluate the security aspects of the possible database offering

Configure resources for scale and performance

configure Azure SQL database/elastic pools for scale and performance
configure Azure SQL managed instances for scale and performance
configure SQL Server in Azure VMs for scale and performance
calculate resource requirements
evaluate database partitioning techniques, such as database sharding

Evaluate a strategy for moving to Azure

evaluate requirements for the migration
evaluate offline or online migration strategies
evaluate requirements for the upgrade
evaluate offline or online upgrade strategies

Implement a migration or upgrade strategy for moving to Azure

implement an online migration strategy
implement an offline migration strategy
implement an online upgrade strategy
implement an offline upgrade strategy

Module 02: Implement a Secure Environment

Module 03: Monitor and Optimize Operational Resources

Module 04: Optimize Query Performance

Module 05: Perform Automation of Tasks

Module 06: Plan and Implement a High Availability and Disaster Recovery (HADR) Environment

Perform Administration by Using T-SQL

HRDC Claimable

Claimable under HRDC

Yayasan Peneraju

Bumiputera talent

Individual Registration

No sponsorship

For Thailand branch, please click here to register

Course Detail

Calendar

TBC

Have Any Question?

If you need further information about this course, please contact: