Azure Data Lake Online Training

Simply Easy Learning

Created by Ravi Kiran, Last Updated 05-Sep-2019, Language:English

Description

Azure Data Lake training is for those who wants to expertise in Azure. In this tutorial we will learn more about Analytics service or Job as a service(Jaas).

Audience

This online training is designed for any student or professional with a need to understand the the cloud administrating and deployment in Microsoft Azure. Basic knowledge on server administration is the prerequisite for this course.

Course Content

Azure Data Lake Basic

9 Lectures 00:33:14
- What is Azure Data Lake?
  
  Preview
  
  00:02:10
- Azure Data Lake Architecture
  
  Preview
  
  00:02:57
- Why Azure Data Lake?
  
  Preview
  
  00:02:39
- Creating a Resource Group
  
  00:01:39
- Creating Azure Data Lake Account
  
  00:04:14
- Exploring Data Lake Analytics
  
  00:05:05
- Exploring Data Lake Store
  
  00:03:27
- Uploading Sample Data
  
  00:05:24
- Creating a Simple Job
  
  00:05:39
Understanding Concepts in Azure Data Lake

8 Lectures 00:16:09
- Introducing USQL Language
  
  00:02:11
- Extractors, Outputters
  
  00:01:31
- What is Analytic Unit?
  
  00:01:50
- Stages of Job
  
  00:01:55
- What Happens When you Submit a Job?
  
  00:02:29
- Azure Data Lake Job Graph
  
  00:02:19
- Job Heat Map
  
  00:01:54
- Schema on Read
  
  00:02:00
Simple Data Transformations

3 Lectures 00:07:54
- Aggregating Data
  
  00:02:56
- Filtering Data
  
  00:02:36
- Pulling Data From Multiple Files
  
  00:02:22
Working with USQL Catalog

12 Lectures 00:27:04
- USQL Catalog
  
  00:01:14
- Creating a Database
  
  00:01:19
- Creating Schema & Table
  
  00:03:14
- Inserting Data
  
  00:02:23
- Querying Data
  
  00:01:54
- Create a View
  
  00:02:17
- Query a View
  
  00:01:40
- Create Table Valued Function
  
  00:03:50
- Execute Table Valued Function
  
  00:02:02
- Creating Store Procedure
  
  00:02:45
- Running a Store Procedure
  
  00:02:15
- Using Inline C# Function
  
  00:02:11
Working with Visual Studio

3 Lectures 00:13:23
- Installing Tools for Visual Studio
  
  00:01:50
- Exploring Visual Studio
  
  00:07:16
- Create Custom Function in Visual Studio
  
  00:04:17
Job Monitoring

2 Lectures 00:06:07
- Job Comparison Tool
  
  00:03:12
- Vertex Execution View
  
  00:02:55
Working with Azure CLI 2.0

5 Lectures 00:11:08
- Introduction to Azure CLI 2.0
  
  00:00:59
- Install and Login to Azure CLI 2.0
  
  00:03:47
- Create Directory Structure using Azure CLI 2.0
  
  00:02:55
- Renaming Files and Download Data Using Azure CLI 2.0
  
  00:02:45
- Delete Data Lake Store Account Using Azure CLI 2.0
  
  00:00:42

Ravi Kiran

He is a learner & explorer. He is interested to know how stuff work & why it works. Currently working as a Project Manager, he is more close to technology than management. He holds a degree from BITS-Pilani & a Post Graduate Diploma in Management from MDI - Gurgaon. He has the ability to communicate seemingly complex topics in a visually pleasing & simple manner.