Schema

Schema design and data modeling

Useful when the hard part is not the query itself but the table design, relationships, and semi-structured data underneath it.

Back to Blog Performance Analytics Data Prep Advanced SQL Security

Best For

Use this topic path when the bottleneck looks like one of these

When the real problem is table structure, not query syntax

When you need to decide what belongs in one table, what should be split out, and how entities should connect

When schema flexibility, normalization, and relationships pull in different directions

When a design should stay easy to query, evolve, and explain to other developers

Reading Order

A practical way to move through this cluster

You do not have to read these in order, but this sequence is the fastest path from performance fundamentals into real query-tuning decisions.

Designing Your First Database Schema

Start with the blueprint mindset before worrying about normalization details or relationship edge cases.

SQL Table Relationships: One-to-Many and Many-to-Many

Then learn how entities connect through one-to-many and many-to-many structures.

Database Normalization Explained: 1NF, 2NF, 3NF

Use normalization rules after the basic entities and relationships are visible.

Working with JSON in SQL: NoSQL Powers in a Relational World

Finish with the semi-structured tradeoffs that appear when relational models meet messy real-world payloads.

Tool Workflows

Pair this topic with the right tools

These tool hubs support the same theme from a more practical angle. Read the articles here for explanation, then switch to the matching workflow page when you want to format SQL, inspect schema structure, or debug queries directly.

Conversion

Data import and conversion workflows

Useful when JSON, CSV, spreadsheets, or SQL seed files need to move quickly between application payloads and relational tables.

Open workflow hub

Schema

Schema design, modeling, and migration review

Use this cluster when the challenge is understanding table structure, relationships, migration impact, or how to generate realistic data from a schema.

Open workflow hub

Practice Challenges

Use these challenge pages for faster reps on the same concept cluster

Topic hubs are better for structured reading. Challenge pages are better when you want to switch from reading into hands-on practice without leaving the concept area entirely.

Product Price at a Given Date

Medium

Reconstruct each product’s price as of a snapshot date, including products that had not changed yet and still use the default price.

Open challenge

Tree Node

Medium

Classify each tree node as root, inner, or leaf based on whether it has a parent and whether it is referenced by children.

Open challenge

2026-03-09

11 min read

SQL Table Relationships: One-to-Many and Many-to-Many

Learn the two most important database relationships. Design one-to-many and many-to-many tables with real SQL examples, diagrams, and interactive queries.

Read article

2025-12-15

7 min read

Working with JSON in SQL: NoSQL Powers in a Relational World

Stop choosing between SQL and NoSQL. Learn how to store, query, and filter JSON data directly within your shiny relational database.

Read article

2025-12-07

8 min read

Database Normalization Explained: 1NF, 2NF, 3NF

Normalization sounds scary, but it is just like organizing your messy music playlist. Learn 1NF, 2NF, and 3NF without the boring theory.

Read article

2025-12-06

7 min read

Designing Your First Database Schema

Learn the fundamentals of database schema design, from tables and columns to relationships and normalization. Build a solid foundation for your data.

Read article