Introduction to Azure SQL Database (AZRSQL)

Microsoft, Databases

Location, current course term



VirtualPro (online)
1/8/2024 - 1/9/2024 CZECH
Order
4/15/2024 - 4/16/2024 CZECH
Order
Vlastní Školení na míru (termín, lokalita, obsah, délka)

The course:

Hide detail
  • Introduction to Azure
    1. Cloud environment introduction
    2. PaaS vs DBaaS
    3. Azure environment overview
  • Azure SQL Database
    1. DBaaS and PaaS model overview
    2. Compatibility with SQL Server
    3. Single Database, Elastic Pool vs Managed Instance
    4. DTU, vCore
  • Monitoring Azure SQL Database
    1. Resource monitoring
    2. Database bottlenecks
    3. Query Store
  • Azure SQL Database Administration
    1. Backup and backup strategies
    2. Retention
    3. Database restore
    4. Routine database maintenance - indexes, statistics etc.
    5. Azure Automation
  • High availability and disaster recovery capabilities
    1. Azure SQL Database
    2. Azure SQL Managed Instance
  • Securing database
    1. Firewall
    2. Virtual Network
    3. Authentication mechanisms - SQL, AAD
    4. Transparent Data Encryption, Azure Key Vault
    5. Always Encrypted overview
  • Azure SQL Managed Instance
    1. Specifics and differences from Single Database / Elastic Pool
    2. Storage
    3. General Purpose vs Business Critical Service Tiers
  • Migration to / from Azure SQL
    1. Overview
    2. Compatibility overview
    3. Tools overview
Schedule:
2 days (9:00 AM - 5:00 PM )
Course price:
596.00 € ( 721.16 € incl. 21% VAT)
Language: