Administering Relational Databases on Microsoft Azure (DP-300T00)

Course Duration

4 Days

Audience

Employees of federal, state and local governments; and businesses working with the government.

Prerequisites

Experience administering SQL Server or Azure SQL databases. Familiarity with Azure services including compute, storage, and networking. Basic knowledge of T-SQL querying.

Course Description

This course provides students 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.

Learning Objectives

• The available HADR options for both IaaS and PaaS
• The considerations for planning and configuring HADR solutions including how backup and restore fit into an overall HADR strategy
• The factors that comprise a HADR strategy
• How to configure a high availability solution via a hands-on lab

Course Outline

Module 1: The Role of the Azure Database Administrator

Lessons

• Azure Data Platform Roles
• Azure Database Platforms and Options
• SQL Server Compatibility Levels
• Azure Preview Features
• Understand the role of Azure Database Administrator as it fits in with other data platform roles
• Be able to describe the key differences between the SQL Server-based database op
• Be able to describe the difference between versions and compatibility levels
• Know how to enable and disable preview features

Module 2: Plan and Implement Data Platform Resources

Lessons

• Deploying SQL Server using IaaS
• Deploying SQL Server using PaaS
• Deploying Open Source Database Solutions on Azure
• Deploy resources using manual methods
• Recommend an appropriate database offering based on requirements
• Configure database resources
• Evaluate and implement a strategy for moving a database to Azure

Module 3: Implement a Secure Environment

Lessons

• Configure Database Authentication
• Configure Database Authorization
• Implement Security for Data at Rest
• Implement Security for Data in Transit
• Implement Compliance Controls for Sensitive Data
• Understand the differences between Windows, SQL Server and Azure Active Directory Authentication
• Describe and configure both data-at-rest encryption solutions as well as data-in-transit encryption
• Implement a data sensitivity solution

Module 4: Monitor and Optimize Operational Resources

Lessons

• Baselines and Performance Monitoring
• Major Causes of Performance Issues
• Configuring Resources for Optimal Performance
• User Database Configuration
• Performance-related Maintenance Tasks
• Monitor activity and compare to a baseline
• Define maintenance tasks related to performance
• Identify major causes of performance problems
• Configure resources for optimal performance
• Configure a user database for optimal performance

Module 5: Optimize Query Performance

Lessons

• Understanding SQL Server Query Plans
• Explore Performance-based Database Design
• Evaluate Performance Improvements
• Analyze query plans and identify problem areas
• Evaluate potential query improvements
• Review table and index design
• Determine whether query or design changes have had a positive effect

Module 6: Automation of Tasks

Lessons

• Setting up Automatic Deployment
• Defining Scheduled Tasks
• Configuring Extended Events
• Managing Azure PaaS resources Using Automated Methods
• Deploy resources using automated deployment scripts
• Create scheduled tasks
• Create notifications and alerts
• Configure automation for PaaS services

Module 7: Plan and Implement a High Availability and Disaster Recovery Environment

Lessons

• High Availability and Disaster Recovery Strategies
• IaaS Platform and Database Tools for HADR
• PaaS Platform and Database Tools for HADR
• Database Backup and Recovery
• The difference between recovery time and recovery point objectives
• The available HADR options for both IaaS and PaaS
• The considerations for planning and configuring HADR solutions including how backup and restore fit into an overall HADR strategy
• The factors that comprise a HADR strategy
• How to configure a high availability solution via a hands-on lab