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.
