DP-300T00 - Administering Relational Databases on Microsoft Azure

DP-300T00 - Administering Relational Databases on Microsoft Azure

Actions and Detail Panel

On Sale Jun 9 at 12:00 AM

Date and time

Location

Online event

Refund policy

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises

About this event

1 - THE ROLE OF THE AZURE DATABASE ADMINISTRATOR

Azure Data Platform Roles

Azure Database Platforms and Options

SQL Server Compatibility Levels

Azure Preview Features

2 - PLAN AND IMPLEMENT DATA PLATFORM RESOURCES

Deploying SQL Server using IaaS

Deploying SQL Server using PaaS

Deploying Open Source Database Solutions on Azure

3 - 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

4 - 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

5 - OPTIMIZE QUERY PERFORMANCE

Understanding SQL Server Query Plans

Explore Performance-based Database Design

Evaluate Performance Improvements

6 - AUTOMATION OF TASKS

Setting up Automatic Deployment

Defining Scheduled Tasks

Configuring Extended Events

Managing Azure PaaS resources Using Automated Methods

7 - 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

Share with friends

Save This Event

Event Saved