Working with Data in Azure

Event Type

Informational

Sponsor

The Department of Computer Science

Virtual

Date

Apr 7, 2021   9:30 am  

Views

25

Originating Calendar

Computer Science Department Events Calendar

Course Overview

This workshop is an introduction to working with data in the cloud on Azure. You
will walk through the different data structures and how they can be managed,
consumed, and accessed in Azure. This workshop also explores solutions and
integrations with common tools used for extract, transform, and load (ETL)
processes. You will leave with an improved understanding of Azure’s data
ecosystem and where your existing data fits within it.

In this course, we will cover the following topics:

• Benefits of working with data in the cloud and review of terminology
• Relational data with Azure SQL and Azure MySQL Database, and more
• Files and blobs with Azure Storage
• Additional tools and services and strategies for migrating data to Azure and options for computation.

And you will complete the following hands-on exercises:

• How to transform data to another type with Azure Data Factory
• Integration with Jupyter Notebooks in Azure Machine Learning Studio

Course Materials

• On-demand course videos: https://aka.ms/university-azure/DataOnAzure
• Scheduled Live Office Hours with Course Instructor: Click here to join the meeting

Instructor
Jasmine Greenaway

Questions?

Please submit them in advance of scheduled office hours at: https://aka.ms/university-azure/questions  

Prerequisites
This workshop uses Python, but knowledge of the language is not required.

• Complete the “Getting Started with Azure” course by Alex Vazquez. Video series is available here: https://aka.ms/university-azure/GettingStartedAzure 

Additional Resources

• Supplemental GitHub Repository: https://aka.ms/university-azure/DataIntro 

Databases

• Azure SQL documentation: https://docs.microsoft.com/azure/azure-sql/ 
• Azure DB for MySQL documentation: https://docs.microsoft.com/azure/mysql/ 
• Azure DB for Postgres documentation: https://docs.microsoft.com/azure/postgresql 

Non-Relational/Unstructured/Semi-Structured/NoSQL

• Storage Account documentation: https://docs.microsoft.com/enus/azure/storage/
• Cosmos DB documentation: https://docs.microsoft.com/enus/azure/cosmosdb/ 

Migration and ETL + Additional Services

• Azure Data Factory documentation: https://docs.microsoft.com/en-us/azure/data-factory/ 
• Azure Stream Analytics documentation: https://docs.microsoft.com/en-us/azure/stream-analytics/
• Azure Databricks documentation overview: https://docs.microsoft.com/en-us/azure/azure-databricks/