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