Mastering Website and Database Migration to Azure

Course Introduction

This course offers a comprehensive guide to migrating websites and databases to Microsoft Azure, with practical insights into handling web applications, SQL databases, and .NET-based apps. Covering both fundamental concepts and advanced tools, it ensures you gain the skills needed for a successful transition to cloud-based solutions.

Through a combination of theory, live demonstrations, and practical exercises, you'll learn how to leverage Azure services such as the Azure App Migration Assistant, SQL Database configuration, and migration readiness tools to ensure a smooth migration process.

Section-Wise Curriculum Overview

Section 1: Introduction

Kickstart your learning journey by understanding the fundamentals of website and database migration to Azure.

• Lecture 1: Introduction to Migration of Websites and Databases to Azure (Preview enabled)
  Overview of the migration process, key challenges, and benefits of moving to Azure.

Section 2: Simple Web Application Migration to Azure

Learn how to migrate basic web applications from local environments to Azure with hands-on exercises.

• Lecture 2: Moving Local Web App
  Step-by-step guide on migrating a local web application to Azure.

• Lecture 3: Learning Website Migration Tool (Preview enabled)
  Introduction to Azure’s Website Migration Tool and how it simplifies the migration process.

• Lecture 4: Azure App Migration Assistant
  Learn about the Azure App Migration Assistant, a key tool for app migration.

Section 3: Migration of SQL Server Database to Azure SQL

Focus on moving SQL Server databases to Azure SQL, with performance tuning and connection setup.

• Lecture 5: MS SQL Database to Azure SQL Database
  A comprehensive guide on migrating MS SQL databases to Azure SQL.

• Lecture 6: Configuring Performance in Azure SQL
  Learn best practices for configuring performance in Azure SQL.

• Lecture 7: Connecting to Azure SQL Server
  Practical guide to establishing connections between your applications and Azure SQL Server.

Section 4: Net-Based Application Migration

Master the migration of .NET-based web applications and their connectivity to Azure databases.

• Lecture 8: Migrating Web Applications to Azure
  Learn the process of migrating web applications to the cloud.

• Lecture 9: Migrating .NET-Based Applications
  Dive into the steps for migrating .NET applications to Azure.

• Lecture 10: Connecting to Azure Database
  A guide to connecting your .NET applications to Azure SQL.

• Lecture 11: Migration Readiness Report
  Learn how to assess the readiness of your applications and databases for migration.

Section 5: SQL Script and MVC Application Migration

Understand how to use SQL scripts and migrate MVC applications, ensuring data integrity and smooth operation post-migration.

• Lecture 12: Adding Entry in Publish File
  How to configure and add entries in the publish file for successful migration.

• Lecture 13: MVC Application to Azure WebApp
  Migrate your MVC (Model-View-Controller) applications to Azure WebApp.

• Lecture 14: Assessment of Database
  Assess your database before migration to ensure smooth transition.

• Lecture 15: Generating SQL Script
  Learn how to generate SQL scripts for data migration.

• Lecture 16: Migration of Local MVC Application
  Migrate a local MVC application to Azure, ensuring compatibility and functionality.

• Lecture 17: Content and Database Migration
  Strategies for migrating both content and database to Azure.

• Lecture 18: Testing the Configuration
  Perform testing to ensure the migrated application and database function correctly.

Conclusion

By the end of this course, you'll have mastered the entire process of migrating web applications and databases to Azure, equipped with the knowledge to handle a variety of migration scenarios, optimize performance, and ensure system compatibility post-migration.