Introduction to Data Warehouses

Introduction to Data Warehouses

47mBeginner2024-12-11

Authors

Deepak Goyal

Deepak Goyal

Course details

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.

Skills covered

Introduction toData EngineeringData Science

Concepts

Introduction

  • Introduction to data warehouses

Introduction to Data Warehouses

  • Data warehouse key concepts
  • Importance of data warehouses
  • Data lake vs. data warehouse
  • Data mart vs. data warehouse
  • ETL process
  • Traditional data warehouse options

Dimension Modeling

  • Dimensional modeling
  • Dimensional modeling vs. a traditional approach
  • Facts
  • Dimensions
  • Star schema
  • Snowflake schema

Create Your First Data Warehouse

  • How to install SQL Server
  • How to connect SSMS to SQL Server
  • How to create a data warehouse using SQL Server

Modern Data Warehouses

  • Cloud data warehouse
  • Cloud vs. on-premises data warehouse
  • Cloud data warehouse options

Conclusion

  • Next steps
40,000 Toman