Designing Data Warehouse from Scratch - End-to-End Data Engineering

Designing Data Warehouse from Scratch - End-to-End Data Engineering

CodeWithYu via YouTube Direct link

Introduction

1 of 22

1 of 22

Introduction

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Designing Data Warehouse from Scratch - End-to-End Data Engineering

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Introduction
  2. 2 System Prerequisites
  3. 3 Steps Involved in Designing a Data Warehouse
  4. 4 The Business Usecase
  5. 5 Designing the Logical Architecture
  6. 6 Creating a VPC on AWS
  7. 7 Creating Redshift Data Warehouse Cluster
  8. 8 Creating Subnet Group on AWS
  9. 9 Creating Security Group and allowing external connections on AWS
  10. 10 Connecting to Redshift Cluster with DBeaver
  11. 11 Connecting to Redshift Cluster with Redshift Query Editor
  12. 12 Creating Dimensions and Fact data
  13. 13 Loading data into Data Warehouse
  14. 14 Creating AWS Data Catalog DB and Tables
  15. 15 Connecting to Redshift to AWS Glue Data Catalog
  16. 16 Creating DBT project
  17. 17 Configuration connections to Redshift from DBT
  18. 18 DBT Project configuration with Variables and Schema
  19. 19 Creating Silver Dimension models
  20. 20 Creating Silver Fact models
  21. 21 Creating Gold Dimension and Fact Models
  22. 22 Other course information

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.