Certificates shipped for course completion till 25th of the last month.

Select Your Style

Choose your layout

Color scheme

Azure Data Lake

Azure Data Lake

Azure Data Lake

About the course

Azure Data Lake allows you to store & analyze petabyte-size files & trillions of objects. It helps you to develop massively parallel programs with ease. It also comes with Enterprise-grade security and you can start in seconds, scale instantly and you only pay for the jobs that you submit. Azure Data Lake is the new kid on the data lake block from Microsoft Azure which offers the ability to store and analyse data of any kind and size. It also offers multiple access methods including U-SQL, Spark, Hive, HBase, and Storm. In addition to this, Azure data lake offers dynamic scaling to match your business priorities, along with enterprise-grade security with Azure Active Directory. This course comprises of video lectures which can be viewed online and offline as per the convenience of the user. It also has questions for hands on practice. So, this makes it all together a complete package.

In this course on Azure Data Lake, you'll be introduced to Azure Data Lake and the U-SQL language, and learn how to abandon ETL. First, you'll delve into querying by using the powerful U-SQL language, built straight into the Azure Data Lake. Next, you'll discover how to throw your files into the Data Lake and query them directly without needing to load them into a database. Finally, you'll learn about how Azure Data Lakes offers the best of both worlds, with support for unstructured files and structured databases. By the end of this course, you’ll not only know what a Data Lake is, you’ll know how to populate it, query it, and develop for it using Visual Studio.


Advantages of learning this course
Target Audience
Why learn Azure Data Lake?
Course Features
Test & Evaluation
  • Timeline
  • Scholarship Details

Please Login or Register to fill the Scholarship form.

Scholarship Application

Under Graduate

Post Graduate



Other Information


*CGPA to percentage conversion formula:

Equivalent Percentage = CGPA obtained X 9.5 X (10/CGPA Scale)
Example: If CGPA obtained is 8.00 on the scale of 10, then Equivalent
percentage will be 8.00 X 9.5 X (10/10) = 76%,
or If CGPA is 3.7 out of 4, then Equivalent percentage will be 3.7 X 9.5 X (10/4) = 87.88%


We urge you to provide correct information to your best knowledge. Certificates will be withheld if found that you have misrepresented any data / information.


  1. Module 1 - Introduction to Azure Data Lake

    1. Introduction to Azure Data Lake

    2. Create Data Lake Analytics Account

    3. Explore Analytics & Store Account

    4. Connect to ADL using Visual Studio

    5. Introduction to U-SQL Language

    6. Schema on Read

    7. Upload Text File to Data Lake Store

    8. Run A Simple ADL Job

    9. Using C# Functions in U-SQL

    10. Applying Schema on Read

    11. Aggregating Data

    12. Importing Data from Multiple Files

    13. Combining Data from Multiple Files

  2. Module 2 - USQL Catalog

    1. Create Database

    2. Create Schema and Tables

    3. Architecture of USQL Job

    4. Index & Hashses explained

    5. Insert Data into the Database

    6. Query the Data

    7. Create View

    8. Query the View

    9. Case Sensitivity of USQL Language

    10. Table Valued Functions in USQL

    11. Store Procedure in USQL

    12. Store Procedure in USQL - Contd

  3. Module 3 - Custom Functions

    1. View Script file in USQL

    2. Using Inline C# Functions in USQL

    3. Implementing a Code Behind Class File

    4. Implementing a Code Behind Class File Continued...

    5. Create Custom Assembly

  4. Module 4 - Monitoring

    1. Job Comparison Tool

    2. Compare Two different Jobs

    3. Job Information Graph in Visual Studio

    4. Job Efficiency

    5. Viewing Job Efficiency in Visual Studio

    6. Vertex Execution View

  5. Module 5 - Different ways to access Azure Data Lake

    1. Introduction to PowerShell

    2. Creating a Data Lake Store account

    3. Data Lake Store

    4. Some more helpful commands for Azure Data Lake

    5. Some more helpful commands for Azure Data Lake - Contd..

    6. Submitting a Job

    7. Azure CLI 2.0

    8. Create Data Lake Store with Azure CLI

    9. Uploading & Listing Objects in CLI

    10. Deleting, Renaming

  6. Azure Data Lake Final Quiz