Building Data Storage Solutions with Microsoft Azure Services

Paths

Building Data Storage Solutions with Microsoft Azure Services

Authors: Gary Grudzinskas, Reza Salehi, John Savill

Microsoft Azure includes a complete data storage offering suited to a variety of business needs. This skill teaches you how to translate common data storage business needs into... Read more

What you will learn:

  • Implement Azure SQL Databases and Data Warehouse
  • Build NoSQL Databases
  • Map your storage requirements to the appropriate Microsoft Azure service

Pre-requisites

Learners approaching this path should be familiar with types of storage solutions generally available and the problems they are meant to address, such as relational databases, graph databases, data lakes, and data warehouses. It is not expected that the learner is familiar with Microsoft Azure storage offerings.

Beginner

The courses in this section teach you how your storage requirements map into the Microsoft Azure service offering. You will learn how to select the appropriate service, as well as how that service needs to be provisioned and configured.

Selecting an Appropriate Data Storage Service in Microsoft Azure

by Gary Grudzinskas

Sep 23, 2019 / 1h 10m

1h 10m

Start Course
Description

The ability to use mange data is essential for a business to stay competitive. In this course, Selecting an Appropriate Data Storage Service in Microsoft Azure, you’ll be introduced to Azure solutions for storing big data. First, you will learn what types of data are out there. Next, you will explore what factors are involved in storing that data. Finally, you will discover what type of storage is appropriate for what you want to do with your data. When you are finished with this course, you will have a solid understanding of how data is used, and this will help you move forward to discover more about data engineering.

Table of contents
  1. Course Overview
  2. Getting to Know Data
  3. Knowing How Data Flows
  4. Examining Azure Data Storage

Intermediate

This portion of the skill teaches you to implement relational and NoSQL database solutions in Microsoft Azure.

Implementing NoSQL Databases in Microsoft Azure

by Reza Salehi

Jun 9, 2020 / 3h 55m

3h 55m

Start Course
Description

Discover the main Microsoft Azure managed NoSQL offerings. In this course, Implementing NoSQL Databases in Microsoft Azure, you will gain the ability to use Cosmos DB, Azure Table Storage and Azure Data Lake Gen2 for big data. First, you will learn about the cheap and fast Azure Table Storage NoSQL database. Next, you will discover the power of Azure Cosmos DB multi-model APIs for new and migrated NoSQL workloads. Finally, you will explore how to provision an Azure Data Lake Storage Gen2 instance and upload unstructured data to it. When you are finished with this course, you will have the skills and knowledge of managed NoSQL database offerings needed to start using NoSQL databases in Microsoft Azure.

Table of contents
  1. Course Overview
  2. An Introduction on NoSQL Databases
  3. Azure Storage Accounts - Table, Blob, Queue, and File
  4. Azure Cosmos DB Overview
  5. Working with Azure Cosmos DB - SQL (Core) API
  6. Working with Azure Cosmos DB - MongoDB API
  7. Working with Azure Cosmos DB - Table API
  8. Working with Azure Cosmos DB - Gremlin (Graph) API
  9. Working with Azure Cosmos DB - Cassandra API
  10. Working with Azure Data Lake Storage Gen2
  11. Azure Data Explorer Overview

Implementing a Relational Database in Microsoft Azure SQL Database

by Reza Salehi

May 29, 2020 / 2h 53m

2h 53m

Start Course
Description

Azure SQL Database is Microsoft's main relational database offering in the cloud. Getting the most out of this sophisticated service can be a challenge. In this course, Implementing a Relational Database in Microsoft Azure SQL Database, you will gain the ability to quickly provision and configure your relational database in the cloud. First, you will learn which deployment option best suites your project. Next, you will discover the automatic backup and data sync features. Finally, you will explore how to create database scheduled jobs to meet your data management and other needs. When you are finished with this course, you will have the skills and knowledge of Azure SQL Database needed to deploy and run your relational databases in the cloud.

Table of contents
  1. Course Overview
  2. Getting Started
  3. Provisioning Azure SQL Database Single Database & Elastic Pool
  4. Provisioning Azure SQL Database Managed Instance
  5. Configuring Data Backup
  6. Configuring Elastic Database Jobs
  7. Configuring SQL Agent Jobs
  8. Managing Data Synchronization between Azure and SQL Server On-premises

Advanced

This section of the skill addresses Cloud data warehousing and hybrid data solutions using Microsoft Azure.

Implementing Hybrid Data Solutions in Microsoft Azure

by John Savill

May 4, 2020 / 1h 37m

1h 37m

Start Course
Description

Understanding the capabilities related to hybrid use for Azure data services can be overwhelming. In this course, Implementing Hybrid Data Solutions in Microsoft Azure, you will learn foundational knowledge of Azure data services use in a hybrid solution. First, you will learn core hybrid data considerations. Next, you will discover how to utilize Azure data services in a hybrid solution. Finally, you will explore how to optimize your data solution. When you’re finished with this course, you will have the skills and knowledge of hybrid data solutions needed to include Azure data services as part of a complete solution.

Table of contents
  1. Course Overview
  2. Understanding Hybrid Data Systems
  3. Implementing Hybrid Data Systems
  4. Optimizing and Maintaining a Hybrid Data Solution

Implementing a Cloud Data Warehouse in Microsoft Azure Synapse Analytics

by Gary Grudzinskas

Dec 13, 2019 / 1h 18m

1h 18m

Start Course
Description

Microsoft Azure Synapse Analytics is a new environment that merges all the Azure data resources into one shared space. In this course, Implementing a Cloud Data Warehouse in Microsoft Azure Synapse Analytics, you'll focus on building an SQL data warehouse in Synapse. First, you'll learn what Azure Synapse Analytics does. Next, you'll discover how to deploy a data warehouse. Finally, you'll explore how to load data into your warehouse and work with it, saving money in the process. By the end of this course, you’ll have a working Synapse Analytics SQL data warehouse, loaded with data, that will let you work with all the new features.

Table of contents
  1. Course Overview
  2. Understanding Microsoft Azure Synapse Analytics
  3. Deploying a Data Warehouse in Microsoft Azure Synapse Analytics
  4. Tuning and Optimizing a Data Warehouse in Microsoft Azure Synapse Analytics