About This Course
In the Data modernization workshop, you will learn how to develop a plan for migrating on-premises VMs and SQL Server databases into a combination of IaaS and PaaS services in Azure. In this hands-on lab, you implement a proof-of-concept (PoC) for migrating an on-premises SQL Server 2008 R2 database into Azure SQL Managed Instance (SQL MI). You perform assessments to reveal any feature parity and compatibility issues between the on-premises SQL Server 2008 R2 database and Azure’s managed database offerings. Then you will migrate the customer’s on-premises gamer information web application and database into Azure, with minimal down-time. Finally, you enable some of the advanced SQL features in SQL MI to improve security and performance in the customer’s application.
Data modernization Hands-on Labs – [8 HRS]
- Exercise 1: Perform database assessments
- Exercise 2: Migrate the database to SQL MI
- Exercise 3: Update the web application to use the new SQL MI database
- Exercise 4: Integrate App Service with the virtual network
- Exercise 5: Improve database security posture with Data Discovery and Classification and Azure Defender for SQL
- Exercise 6: Enable Dynamic Data Masking
This course doesn’t have any technical pre-requisite. This course primarily uses the Azure portal to create services and does not require scripting skills.
Frequently Asked Questions
How can I purchase a course from Spektra Academy?
You need to click on your preferred course amongst all four courses mentioned on the right side of the course page, You will be headed to the purchase screen where you can purchase your course as per your requirement.
Can I get refund once I purchase a course?
Once you purchase a course, we will not be able to provide a refund for the course.
Can I purchase an exam voucher from Spektra Academy?
No, we do not provide the exam voucher. You have to directly purchase it from Microsoft.
What all resources I can create in a Spektra Academy provided cloud account for Hands-on lab?
Spektra Academy subscriptions are configured to allow you to deploy the required resources and SKUs as per the lab instructions. However, it does not allow you to create any additional resources beyond the scope of the lab.
Do I need to have my own Cloud account or signup for trial subscription in order to use Hands-on lab?
Spektra Academy will provide you a temporary cloud account for completing the Hands-on lab. You do not need to signup for any trial or bring your own subscription.
What is the validity of the labs?
Can I pause or resume the lab environment?
What if I have any queries?
If you have any queries, please feel free to contact us
A member of our support staff will respond to you as soon as possible.