1. Home
  2. Training Library
  3. Microsoft Azure
  4. Courses
  5. Implementing Azure SQL Databases

Upgrade Scenarios

Contents

keyboard_tab
Introduction & Overview
1
Upgrade Scenarios
Course Summary
15

The course is part of these learning paths

DP-900 Exam Preparation: Microsoft Azure Data Fundamentals
course-steps
7
certification
2
lab-steps
2
description
1
Microsoft Azure for Solution Architects
course-steps
27
certification
10
lab-steps
14
AZ-303 Exam Preparation: Technologies for Microsoft Azure Architects
course-steps
28
certification
7
lab-steps
13
description
1
more_horizSee 2 more
play-arrow
Start course
Overview
Difficulty
Intermediate
Duration
1h 19m
Students
567
Ratings
4.8/5
starstarstarstarstar-half
Description

This course explores how to plan and implement data platform resources specifically with regards to Azure SQL offerings. In particular, we will explore the benefits and features of the SQL PaaS offerings along with billing models, service tiers, and high availability options. We'll also cover migration scenarios and provide a demo that migrates a sample database from an on-premise SQL Server to an Azure SQL managed instance using DMS.

If you have any feedback relating to this course, feel free to contact us at support@cloudacademy.com.

Learning Objectives

  • Get a general understanding of Azure SQL databases
  • Learn how to deploy Azure SQL databases
  • Understand business continuity and security tie in with SQL databases
  • Learn how to scale, upgrade, and partition your databases
  • Learn how to migrate a database from an on-premise SQL Server to an Azure SQL instance

Intended Audience

  • Anyone who wants to learn about Azure SQL Offerings 
  • Those preparing for Microsoft’s DP-300 exam

Prerequisites

To get the most out of this course, you have should a general understanding of the fundamentals of Microsoft Azure. Experience using databases — especially SQL Server — would also be beneficial.

Transcript

Depending on which version of SQL Server you are currently running, you may need to consider upgrading your server instance before migrating to Azure SQL. The latest version of SQL Server 2019 or version 15X supports a wide variety of upgrade paths and scenarios. You can refer to the Microsoft website for your specific version and addition to see what upgrade paths are supported, and what requirements or conditions apply.

It's generally an easy upgrade path to SQL Server 2019 or version 15X from SQL Server 2012 onwards. So 2012 with service pack four or later, 2014 service pack three or later, 2016 service pack two or later, and from 2017.

Once we have migrated our database engine to the cloud, we no longer have to worry about service pecs or patches. However, databases seldom work in isolation. So it's likely that applications using your database may need to be upgraded.

Within the Azure environment, there is a wide range of tools and technologies available that can help you upgrade and test your applications. The application upgrade and migration process will vary according to the amount of downtime your systems can tolerate, how your applications are designed, and of course your budget.

You can leverage standard backups and geo replication to move data around and make copies of the database. You can also use DNS name changes and Traffic Manager to control the flow of traffic during migration and rollback as needed.

Lectures

Course Introduction - Azure SQL Databases Overview - Deployment Options - ARM Templates Deployment - DEMO: Deploying Azure SQL Databases - Business Continuity - Security Database Services - Scale and Performance - DEMO: Scaling Azure SQL Databases - Partitioning Data - Migrating to Azure - Migration Scenarios - DEMO: DMS Azure SQL Database Migration Process - Summary

About the Author
Avatar
Hallam Webber
Software Architect
Students
10818
Courses
17
Learning Paths
1

Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a  Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.