Course Description
SQL Server has come a long way! From OLTP to OLAP, on-premises to cloud, big data clusters to hyperscale -- SQL Server has evolved in many ways. With that evolution comes complexity as organizations seek to take advantage of new features and cloud efficiency. This hack puts you (and your team) in the role of a SI (Systems Integrator), working with many clients to modernize their environments and applications.
Learning Objectives
In this hack, database administrators, developers who work extensively with SQL Server, and architects will migrate solutions to Azure. Several different scenarios are presented that are based on real-world scenarios, and in most cases, there are multiple ways to solve the problem given the requirements of each challenge. This hack also prepares participants for the DP-300 exam.
About this course
Duration
3 Days
Learning Objectives
In this hack, database administrators, developers who work extensively with SQL Server, and architects will migrate solutions to Azure. Several different scenarios are presented that are based on real-world scenarios, and in most cases, there are multiple ways to solve the problem given the requirements of each challenge. This hack also prepares participants for the DP-300 exam.
Challenges
- Challenge 0: Setup
- Challenge 1: Migration
- Challenge 2: Advanced Migration at Scale
- Challenge 3: Performance & Tuning
- Challenge 4: Security & Auditing
- Challenge 5: High Availability & Disaster Recovery
- Challenge 6: Data Governance
Technologies
- Azure SQL Database / Managed Instance
- Azure Database Migration service
- Azure Data Studio
- Azure Purview