Skip to main content
Dantes.io Logo
Dantes.io

Best resources to learnDatabase Design

Study sheet

Database design is the process of planning and structuring a database to ensure data integrity and efficiency. Learners will understand entity-relationship diagrams, normalization, primary and foreign keys, and how to design schemas that prevent data redundancy.

Where to start

Start with Database Star, Ben Brumm's free tutorial site, whose normalisation and schema modelling guides include runnable scripts so you can practise each technique. If you only use one resource, make it Michael J. Hernandez's Database Design for Mere Mortals, a vendor-neutral, step-by-step method for relational design. For the theory behind normal forms, move on to C. J. Date's Database Design and Relational Theory.

9 resources · · How we curate

🎓Courses(2)

course

Database Design

University of Colorado Boulder course, part of its data science master's, covering the relational model, entity-relationship modelling and normal forms. Learners translate requirements into an ER diagram and then into normalized SQL table definitions.

intermediate🇬🇧
course

Advanced Database Design

Microsoft's SQL Server course pairing normalization and entity-relationship modelling with advanced querying: complex joins, subqueries, common table expressions and aggregates. Learners build schema objects with DDL, enforce constraints, and write analytical queries against them.

intermediate🇬🇧

📚Books(2)

bookPaid

Database Design for Mere Mortals

A vendor-neutral, step-by-step method for relational design: identifying entities, defining fields and keys, establishing table relationships and applying business rules. Readers finish able to produce a normalized logical schema before writing any SQL.

intermediate🇬🇧
bookPaid

Database Design and Relational Theory

C.J. Date grounds schema design in the formal relational model, working through functional dependencies, normal forms up to fifth and sixth, and why each matters. Prior comfort with SQL and set theory is assumed.

intermediate🇬🇧

🌐Websites(5)

scroll for more →
website

dbdiagram.io

A browser-based diagramming tool where you write schemas in a simple DSL and it renders the entity-relationship diagram automatically. Useful for sketching tables, keys and relationships, then exporting SQL DDL or sharing the diagram.

beginner🇬🇧
website

Database Star

Ben Brumm's tutorial site covering SQL syntax across Oracle, PostgreSQL, MySQL and SQL Server, plus normalization and schema modelling guides. Articles include runnable scripts and sample datasets, so readers can practise each design or query technique directly.

beginner🇬🇧
website

vertabelo.com

Vertabelo is an online data modeling and database design platform that lets you create and visualize ER diagrams, design schemas, and generate SQL code. It also offers tutorials, articles, and resources on database design best practices for learners and professionals.

intermediate🇬🇧
website

SQLShack

Free article library started by ApexSQL, written by SQL Server professionals, covering T-SQL, indexing, query tuning, backup and recovery, high availability, auditing and SSIS. Readers can follow step-by-step examples to administer, secure and tune SQL Server instances.

intermediate🇬🇧
website

use-the-index-luke.com

A practical guide to database indexing and query optimization, offering clear explanations of how indexes work, how to design them, and tutorials with SQL examples across major relational databases.

intermediate🇬🇧
Share this topic

More in Databases

See all 21 topics in Databases →

Frequently Asked Questions

Where should I start learning Database Design?

Start with Database Star, Ben Brumm's free tutorial site, whose normalisation and schema modelling guides include runnable scripts so you can practise each technique. If you only use one resource, make it Michael J. Hernandez's Database Design for Mere Mortals, a vendor-neutral, step-by-step method for relational design. For the theory behind normal forms, move on to C. J. Date's Database Design and Relational Theory.

What are the best free resources to learn Database Design?

Dantes has curated 9 resources for Database Design, including 2 books, 2 courses, 5 websites. All resources are hand-picked for quality — no algorithmic filler. Browse the full list above to find the format that works best for you.

Is Database Design hard to learn?

Database Design is approachable at the beginner level — there are resources here specifically for those starting from scratch. As you progress, intermediate and advanced material is also available to take your skills further.

What types of Database Design learning resources are available on Dantes?

For Database Design, Dantes has curated 2 books, 2 courses, 5 websites. Each resource type serves a different learning style: videos and YouTube for visual learners, books for depth, courses for structured progression, and websites for quick reference.

How does Dantes select Database Design resources?

Dantes is an algorithm-free learning directory. Resources are hand-curated based on quality, accuracy, and usefulness — not engagement metrics or paid placements. The goal is to surface the best learning material for Database Design, whether it's a free YouTube series, a classic textbook, or an open courseware from a top university.

Go deeper

Test your understanding of Database Design

Explain it out loud. An AI tutor listens and asks questions that expose gaps you didn't know you had.