Engineering Data with Microsoft Cloud Services M20776

Duration: 
5 days
Codes: 
M20776

Overview

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.

Audience

Each participant will leave with a recognised certificate

Course Outline

Module 1: Architectures for Big Data Engineering with Azure

  • This module describes common architectures for processing big data using Azure tools and services.
  • Lessons
  • Understanding Big Data
  • Architectures for Processing Big Data
  • Considerations for designing Big Data solutions

Lab : Designing a Big Data Architecture

  • Design a big data architecture

Module 2: Processing Event Streams using Azure Stream Analytics

  • This module describes how to use Azure Stream Analytics to design and implement stream processing over large-scale data.
  • Introduction to Azure Stream Analytics
  • Configuring Azure Stream Analytics jobs

Lab : Processing Event Streams with Azure Stream Analytics

  • Create an Azure Stream Analytics job
  • Create another Azure Stream job
  • Add an Input
  • Edit the ASA job
  • Determine the nearest Patrol Car

Module 3: Performing custom processing in Azure Stream Analytics

  • This module describes how to include custom functions and incorporate machine learning activities into an Azure Stream Analytics job.
  • Implementing Custom Functions
  • Incorporating Machine Learning into an Azure Stream Analytics Job

Lab : Performing Custom Processing with Azure Stream Analytics

  • Add logic to the analytics
  • Detect consistent anomalies
  • Determine consistencies using machine learning and ASA

Module 4: Managing Big Data in Azure Data Lake Store

  • This module describes how to use Azure Data Lake Store as a large-scale repository of data files.
  • Using Azure Data Lake Store
  • Monitoring and protecting data in Azure Data Lake Store

Lab : Managing Big Data in Azure Data Lake Store

  • Update the ASA Job
  • Upload details to ADLS

Module 5: Processing Big Data using Azure Data Lake Analytics

  • This module describes how to use Azure Data Lake Analytics to examine and process data held 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

  • Add functionality
  • Query against Database
  • Calculate average speed

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

  • This module describes how to create and deploy custom functions and operations, integrate with Python and R, and protect and optimize jobs.
  • Incorporating custom functionality into Analytics jobs
  • Managing and Optimizing jobs

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

  • Custom extractor
  • Custom processor
  • Integration with R/Python
  • Monitor and optimize a job

Module 7: Implementing Azure SQL Data Warehouse

  • This module describes how to use Azure SQL Data Warehouse to create a repository that can support large-scale analytical processing over data at rest.
  • Introduction to Azure SQL Data Warehouse
  • Designing tables for efficient queries
  • Importing Data into Azure SQL Data Warehouse

Lab : Implementing Azure SQL Data Warehouse

  • Create a new data warehouse
  • Design a

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Midlands Birmingham5 2325 £2325 2019-10-07
Edinburgh Edinburgh5 2325 £2325 2019-10-07
Bristol Bristol5 2325 £2325 2019-10-07
Devon Exeter5 2325 £2325 2019-10-07
Bristol Bristol5 2325 £2325 2019-12-02
Devon Exeter5 2325 £2325 2019-12-02
Midlands Birmingham5 2325 £2325 2019-12-02
Edinburgh Edinburgh5 2325 £2325 2019-12-02