Schema Design Data Stores

2h 30m 25s
English
Paid

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 Schema Design Data Stores

Join premium to watch
Go to premium
# Title Duration
1 Introduction 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

Read Book Schema Design Data Stores

#Title
1DataModeling

Similar courses to Schema Design Data Stores

Statistics for Data Science and Business Analysis

Statistics for Data Science and Business Analysisudemy

Category: Data processing and analysis
Duration 4 hours 49 minutes 30 seconds
Python for Data Science and Machine Learning Bootcamp

Python for Data Science and Machine Learning Bootcampudemy

Category: Python, Data processing and analysis
Duration 24 hours 49 minutes 42 seconds
Dimensional Data Modeling

Dimensional Data ModelingEka Ponkratova

Category: Data processing and analysis
Duration 1 hour 37 minutes 57 seconds
The Data Bootcamp: Transform your Data using dbt™

The Data Bootcamp: Transform your Data using dbt™udemy

Category: Data processing and analysis
Duration 4 hours 10 minutes 51 seconds
Data Engineering on Databricks

Data Engineering on DatabricksAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 27 minutes 29 seconds
Learning Apache Spark

Learning Apache SparkAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 44 minutes 4 seconds
Snowflake for Data Engineers

Snowflake for Data EngineersAndreas Kretz

Category: Data processing and analysis
Duration 2 hours 4 minutes 8 seconds
The Data Engineering Bootcamp: Zero to Mastery

The Data Engineering Bootcamp: Zero to Masteryzerotomastery.io

Category: Data processing and analysis
Duration 13 hours 23 minutes 15 seconds
Apache Kafka Fundamentals

Apache Kafka FundamentalsAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 4 minutes 52 seconds
The Data Science Course: Complete Data Science Bootcamp 2023

The Data Science Course: Complete Data Science Bootcamp 2023udemy

Category: Data processing and analysis
Duration 31 hours 14 minutes 14 seconds