Schema Design Data Stores

2h 30m 25s
English
Paid

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

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

Watch Online Schema Design Data Stores

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

#Title
1DataModeling

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

PyTorch for Deep Learning

PyTorch for Deep Learning

Sources: zerotomastery.io
Master PyTorch for deep learning with a step-by-step course. Build real-world projects and enhance your skills to become a Deep Learning Engineer.
52 hours 27 seconds
Machine Learning with Javascript

Machine Learning with Javascript

Sources: udemy, Stephen Grider
If you're here, you already know the truth: Machine Learning is the future of everything. In the coming years, there won't be a single industry in the world untouched by Machine...
17 hours 42 minutes 20 seconds
Machine Learning with Python : COMPLETE COURSE FOR BEGINNERS

Machine Learning with Python : COMPLETE COURSE FOR BEGINNERS

Sources: udemy
Machine Learning and artificial intelligence (AI) is everywhere; if you want to know how companies like Google, Amazon, and even Udemy extract meaning and insig
13 hours 12 minutes 31 seconds
Case Study in A/B Testing

Case Study in A/B Testing

Sources: LunarTech
Examples from practice in A/B testing - this course will introduce you to the methods of designing, conducting, and analyzing experiments using A/B...
1 hour 56 minutes 17 seconds
Complete Machine Learning and Data Science: Zero to Mastery

Complete Machine Learning and Data Science: Zero to Mastery

Sources: udemy, zerotomastery.io
This is a brand new Machine Learning and Data Science course just launched January 2020 and updated this month with the latest trends and skills! Become a complete Data Scientis...
43 hours 22 minutes 23 seconds