Loading...

Terminy kursów:

09.10.2023 - 12.10.2023
06.11.2023 - 09.11.2023
04.12.2023 - 07.12.2023

Oficjalny konspekt Microsoft Pozostałe szkolenia

DP-300 Administering Microsoft Azure SQL Solutions

Czas trwania kursu: 4 dni
Cena: 2999 zł netto

CERTYFIKACJE ZAWODOWE

Certyfikacja podstawowa CertyfIkacja specjalistyczna Certyfikacja ekspercka
FUNDAMENTALS ASSOCIATE EXPERT

 


POZIOM SZKOLENIA

podstawowy średniozaawansowany zaawansowany ekspercki
100 200 300 400

 

TEMATYKA ZAJĘĆ

  • Module 1: The Role of the Azure Database Administrator
    Azure Data Platform Roles
    Azure Database Platforms and Options
    SQL Server Compatibility Levels
    Azure Preview Features
    Lab: Using the Azure Portal and SQL Server Management Studio

 

  • Module 2: Plan and Implement Data Platform Resources
    Deploying SQL Server using IaaS
    Deploying SQL Server using PaaS
    Deploying Open Source Database Solutions on Azure
    Lab: Deploying Azure SQL Database

 

  • Module 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
    Lab: Implement a Secure Environment

 

  • Module 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
    Lab: Monitor and Optimize Resources

 

  • Module 5: Optimize Query Performance
    Understanding SQL Server Query Plans
    Explore Performance-based Database Design
    Evaluate Performance Improvements
    Lab: Query Performance Troubleshooting

 

  • Module 6: Automation of Tasks
    Setting up Automatic Deployment
    Defining Scheduled Tasks
    Managing Azure PaaS resources Using Automated Methods
    Lab: Automating Tasks

 

  • Module 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
    Lab: Plan and Implement a High Availability and Disaster Recovery Environment