Introduction to Data Warehouses

Focused View

Deepak Goyal

46:57

131 View

01 - Introduction

01 - Introduction to data warehouses.mp4

00:45

02 - 1. Introduction to Data Warehouses

01 - Data warehouse key concepts.mp4

02:57

02 - Importance of data warehouses.mp4

02:10

03 - Data lake vs. data warehouse.mp4

02:18

04 - Data mart vs. data warehouse.mp4

02:09

05 - ETL process.mp4

02:14

06 - Traditional data warehouse options.mp4

02:19

03 - 2. Dimension Modeling

01 - Dimensional modeling.mp4

02:16

02 - Dimensional modeling vs. a traditional approach.mp4

01:54

03 - Facts.mp4

01:58

04 - Dimensions.mp4

01:51

05 - Star schema.mp4

02:53

06 - Snowflake schema.mp4

01:58

04 - 3. Create Your First Data Warehouse

01 - How to install SQL Server.mp4

04:23

02 - How to connect SSMS to SQL Server.mp4

01:58

03 - How to create a data warehouse using SQL Server.mp4

05:00

05 - 4. Modern Data Warehouses

01 - Cloud data warehouse.mp4

00:59

02 - Cloud vs. on-premises data warehouse.mp4

03:20

03 - Cloud data warehouse options.mp4

02:49

06 - Conclusion

01 - Next steps.mp4

00:46

Description

Data analytics skills are in high demand these days, and you can’t afford to fall too far behind. Regardless of your current level of experience or technical background, you need to be conversant with the latest tools in the field. Join instructor Deepak Goyal in this course, designed for aspiring IT professionals, to get an introduction to data warehouses, how they work and differ from other solutions, and how to implement them in your current or future role. Explore the foundational concepts of real-world problem-solving with traditional data warehousing options. Learn about when and when not to use dimensional modeling, and how to get started creating your first data warehouse using SQL Server and SSMS. Deepak covers the wide variety of data warehouses—from on-premises to cloud based—with tips on how to choose the option that works best for you.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Database Programming

Data Warehouse

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.