FULL END TO END COURSE AVAILABLE AT [ Ссылка ]
Accelerate your Data Mastery by signing up on datamasterylab.com.
This video is divided into 5 parts:
1. Designing the logical view of the DW
2. Creating a Redshift DW cluster
3. Converting the logical view to physical view
4. Loading the DW with Data
5. Implementing the medallion architecture on DW
Timestamps:
0:00 Introduction
2:00 System Prerequisites
9:22 Steps Involved in Designing a Data Warehouse
21:00 The Business Usecase
22:42 Designing the Logical Architecture
56:10 Creating a VPC on AWS
58:21 Creating Redshift Data Warehouse Cluster
1:00:00 Creating Subnet Group on AWS
1:03:11 Creating Security Group and allowing external connections on AWS
1:05:22 Connecting to Redshift Cluster with DBeaver
1:05:40 Connecting to Redshift Cluster with Redshift Query Editor
1:09:20 Creating Dimensions and Fact data
1:16:57 Loading data into Data Warehouse
1:25:44 Creating AWS Data Catalog DB and Tables
1:32:05 Connecting to Redshift to AWS Glue Data Catalog
1:36:30 Creating DBT project
1:41:30 Configuration connections to Redshift from DBT
1:47:12 DBT Project configuration with Variables and Schema
1:49:05 Creating Silver Dimension models
2:05:34 Creating Silver Fact models
2:20:12 Creating Gold Dimension and Fact Models
2:38:17 Other course information
Like this video? Support us: [ Ссылка ]
👦🏻 My Linkedin: [ Ссылка ]
🚀 X(Twitter): [ Ссылка ]
📝 Medium: [ Ссылка ]
🌟 Please LIKE ❤️ and SUBSCRIBE for more AMAZING content! 🌟
🔗 Useful Links and Resources:
✅ Video source code: [ Ссылка ]
✅ S3 Documentation: [ Ссылка ]
✅ AWS IAM Documentation: [ Ссылка ]
#DataEngineering #DataWarehousing #DataEngineer #TechTutorial #DataScience #BigData #CloudComputing #AWSRedshift #DatabaseDesign #DataArchitecture #MedallionArchitecture #LearnCoding #TechEducation #DataAnalytics #DWDesign #PhysicalDataModel #LogicalDataModel #DataLoading #DataWarehouseProject #CodeWithYu
Ещё видео!