Skip to main content

Using Microsoft Azure Database Services

Course

Intro Video

Photo of Landon Fowler

Landon Fowler

Database Training Architect II

Landon currently resides in Forest, VA but is originally from Alabama (Roll Tide!). Outside of work he enjoys spending time with his family and volunteering at church. Landon is passionate about sharing his love for technology with others. He enjoys sharing his knowledge through blogging, volunteering locally, and hopes to one day retire and teach free tech skills classes for children.

Length

07:00:00

Difficulty

Intermediate

Videos

37

Hands-on Labs

9

Course Details

The cloud has revolutionized every area of IT, including databases. Microsoft is at the forefront of this field, creating a range of services in Azure to address every data need. In this course we cover what these services are, how to use them, and how to select the right solution for your business needs.

Syllabus

Getting Started

Course Introduction

00:04:36

Lesson Description:

Welcome to the Using Microsoft Azure Database Services course! I'm excited to go on this learning journey with you. In this video, we discuss which topics will be covered, the resources and tools available to you, and prerequisites.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Class GitHub Repo: https://github.com/linuxacademy/content-azure-database-services

About the Training Architect

00:00:36

Lesson Description:

Hi! I'd like to introduce myself. In this video, I give a very quick synopsis of who I am and what my background is. It's nice to meet you!Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!

Overview

RDBMS Introduction and History

00:09:25

Lesson Description:

Before jumping into the details of Azure relational database services, let's take a moment to lay the foundation. In this lesson, we cover at a high level what a relational database is, what an RDBMS is, and how Azure seeks to address relational needs through their services.

Azure Relational Database Services Overview

00:06:42

Lesson Description:

In this lesson, we cover what is offered as part of Azure's relational database services. This will help us distinguish between IaaS and PaaS, as well as set the frame of reference before going over each service in detail.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!

SQL Server on Virtual Machines

Windows Virtual Machines: Part 1

00:08:42

Lesson Description:

This lesson is part one of two where we discuss SQL Server virtual machines running on Windows and what their advantages are. We also demonstrate deploying them.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationOverview of SQL Server on Azure Virtual Machines (Windows)

Windows Virtual Machines: Part 2

00:08:11

Lesson Description:

This lesson is part two of two where we discuss SQL Server virtual machines running on Windows and what their advantages are. We also demonstrate deploying them.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationOverview of SQL Server on Azure Virtual Machines (Windows)

Linux Virtual Machines: Part 1

00:07:16

Lesson Description:

This lesson is part one of two where we discuss SQL Server virtual machines running on Linux and what their advantages are. We also demonstrate deploying them.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationOverview of SQL Server on Azure Virtual Machines (Linux)

Linux Virtual Machines: Part 2

00:08:02

Lesson Description:

This lesson is part two of two where we discuss SQL Server virtual machines running on Linux and what their advantages are. We also demonstrate deploying them.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationOverview of SQL Server on Azure Virtual Machines (Linux)

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

00:30:00

Azure SQL Database

Deploying Azure SQL Database: Part 1

00:05:44

Lesson Description:

In this first lesson of two, we introduce Azure SQL Database and discuss its deployment options.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure SQL Database Documentation

Deploying Azure SQL Database: Part 2

00:07:26

Lesson Description:

In this second lesson of two, we demonstrate deploying Azure SQL Database.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure SQL Database Documentation

Working with Azure SQL Database

00:10:59

Lesson Description:

Now that we have discussed the options and process for deploying Azure SQL Database, in this lesson we get hands-on with how to configure and interact with it.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure SQL Database Documentation

Azure Database for MySQL

Deploying Azure Database for MySQL

00:09:23

Lesson Description:

In this lesson, we discuss the options for deploying Azure Database for MySQL and provide a demonstration of deployment.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Database for MySQL Documentation

Working with Azure Database for MySQL

00:08:16

Lesson Description:

Now that our deployment of Azure Database for MySQL is complete, in this lesson we take a hands-on look at interacting with the service and connecting to the instance.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Database for MySQL Documentation

Azure Database for MariaDB

Deploying Azure Database for MariaDB

00:05:14

Lesson Description:

In this lesson, we discuss the options for deploying Azure Database for MariaDB and give a demonstration of deployment.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Database for MariaDB Documentation

Working with Azure Database for MariaDB

00:05:36

Lesson Description:

Now that our deployment of Azure Database for MariaDB is complete, in this lesson we take a hands-on look at interacting with the service and connecting to the instance.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Database for MariaDB Documentation

Azure Database for PostgreSQL

Deploying Azure Database for PostgreSQL

00:07:08

Lesson Description:

In this lesson, we discuss the options for deploying Azure Database for PostgreSQL and give a demonstration of deployment.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Database for PostgreSQL Documentation

Working with Azure Database for PostgreSQL

00:07:43

Lesson Description:

Now that our deployment of Azure Database for PostgreSQL is complete, in this lesson we take a hands-on look at interacting with the service and connecting to the instance.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Database for PostgreSQL Documentation

Overview

Relational vs. NoSQL Databases

00:10:25

Lesson Description:

In this video we describe the differences between Relational and NoSQL databases and discuss their relative advantages and disadvantages.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!

Azure NoSQL Database Services Overview

00:04:16

Lesson Description:

In this video we discuss the NoSQL offerings available within Azure.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!

Table Storage

Deploying Table Storage

00:05:32

Lesson Description:

Our first stop on the Azure NoSQL services menu is Azure Table storage. In this lesson, we take a look at what it is, how it's structured, and how to deploy it.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Table Storage Overview

Working with Table Storage

00:09:20

Lesson Description:

In this lesson, we demonstrate how to interact with the table we created in the previous lesson.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Table Storage Overview Lesson LinksCourse GitHub Repo

Azure Cosmos DB

Azure Cosmos DB vs. Table Storage

00:05:57

Lesson Description:

In this lesson, we compare Azure Table storage to Azure Cosmos DB Table API, comparing their strengths and weaknesses with the goal of knowing when it's best to use each solution. Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Feature DifferencesTable API in Azure Cosmos DB vs. Azure Table storage

Deploying Azure Cosmos DB

00:07:23

Lesson Description:

In this lesson, we discuss what Azure Cosmos DB is, as well as its key benefits and how to deploy it. Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Cosmos DB documentation

Working with Azure Cosmos DB

00:08:50

Lesson Description:

In this lesson, we interact with the Cosmos DB account we created in the previous lesson, including creating databases, containers, and items as well as exploring how to configure replication and consistency. Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Cosmos DB documentation

Azure Cache for Redis

What Is Azure Cache for Redis?

00:04:43

Lesson Description:

In this lesson, we discuss what Azure Cache for Redis is and how it can augment your Azure NoSQL data solution for greater performance and scalability. Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Cache for Redis Documentation

Working with Azure Cache for Redis

00:04:49

Lesson Description:

In this lesson, we interact with the instance of Azure Cache for Redis we deployed in the previous lesson, including scaling our cache, replicating it, and more. Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Cache for Redis Documentation

Azure Synapse Analytics

Data Warehousing vs. OLTP

00:03:08

Lesson Description:

OLTP and OLAP systems serve distinct purposes and are therefore used in different ways. In this lesson, we briefly point out what these differences are and how they are used to complement one another. Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!

Deploying Azure Synapse Analytics

00:05:25

Lesson Description:

In this lesson, we take a look at Azure Synapse Analytics, Microsoft's unified suite for data warehousing and big data analytics. Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Synapse Analytics

Working with Azure Synapse Analytics

00:05:09

Lesson Description:

In this lesson, we interact with the Azure Synapse Analytics SQL Pool that was created in the previous lesson, discussing how to approach its management as well as the options for working with your analytics data.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)! Microsoft DocumentationAzure Synapse Analytics

Data Utilities

Azure Data Studio

00:05:20

Lesson Description:

In this lesson, we discuss Azure Data Studio, one of the tools available to you when working with Azure database services. We highlight its key features and how it might be a useful addition to your toolkit.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Data Studio

SQL Notebooks

00:03:26

Lesson Description:

In this lesson, we look at a tool that could improve your workflow for interacting with data as well as how you collaborate on it with others.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!

Data Services

Azure Database Migration Service

00:02:10

Lesson Description:

In this lesson, we provide a brief introduction to the Azure Database Migration Service.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Database Migration Service documentation Status of migration scenarios supported by Azure Database Migration Service

Azure Data Factory

00:02:11

Lesson Description:

In this lesson, we go over a brief introduction to Azure Data Factory.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Data Factory

Azure Data Explorer

00:01:15

Lesson Description:

In this lesson, we give a brief introduction to Azure Data Explorer.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!Microsoft DocumentationAzure Data Explorer documentation

Bringing It All Together

Which Service Is Right for Me?

00:09:43

Lesson Description:

In this lesson, we step back to take a look at the overall picture of Microsoft Azure database services. This helps us bring together all the information we've learned and make intelligent decisions going forward about which services to use in individual cases.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!

Hybrid Cloud: The Best of Both Worlds

00:04:04

Lesson Description:

In this lesson, we discuss how local data solutions fit into the modern cloud-dominated world, with an aim toward choosing the right solution for each problem.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!

Final Steps

What's Next

00:01:59

Lesson Description:

Congratulations on finishing the course! In this lesson, we quickly discuss some options for which path you might take from here on your data learning journey.Feel free to reach out with any questions on the Linux Academy forums (@lfowler), community Slack (@Landon Fowler), or Twitter (lfowler_LA)!

Take this course and learn a new skill today.

Transform your learning with our all access plan.

Start 7-Day Free Trial