Cookies en privacy

Administering Relational Databases on Microsoft Azure (DP-300)
Ontwikkel fundamentele kennis voor het werken met SQL-databases in Azure
Cursusvorm

Klassikaal

Duur

4 dagen

Studievormen

Dag

Vakgebieden Beheer
Last minute deal Last minute deal

Ervaren en gecertificeerde trainers

Startgarantie

Deskundig en persoonlijk trainingsadvies?
Algemeen
Programma
Programma

Inhoud

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

Afronding
Planning
Kosten
Administering Relational Databases on Microsoft Azure (DP-300)