Awesome Database Design

A collection of resources and tutorials to model entity relationship and design a better database schema.

Preamble

I am a self taught programmer. I understand the frustation and joy of being a self taught progrmmer. I have myself spent a lot of time to just find proper resources for learning a new thing. When it comes to database design, there are not that much resources on internet. You have to collect many pieces and build your knowledge.

Over the past couple of mongths, I've accumulated bookmarks, saved stackoverflow, dbexchange posts, youtube links, Udemy courses and GitHub stars all related to schema design and entity modeling. This list is my attempt to add structure to those resources and share them. Everything you need to get started on your first database design project.

How to use this list

Some items in this list could easily fit in more than one category, so to make sure you find what you're looking for please use Ctrl + F (or Cmd + F on macOS).

Youtube

• Normalization - 1NF, 2NF, 3NF and 4NF
• Database Conceptual Design| Entities and Relationships
• Data Modeling - Complex Relationships
• Database Conceptual Design| Entities and Relationships
• conceptual, logical and physical design for a database
• Models for Hierarchical Data in SQL
• Database Lessons
• B Trees and B+ Trees
• Introduction to RDBMS and design
• Database Sharding Crash Course (with Postgres examples)
• Subquery in SQL | Correlated Subquery
• SQL JOINS - Part 1
• SQL JOINS - Part 2
• Database Design Playlist
• Carnegie Mellon University lectures

Stackoverflow

• Represent inheritance in a database
• Inheritance in a database I
• Inheritance in a database II
• Storing hierarchical data in a relational database
• Database design for multiple language
• Difference between identifying and non-identifying relationships
• Database, Table and Column Naming Conventions
• Character set and Collation
• Proper use of array in Postgresql
• Why do you create a View in a database?
• Best practices for multi-language database design

dba.stackexchange

• Super type/Sub type design pattern I
• Super type/Sub type design pattern II
• Using NULL properly- You decide

Quora

• Difference between NF, 2NF, and 3NF

Blogs an Links

• Managing hierarchical data in mysql
• Managing hierarchical RDBSM
• SQL Training Videos
• Premade Database Designs and Models
• Database design for multiple language
• MySQL: Building the best INDEX for a given SELECT
• Database Normalization Tutorial with example
• A guide to database performance for developers
• A Quick-Start Tutorial on Relational Database Design
• Database Journal - FEATURED DATABASE ARTICLES
• Multilanguage Database Design in MySQL
• 8 Reasons Why MySQL's ENUM Data Type Is Evil
• The Difference between 2NF and 3NF
• How do database indexes work?
• Things You Should Know About Databases

Cheatsheets

• Normal Forms
• • SQL Commands

Bonus - Off Topic

• Ultimate guide to understanding CORS
• git pull Vs git fetch