Schema Design Data Stores
Course description
During my coaching sessions, one important topic keeps coming up repeatedly - schema design. Therefore, I decided to create a separate course in the academy to explain in more detail how to develop data schemas for various storage systems.
As a learning example, we will use an e-commerce dataset, which you are familiar with from other courses. I have also included real schemas from coaching sessions to demonstrate how design can look in different scenarios.
Read more about the course
First, we will discuss why schema design is so important and the key role it plays in the work of a data engineer. You will also learn that even NoSQL storage requires a well-thought-out schema - it helps create a maintainable structure and avoid the “data swamp.”
Then we will take a detailed look at how to design schemas for various types of storage:
- relational databases,
- NoSQL storage,
- columnar storage,
- document databases,
- key-value storage,
- and data warehouses.
You will learn how to approach schema design for different tasks and architectures.
By mastering this course along with materials from "Choosing Data Stores," you will be able not only to choose the right storage for the task but also design an efficient and logical schema for it. This will help you optimize data storage and access within your platform.
Watch Online
All Course Lessons (10)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 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 subscriptionBooks
Read Book Schema Design Data Stores
| # | Title |
|---|---|
| 1 | DataModeling |
Comments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
The Data Bootcamp: Transform your Data using dbt™
Data Engineering on Databricks
Dimensional Data Modeling
Storing & Visualizing Time Series Data
