Training agenda

  1. The role of Azure database administrator

    • Roles as part of Azure data platform

    • Azure database options and mechanisms

    • SQL Server compatibility levels

    • Azure new functions

  2. Planning and implementing data platform’s resources

    • Implementing SQL Server using IaaS services

    • Implementing SQL Server using PaaS services

    • Implementing opensource database solutions in Azure

  3. Implementing safe environment

    • Configuring authentication to Databases

    • Configuring authorisation to Databases

    • Securing stored data

    • Securing data transfer

    • Implementing compatibility control for sensitive personal data

  4. Monitoring and optimising operational resources

    • Points of reference and monitoring performance

    • Main reasons for decrease in performance

    • Configuring resources for optimal performance

    • Configuring databases

    • Maintenance tasks related to performance

  5. Task performance optimisation

    • Understanding SQL Server query plans

    • Getting to know database development in terms of performance

    • Improvements in terms of performance based on evaluation

  6. Task automation

    • Setting automatic implementation

    • Defining task schedules

    • Configuring Extended Events

    • Azure PaaS resource management using automation methods

  7. Planning and implementing high availability and recovery environments

    • Strategies of High Availability and Recovery (HADR)

    • IaaS services and database tools for HADR

    • PaaS services and database tools for HADR

    • Database back-ups and recovery