Overview
This 5-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. This course also explains how to include custom functions, and integrate Python and R.
Prerequisites
In addition to their professional experience, students who already 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
Who Should Attend?
This course is recommended for data engineers (IT professionals, developers, and information workers) who plan to implement big data engineering workflows on Azure.
Course Outline
- Understanding Big Data
- Architectures for Processing Big Data
- Considerations for designing Big Data solutions
Lab: Designing a Big Data Architecture
- Introduction to Azure Stream Analytics
- Configuring Azure Stream Analytics jobs
Lab: Processing Event Streams with Azure Stream Analytics
- Implementing Custom Functions
- Incorporating Machine Learning into an Azure Stream Analytics Job
Lab: Performing Custom Processing with Azure Stream Analytics
- Using Azure Data Lake Store
- Monitoring and protecting data in Azure Data Lake Store
Lab: Managing Big Data in Azure Data Lake Store
- Introduction to Azure Data Lake Analytics
- Analyzing Data with U-SQL
- Sorting, grouping, and joining data
Lab: Processing Big Data using Azure Data Lake Analytics
- Incorporating custom functionality into Analytics jobs
- Managing and Optimizing jobs
Lab: Implementing custom operations and monitoring performance in Azure Data Lake Analytics
- Introduction to Azure SQL Data Warehouse
- Designing tables for efficient queries
- Importing Data into Azure SQL Data Warehouse
Lab: Implementing Azure SQL Data Warehouse
- Querying Data in Azure SQL Data Warehouse
- Maintaining Performance
- Protecting Data in Azure SQL Data Warehouse
Lab: Performing Analytics with Azure SQL Data Warehouse
- Introduction to Azure Data Factory
- Transferring Data
- Transforming Data
- Monitoring Performance and Protecting Data
Lab: Automating the Data Flow with Azure Data Factory