MS/DP-300 : Administering Relational Databases on Microsoft Azure

4 gün (24 Saat) Orta Seviye Sınıf / Online Veritabanı Yönetimi

Microsoft Azure üzerinde bulut tabanlı SQL Server veritabanlarının yönetimi, güvenliği, iyileştirilmesi, sürdürülmesi, izlenmesi, altyapısının geliştirilmesi, yüksek erişilebilirliği hakkındadır. "Administering Relational Databases on Microsoft Azure" eğitimi ile Microsoft Azure bulut bilişim platformu üzerinde çalışacak olan bir veritabanı yöneticisinin yeteneklerinin geliştirilmesine odaklanılmaktadır. Dilerseniz bu eğitimden sonra Microsoft'un DP-300 sınavına giriş yapabilirsiniz.

Eğitim İçeriği

Module 1: The Role of the Azure Database Administrator

  • Lesson
    • Azure Data Platform Roles
    • Azure Database Platforms and Options
    • SQL Server Compatibility Levels
    • Azure Preview Features
  • Lab : Authenticating Users
    • Provision a SQL Server on an Azure Virtual Machine
    • Connect to SQL Server and Restore a Backup

Module 2: Plan and Implement Data Platform Resources

  • Lesson
    • Deploying SQL Server using IaaS
    • Deploying SQL Server using PaaS
    • Deploying Open Source Database Solutions on Azure
  • Lab : Authenticating Users
    • Deploy a VM using an ARM template
    • Configure resources needed prior to creating a database
    • Deploy an Azure SQL Database
    • Register the Azure SQL Database instance in Azure Data Studio and validate connectivity
    • Deploy PostgreSQL or MySQL using a client tool to validate connectivity

Module 3: Implement a Secure Environment

  • Lesson
    • Configure Database Authentication
    • Configure Database Authorization
    • Implement Security for Data at Rest
    • Implement Security for Data in Transit
    • Implement Compliance Controls for Sensitive Data
  • Lab : Authenticating Users
    • Configure a server-based firewall rule using the Azure Portal
    • Authorize Access to Azure SQL Database with Azure Active Directory
    • Enable Advanced Data Security and Data Classification
    • Manage access to database objects

Module 4: Monitor and Optimize Operational Resources

  • Lesson
    • Baselines and Performance Monitoring
    • Major Causes of Performance Issues
    • Configuring Resources for Optimal Performance
    • User Database Configuration
    • Performance-related Maintenance Tasks
  • Lab : Authenticating Users
    • Isolate CPU Problems
    • Use Query Store observe blocking problems
    • Detect and correct fragmentation issues

Module 5: Optimize Query Performance

  • Lesson
    • Understanding SQL Server Query Plans
    • Explore Performance-based Database Design
    • Evaluate Performance Improvements
  • Lab : Authenticating Users
    • Identify issues with database design AdventureWorks2017
    • Isolate problem areas in poorly performing queries in AdventureWorks2017
    • Use Query Store to detect and handle regression in AdventureWorks2017
    • Use query hints to impact performance in AdventureWorks2017

Öncesinde Önerilenler

Sonrasında Önerilenler