Working with Data in Azure
- Event Type
- Informational
- Sponsor
- The Department of Computer Science
- Virtual
- Join online
- Date
- Apr 7, 2021 9:30 am
- Views
- 45
- Originating Calendar
- Siebel School 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 GreenawayQuestions?
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/