Building Your First Data Lakehouse Using Azure Synapse Analytics

Focused View

Mohit Batra

2:58:07

37 View

01. Course Overview

01. Course Overview.mp4

01:46

02. Getting Started with Data Lakehouse and Azure Synapse Analytics

02. Introduction and Course Outline.mp4

02:16

03. What Is Data Lakehouse .mp4

06:33

04. Azure Synapse Analytics-The Bigger Picture.mp4

09:58

05. Setting up Synapse Workspace.mp4

05:39

06. Scenario Walkthrough.mp4

02:35

07. Summary.mp4

01:16

03. Working with Dedicated SQL Pool

08. Module Overview.mp4

00:49

09. Understanding Architecture and Components of Dedicated SQL Pool.mp4

09:13

10. Provisioning Dedicated SQL Pool.mp4

03:00

11. Working with Polybase.mp4

03:32

12. Polybase Demo.mp4

08:25

13. Loading Data Using COPY Statement.mp4

03:43

14. Implementing Table Distributions.mp4

05:46

15. Table Distributions and Data Shuffling.mp4

07:05

16. Summary and Further Study.mp4

02:34

04. Transforming Data with Synapse Spark Pool

17. Module Overview.mp4

00:56

18. Understanding Managed Spark Environment.mp4

06:55

19. Configuring Spark Pool.mp4

02:57

20. Working with Notebook.mp4

05:27

21. Extracting Transforming Data in Data Lake.mp4

09:44

22. Loading Data in Spark Tables.mp4

04:24

23. Querying Dedicated SQL Pool from Spark Pool.mp4

04:00

24. Summary and Further Study.mp4

02:30

05. Ingesting Transforming and Orchestrating with Synapse Pipelines

25. Module Overview.mp4

00:52

26. Understanding Components of Synapse Pipelines.mp4

04:32

27. Ingesting Data Using COPY Activity.mp4

05:45

28. Transforming Data Using Mapping Data Flows.mp4

08:17

29. Orchestrating and Running Pipelines.mp4

07:07

30. Summary and Further Study.mp4

01:43

06. Querying Data Using Serverless SQL Pool

31. Module Overview.mp4

00:39

32. Understanding Serverless SQL Pool.mp4

04:20

33. Working with Data Lake Using SQL Queries.mp4

08:30

34. Querying Spark Tables Using SQL Queries.mp4

03:51

35. Controlling Serverless SQL Pool Cost.mp4

00:53

36. Summary.mp4

01:17

07. Connecting Services with Azure Synapse Analytics

37. Module Overview.mp4

00:49

38. Understanding Synapse Link for Azure Cosmos DB.mp4

04:15

39. Configuring Querying Synapse Link for Azure Cosmos DB.mp4

06:23

40. Building Power BI Report in Synapse Workspace.mp4

05:02

41. Course Summary.mp4

02:49

Description

In this course, you will learn about Azure Synapse Analytics & its integrated services - Workspace, Dedicated SQL, Apache Spark, Serverless SQL, Pipelines, Synapse Link to Cosmos DB, Power BI - and how it can be used to build a Data Lakehouse.

What You'll Learn?

Data Lakehouse is an architecture that intends to bring the best of Data Warehouses and Data Lakes together. It helps to put together a common platform to handle huge volumes of data, process data faster, and serve multiple use cases. In this course, Building Your First Data Lakehouse Using Azure Synapse Analytics, you'll learn to use Azure Synapse Analytics. It is a totally new product that brings together data integration, enterprise data warehousing, and big data analytics together. It is a set of multiple, well-integrated, Azure Data Services - Workspace, Dedicated SQL Pool, Apache Spark Pool, Serverless SQL, Synapse Pipelines, Synapse Link to Cosmos DB, integrated Power BI workspace, and much more. First, you'll learn how to set up the Synapse workspace by bringing in multiple data sources. Next, you'll discover how to explore the data and how to work with Dedicated SQL Pool, and Apache Spark Pool to extract and transform the data. Finally, you'll explore how to ingest, transform, and orchestrate data using Synapse Pipelines, use a Serverless SQL Pool to build a logical data model, and use connected services to Synapse. By the end of this course, you'll have knowledge and skills to use Synapse Link for Cosmos DB, and the integrated Power BI experience to help to build an end-to-end Data Lakehouse.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Artificial Intelligence

Microsoft Azure

Mohit Batra

Instructor's Courses

Mohit is a Data Engineer, a Microsoft Certified Trainer (MCT) and a consultant. Mohit has 15+ years of extensive experience in architecting large scale Business Intelligence, Data Warehousing and Big Data solutions with companies like Microsoft and some leading investment banks. As an expert in his field, Mohit has often shared his knowledge in Azure, Spark, SQL Server and Power BI at various public forums and as a corporate trainer. Mohit truly loves to teach and enjoys producing high-quality, engaging learning materials for his sessions. In his free time, Mohit loves to read, enjoys photography and music.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.