×

MS-20776 - Engineering Data with Microsoft Cloud Services

This five-day instructor-led course describes how to process Big Data using Azure tools and services including Azure Stream Analytics, Azure Data Lake, Azure SQL Data Warehouse and Azure Data Factory. The course also explains how to include custom functions, and integrate Python and R.

Click here to print this page »

Prerequisites


In addition to their professional experience, students who attend this training should already have the following technical knowledge:
  • A good understanding of Azure data services.
  • A basic knowledge of the Microsoft Windows operating system and its core functionality.
  • A good knowledge of relational databases.

Detailed Class Syllabus


Module 1: Architectures for Big Data Engineering with Azure


Understanding Big Data
Architectures for Processing Big Data
Considerations for designing Big Data solutions

Module 2: Processing Event Streams using Azure Stream Analytics


Introduction to Azure Stream Analytics
Configuring Azure Stream Analytics jobs

Module 3: Performing custom processing in Azure Stream Analytics


Implementing Custom Functions
Incorporating Machine Learning into an Azure Stream Analytics Job

Module 4: Managing Big Data in Azure Data Lake Store


Using Azure Data Lake Store
Monitoring and protecting data in Azure Data Lake Store

Module 5: Processing Big Data using Azure Data Lake Analytics


Introduction to Azure Data Lake Analytics
Analyzing Data with U-SQL
Sorting, grouping, and joining data

Module 6: Implementing custom operations and monitoring performance in Azure Data Lake Analytics


Incorporating custom functionality into Analytics jobs
Managing and Optimizing jobs

Module 7: Implementing Azure SQL Data Warehouse


Introduction to Azure SQL Data Warehouse
Designing tables for efficient queries
Importing Data into Azure SQL Data Warehouse

Module 8: Performing Analytics with Azure SQL Data Warehouse


Querying Data in Azure SQL Data Warehouse
Maintaining Performance
Protecting Data in Azure SQL Data Warehouse

Module 9: Automating the Data Flow with Azure Data Factory


Introduction to Azure Data Factory
Transferring Data
Transforming Data
Monitoring Performance and Protecting Data