DifficultyIntermediate
AVG Duration7h
Students2218
Ratings
5/5
starstarstarstarstar
Content
715

Description

Learning Path Description

Microsoft Azure provides robust services for analyzing big data. One of the most effective ways is to store your data in Azure Data Lake Storage Gen2 and then process it using Spark on Azure Databricks.

Azure Stream Analytics (ASA) is Microsoft’s service for real-time data analytics. Some examples include stock trading analysis, fraud detection, embedded sensor analysis, and web clickstream analytics. ASA uses Stream Analytics Query Language, which is a variant of T-SQL. That means anyone who knows SQL will have a fairly easy time learning how to write jobs for Stream Analytics. 

In this learning path, you will follow hands-on examples to import data, run queries, and output the results using both analytics services. You will also learn how to troubleshoot Stream Analytics jobs. Then you will have the opportunity to run a Stream Analytics job yourself with our guided, hands-on lab. Finally, you can take our exam to test your understanding of what you learned.

Learning Objectives

  • Get data into Azure Data Lake Storage (ADLS)
  • Use six layers of security to protect data in ADLS
  • Use Azure Databricks to process data in ADLS
  • Monitor and optimize the performance of your data lakes
  • Create and run a Stream Analytics job
  • Use time windows to process streaming data
  • Scale a Stream Analytics job
  • Monitor and troubleshoot errors in Stream Analytics jobs

Prerequisites

  • Basic database knowledge
  • SQL experience (recommended)
  • Microsoft Azure account (recommended)

Intended Audience

  • Anyone interested in Azure’s big data analytics services

Feedback

If you have thoughts or suggestions for this learning path, please contact Cloud Academy at support@cloudacademy.com.

Certificate

Your certificate for this learning path

Training Content

1
Course - Intermediate - 28m
FREE
Introduction to Azure Synapse Analytics
This course introduces Microsoft’s Azure Synapse Analytics, covering serverless SQL pools, dedicated SQL pools, Spark pools, and Synapse Pipelines.
2
Hands-on Lab - Intermediate - 1h 45m
Using Azure Synapse Analytics to Query Data Lake
Learn how to deploy and use Azure Synapse Analytics to query data stored in a data lake through T-SQL statements using a serverless SQL pool in this hands-on lab.
3
Course - Intermediate - 42m
Running Spark on Azure Databricks
In this course, we will show you how to set up a Databricks cluster and run interactive queries and Spark jobs on it.
4
Course - Advanced - 39m
Using Azure Data Lake Storage Gen2
In this course, you will follow hands-on examples to import data into Azure Data Lake Storage Gen2 and then securely access it and analyze it using Azure Databricks. You will also learn how to monitor and optimize your Azure Data Lake Storage Gen2.
5
Hands-on Lab - Beginner - 1h
Using Azure Databricks to Import and Analyze Data
Learn to implement lightning-fast analytics by building an Azure Databricks workspace and cluster to interact with Azure Data Lake Store data.
6
Course - Intermediate - 13m
Introduction to Delta Lake on Azure Databricks
This course provides an introduction to Delta Lake in Azure Databricks and shows you how to use it.
7
Course - Beginner - 1h 5m
Designing Data Flows in Azure
In this Course, we're going to review the features, concepts, and requirements that are necessary for designing data flows and how to implement them in Microsoft Azure.
8
Hands-on Lab - Intermediate - 1h 15m
Using Azure Data Factory Pipelines to Copy Data
Learn how to build and trigger data pipelines in Azure Data Factory in this lab.
9
Hands-on Lab - Intermediate - 1h
Monitor Azure Data Factory using Azure Monitor
In this hands-on lab, you'll learn how to Monitor Azure Data Factory and set up alerts using Azure Monitor
10
Course - Advanced - 30m
Handling Slowly Changing Dimensions With Azure Synapse Analytics Pipelines
In this course, we’ll explain the concept of slowly changing dimensions and the different approaches to dealing with them.
11
Course - Intermediate - 50m
Introduction to Azure Stream Analytics
This course includes hands-on examples of how to configure inputs, outputs, and queries in ASA jobs, including ingesting data from Event Hubs and writing results to Data Lake Store.
12
Hands-on Lab - Beginner - 30m
Analyzing IoT Data Using Azure Stream Analytics
Analyze Internet of Things (IoT) sensor data using Azure Stream Analytics to identify if there have been any IoT device failures in this Lab.
13
Exam - 20m
Final Exam: Big Data Analytics on Azure
Final Exam: Big Data Analytics on Azure
About the Author
Students162150
Courses93
Learning paths147

Guy launched his first training website in 1995 and he's been helping people learn IT technologies ever since. He has been a sysadmin, instructor, sales engineer, IT manager, and entrepreneur. In his most recent venture, he founded and led a cloud-based training infrastructure company that provided virtual labs for some of the largest software vendors in the world. Guy’s passion is making complex technology easy to understand. His activities outside of work have included riding an elephant and skydiving (although not at the same time).