Online training for End to End Azure Data Warehouse Development

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.

Answer 1

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.

Answer 2

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.

Answer 3

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?

Thankyou

Answer 4

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.

Answer 5

hi, thankyou, all useful links to get me going:)

Answer 6

Hello,

Glad to know that it helped.