Online training for End to End Azure Data Warehouse Development RRS feed

  • Question

  • Hi all,

    Does anyone know of a comprehensive online training course that takes you through the implementation of a modern datawarehouse in Azure.  I've seen alot of the MS docs but they always use a different dataset/use case for each bit so it's hard to end up with a single project end to end.

    I'd like to learn how to ingest data to Azure data lake store, databricks for ELT, delta lake in databricks, loading to DW/synapse and then ideally building a data model on top and power Bi but I can handle that bit myself once I load the data to a warehouse.  I'd just like to use a single raw dataset and build the above components to learn how it all pieces together and how I could apply to my own data use cases.

    many thanks.

    Tuesday, April 21, 2020 7:56 PM


All replies

  • Hello,

    Have you gone through the MS learn learning paths?

    MS learn helps you to learn new skills and discover the power of Microsoft products with step-by-step guidance. Start your journey today by exploring our learning paths and modules.

    Azure Synapse Analytics Learning Path

    Azure SQL Data Warehouse training is now available online via the edX training portal. In this computer science course, you will learn how to deploy, design, and load data using Microsoft's Azure SQL Data Warehouse, or SQL DW. You'll learn about data distribution, compressed in-memory indexes, PolyBase for Big Data, and elastic scale.

    For details, refer “Launching online training and certification for Azure SQL Data Warehouse”.

    Additional resources from Pluralsight:

    Azure SQL Data Warehouse: First Look

    Implementing a Cloud Data Warehouse in Microsoft Azure Synapse Analytics

    Hope this helps. Do let us know if you any further queries.


    Do click on "Mark as Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

    Wednesday, April 22, 2020 2:12 AM
  • Hello,

    Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same. And, if you have any further query do let us know.

    Thursday, April 23, 2020 10:39 AM
  • Hi, thanks for the links above.  The Synapse courses are definitely interesting.  I can't really find much in terms of ELT for data transformation, ideally with databricks within these courses though.  Is there anything that introduces databricks and delta lake before data is loaded into synapse?


    Thursday, April 23, 2020 10:06 PM
  • Hello,

    Currently, we are revamping the course on Azure Databricks on MS learn site.

    In this tutorial, you perform an ETL (extract, transform, and load data) operation by using Azure Databricks. You extract data from Azure Data Lake Storage Gen2 into Azure Databricks, run transformations on the data in Azure Databricks, and load the transformed data into Azure Synapse Analytics.

    Additional resources from Pluralsight:

    Building Your First ETL Pipeline Using Azure Databricks

    Delivering the MDW with Azure SQL Data Warehouse, Azure Databricks, Azure Data Factory and PBI

    Hope this helps. Do let us know if you any further queries.


    Do click on "Mark as Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

    Friday, April 24, 2020 6:15 AM
  • hi, thankyou, all useful links to get me going:)
    Saturday, April 25, 2020 11:00 PM
  • Hello,

    Glad to know that it helped.

    Monday, April 27, 2020 4:34 AM