Course run in conjunction with Nexus Human. Trading MicroWarehouse CSP partners enjoy further discounts on selected Nexus human courses.

This is an intensive 4 day course on February 23rd – 26th.  MicroWarehouse trading partners can avail of our heavily discounted rate of €500 per candidate.  Please ensure you have cleared your calendar before registering as no refunds will be offered for cancellations made within 7 days of course commencement and places are limited.

 

Description

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

Prerequisites

In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses:

• AZ-900T00 Microsoft Azure Fundamentals
• DP-900T00 Microsoft Azure Data Fundamentals

Course Contents

1. Prepare to maintain SQL databases on Azure
2. Deploy IaaS solutions with Azure SQL
3. Deploy PaaS solutions with Azure SQL
4. Evaluate strategies for migrating to Azure SQL
5. Migrate SQL workloads to Azure SQL databases
6. Migrate SQL workloads to Azure Managed Instances
7. Configure database authentication and authorization
8. Protect data in-transit and at rest
9. Implement compliance controls for sensitive data
10. Describe performance monitoring
11. Configure SQL Server resources for optimal performance
12. Configure databases for optimal performance
13. Explore query performance optimization
14. Evaluate performance improvements
15. Explore performance-based design
16. Automate deployment of database resources
17. Create and manage SQL Agent jobs
18. Manage Azure PaaS tasks using automation
19. Describe high availability and disaster recovery strategies
20. Explore IaaS and PaaS solutions for high availability and disaster recovery
21. Back up and restore databases