CF

Schema Design Data Stores

2h 30m 25s
English
Paid
Updated September 2026

Schema Design Data Stores is a 10-lesson 2 hours 30 minutes self-paced course by Andreas Kretz. Schema design keeps coming up in Andreas Kretz's coaching sessions, which is what prompted this dedicated course — built around the same e-commerce dataset used elsewhere in his academy, plus real schemas pulled from actual coaching…

Course facts

Lessons
10
Duration
2 hours 30 minutes
Level
All levels
Language
English
Updated
2026-09-11
Instructor
Andreas Kretz
Price
Premium

Schema design keeps coming up in Andreas Kretz's coaching sessions, which is what prompted this dedicated course — built around the same e-commerce dataset used elsewhere in his academy, plus real schemas pulled from actual coaching work.

Why schema design matters

Even NoSQL storage, often pitched as "schema-less," needs a deliberate structure behind it — skip that step and data has a way of turning into an unmanageable swamp rather than a usable asset.

Designing for different storage types

  • Relational databases
  • NoSQL storage
  • Columnar storage
  • Document databases
  • Key-value storage
  • Data warehouses

Across 10 lessons, paired with the companion course "Choosing Data Stores," you come away able to both pick the right storage for a task and design a schema for it that's efficient and easy to reason about.

Who teaches Schema Design Data Stores? Andreas Kretz

Andreas Kretz thumbnail

Andreas Kretz is a German data engineer and one of the most widely followed independent voices on data engineering as a career discipline. He runs the Plumbers of Data Science brand and has been publishing tutorial material continuously since the field consolidated around the modern lake-house stack (Spark, Kafka, Snowflake, Databricks, Airflow).

His CourseFlix listing is the largest single-author catalog under this source — over thirty courses spanning data-pipeline construction, streaming architectures, the cloud-native data stack on AWS / Azure / GCP, the Python and Scala tooling that dominates the field, and the soft-skills / career side of breaking into data engineering. Material is paid and aimed at engineers transitioning into data work or already-working data engineers picking up specific tools.

What lessons are included in Schema Design Data Stores?

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 10 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Introduction
All Course Lessons (10)
#Lesson TitleDurationAccess
1
Introduction Demo
01:18
2
Why Data Modeling Is Important
05:46
3
The Dataset
01:29
4
Relational Databases
09:28
5
Wide Column Stores
07:36
6
Document Stores
07:29
7
Key Value Stores
04:50
8
Data Warehouses
04:45
9
Data Modeling Workshop Nov-2024
01:41:50
10
Conclusion
05:54
Unlock unlimited learning

Get instant access to all 9 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Books

Read Book Schema Design Data Stores

#TitleTypeOpen
1DataModeling PDF

What courses are similar to Schema Design Data Stores?

More courses by Andreas Kretz

Frequently asked questions

What are the prerequisites for enrolling in this course?
While the course does not explicitly list prerequisites, an understanding of basic database concepts and data management principles would be beneficial. Familiarity with different types of data storage systems such as relational databases and NoSQL storage could also help in grasping the schema design techniques discussed in the course.
What practical skills will I gain from this course?
You will learn to design schemas for various storage types, including relational databases, NoSQL storage, columnar storage, document databases, and key-value storage. The course also covers strategies for optimizing data storage and access, which are crucial skills for a data engineer working with diverse architectures.
Who is the target audience for this course?
This course is designed for data engineers and anyone involved in data management who wants to deepen their understanding of schema design. It's particularly useful for those looking to enhance their skills in optimizing data storage solutions across various platforms.
How does this course compare in depth to other courses on similar topics?
This course focuses on the specific aspect of schema design within data management, using detailed examples and real schemas from coaching sessions. It is more specialized than general data management courses, providing targeted strategies for schema design across multiple storage systems.
What specific tools or platforms are covered in this course?
The course covers schema design for a variety of storage systems, including relational databases, NoSQL storage, columnar storage, document databases, key-value storage, and data warehouses. While it does not focus on specific software tools, it provides strategies applicable across these platforms.
Are there any topics related to schema design that this course does not cover?
The course does not cover advanced database administration, real-time data processing, or specific software tools for schema design. Its focus is on the foundational and strategic aspects of schema design across various storage types.
What is the expected time commitment for completing this course?
The total runtime of the course lessons is not specified, but given the focus on detailed schema design methods and the inclusion of a data modeling workshop, students should expect to dedicate time to both learning and applying the concepts through exercises.