End-to-End Real-World Data Engineering Project with Snowflake

Focused View

Deepak Goyal

1:36:19

0 View

01 - Introduction

01 - Project kickoff Data lake to Snowflake.mp4

00:45

02 - What you should know.mp4

00:56

02 - 1. Snowflake Real-World Project Details

01 - Snowflake real-world project case study Overview.mp4

05:28

02 - Data lake to Snowflake High-level solution.mp4

07:36

03 - Snowflake project architecture diagram.mp4

02:25

03 - 2. Snowflake Project Setup

01 - ADLS account creation.mp4

03:32

02 - Snowflake account creation.mp4

03:53

03 - Loading the sample data in ADLS.mp4

04:14

04 - Create external storage in Snowflake.mp4

07:25

04 - 3. Snowflake Bronze Layer Implementation

01 - Create the database in Snowflake and the Bronze layer schema.mp4

04:08

02 - Create the CSV file format in Snowflake to load CSV file data.mp4

03:06

03 - Create a Snowflake task to load customer data into the raw table.mp4

04:45

04 - Create the JSON file format in Snowflake to load JSON file data.mp4

02:39

05 - Create a Snowflake task to load product data into the raw table.mp4

04:45

06 - Create the Parquet file format in Snowflake to load Parquet file data.mp4

02:50

07 - Create a Snowflake task to load order data into the raw table.mp4

03:17

05 - 4. Snowflake Silver Layer Implementation

01 - Create the Silver layer schema in the database.mp4

04:15

02 - Create the stream in Snowflake to capture Customer table changes.mp4

01:38

03 - Create the stream in Snowflake to capture Product table changes.mp4

00:52

04 - Create the stream in Snowflake to capture Order table changes.mp4

01:44

05 - Create the task to merge customer changes in the Silver layer.mp4

07:02

06 - Create the task to merge product changes in the Silver layer.mp4

04:15

07 - Create the task to merge order changes in the Silver layer.mp4

02:32

06 - 5. Snowflake Gold Layer Implementation

01 - Create the Gold layer schema in the database.mp4

00:49

02 - Create the Gold layer demo table.mp4

06:14

03 - Create View 1 in the Gold layer.mp4

02:10

04 - Create View 2 in the Gold layer.mp4

02:10

07 - Conclusion

01 - Next steps.mp4

00:54

Description

This comprehensive course offers a hands-on deep dive into building a robust data pipeline using Snowflake, focusing on a real-world project case study. Join instructor Deepak Goyal as he shows you how to transform a data lake into a sophisticated Snowflake-based solution. Deepak covers the entire data lifecycle from ingestion to analytics-ready datasets. Learn how an end-to-end project works in Snowflake and how to implement the three-layer medallion architecture—bronze, silver, and gold. Ideal for professional data engineers as well as data analysts, this course can help you take your technical skills to the next level and put you in a more in-demand position to land the data role of your dreams.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Deepak Goyal

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.