Compare with 1 courses

Designing Datawarehouse from Scratch - End to End Guide

Designing Datawarehouse from Scratch - End to End Guide

£24.99

£49.99

Dive into the world of data engineering and master the art of building a data warehouse from the ground up with our comprehensive course

Learn more
Has discount
Expiry period Lifetime
Made in English
Last updated at Fri Apr 2024
Level
Beginner
Total lectures 22
Total quizzes 0
Total duration 05:11:17 Hours
Total enrolment 21
Number of reviews 0
Avg rating
Short description Dive into the world of data engineering and master the art of building a data warehouse from the ground up with our comprehensive course
Outcomes
  • Foundational Concepts: Begin with the basics of data warehousing, understanding its significance, and exploring data modeling concepts to design the logical view of your data warehouse.
  • Amazon Redshift Deep Dive: Get hands-on with Amazon Redshift, learning how to set up, manage, and optimize your data warehouse cluster for performance and cost-efficiency.
  • Logical to Physical Model Transformation: Translate your logical model into a robust physical model in Redshift, mastering the art of schema design, table creation, and query optimization.
  • Data Ingestion and Transformation: Explore various data ingestion methods and learn how to transform raw data into insightful, analytical information using ETL and ELT processes.
  • Implementing Medallion Architecture: Implement the cutting-edge medallion architecture in your data warehouse to streamline data processing and enhance analytical capabilities.
Requirements
  • Basic Understanding of AWS Services
  • Basic SQL Technical Skills
  • Basic Understanding of Datawarehouse and Data Modelling