Administering Microsoft Azure SQL Solutions
Beskrivelse
Kurset henvender sig til databaseadministratorere og udviklere, som skal anvende de relationelle database-teknologier, som findes i Azure.
En Azure SQL database er oplagt til nye udviklingsprojekter, hvor man kan tænke standalone ind i arkitekturen. Eksisterende løsninger vil ofte kræve en Microsoft SQL Server på en VM, men på kurset ser vi også på, hvad den nye hybridløsning Managed Instance tilbyder.
Du får erfaring med sikkerhedsmodeller i Azure, managed backup og backup/restore proces, samt high availability og disaster recovery løsninger som bl.a. Always On availability groups og failover Clusters.
Du lærer også om automatisering via SQL Server Agent og Azure Automation Account samt performanceoptimering, her med fokus på Index Maintenance, Query Plans og Query Store.
En stot del features og teknologier, som gennemgås på kurset, er udviklet til Azure-databaser, men findes også i nyere SQL Server-versioner, hvorfor dette kursus også er til gavn for databaseadministratoren, der endnu ikke er migreret til Azure.
Certificeringspakker
Moduloversigt
- Modul 1Introduction to Azure database administration
Microsoft Azure provides a set of seamless capabilities for SQL databases. Explore the different database offerings, and services available to help you get started.
Lessons:
- Prepare to maintain SQL databases on Azure
- Modul 2Plan and implement data platform resources
Deploy data platform resources in Azure SQL. Explore options for deployment and migration. Calculate resource requirements and create templates.
Lessons:
- Deploy IaaS solutions with Azure SQL
- Deploy PaaS solutions with Azure SQL
- Evaluate strategies for migrating to Azure SQL
- Migrate SQL Server workloads to Azure SQL Database
- Migrate SQL Server workloads to Azure SQL Managed Instance
- Modul 3Implement a secure environment for a database service
Implement SQL Server-based options for authentication and authorization, as well as Azure options for securing Azure SQL databases. Explore encryption, firewalls and advanced threat protection.
Lessons:
- Configure database authentication and authorization
- Protect data in-transit and at rest
- Implement compliance controls for sensitive data
- Modul 4Monitor and optimize operational resources in Azure SQL
Configure hardware and server resources for optimum performance after establishing a baseline. Identify sources of performance problems. Troubleshoot using Azure SQL Intelligent Insights.
Lessons:
- Describe performance monitoring
- Configure SQL Server resources for optimal performance
- Configure databases for optimal performance
- Modul 5Optimize query performance in Azure SQL
Analyze individual query performance and determine where improvements can be made. Explore performance-related Dynamic Management Objects. Investigate how indexes and database design affect queries.
Lessons:
- Explore query performance optimization
- Explore performance-based design
- Evaluate performance improvements
- Modul 6Automate database tasks for Azure SQL
Scripting repetitive tasks in Azure SQL for regular maintenance jobs and multi-instance administration. Automation of error and resource alerts. Configuration of notifications for failures.
Lessons:
- Automate deployment of database resources
- Create and manage SQL Agent jobs
- Manage Azure PaaS tasks using automation
- Modul 7Plan and implement a high availability and disaster recovery environment
Data must be available when needed. Configure, test and manage a solution for high availability and disaster recovery using Azure tools and SQL Server tools.
Lessons:
- Describe high availability and disaster recovery strategies
- Explore IaaS and PaaS solutions for high availability and disaster recovery
- Back up and restore databases
Er du i tvivl?
Det ligger os meget på sinde, at du finder det kursusforløb, der skaber størst værdi for dig og din arbejdsplads. Tag fat i vores kursusrådgivere, de sidder klar til at hjælpe dig!