🧭 Learn DBMS Together

Awesome list of high-quality study materials for learning database management systems.

⬇️ Tags legend at the end of the page.

DBMS Introduction

( dbms )

Database Systems and PostgresSQL | 2 part 🎥 🎓 ( level_1 ) by Professor Immanuel Trummer at Cornell University
⭐ Databases Course 🎥 🎓 ( level_1 ) by Professor Jörg Endrullis at Vrije Universiteit Amsterdam
⭐ Database Design & Management 🎥 🎓 ( level_1 ) by Dr. Daniel Soper at California State University
Database Design & Management 🎥 🎓 ( level_2 ) by Professor Joseph Hellerstein at Berkley Univirsity
Databases 🎥 🎓 ( level_1 ) by CS186Berkeley
SQL Tutorial | MySQL 🎥 🎓 ( level_0 ) by freeCodeCamp
SQL Tutorial 🎥 🎓 ( level_0 ) by freeCodeCamp
SQL For Web Developer 🎥 🎓 ( level_0 ) by freeCodeCamp
Database Systems 🎥 🎓 ( level_0 ) by Neso Academy

DBMS Specific

( dbms )

Database Engineering 🎥 ( level_2 ) by Hussein Nasser : playlist cover many unrelated PostgresSQL-specific topcis
PostgresSQL Lessons 🎥 ( level_2 ) by Hussein Nasser : playlist cover many unrelated PostgresSQL-specific topcis
Database Systems 🎥 🎓 ( level_2 ) by The Magic of SQL
SQL Course 🎥 🎓 ( level_3 ) by SQL TV
PostgreSQL Perfomance Tuning 🎥 🎓 ( level_3 ) ( postgresql ) by High-Performance Programming

SQL

( sql ) ( skill )

⭐ SQL Skills 🎥 ( level_1 ) ( sql ) ( skill ) by techTFQ
SQL Lessons 🎥 ( level_3 ) ( sql ) ( skill ) by Bert Wagner : playlist cover many unrelated SQL-specific topcis

SQL Drills

⚡

Data Stacks

⚡

mode.com ⚡

Certifications

( certificate )

Hacker Rank ( certificate )

DBMS concepts

( dbms )

7 Database Paradigms 🎥 by Fireship ( short )
ACID Explained: Atomic, Consistent, Isolated & Durable 🎥 by the roadmap
What is Database Sharding? 🎥 by Gaurav Sen
Database Indexing 🎥 by Hussein Nasser

DBMS comparison

( dbms )

Introduction to NoSQL databases 🎥 by Gaurav Sen
Relational database index vs. NoSQL index 🎥 by Gaurav Sen
Column vs Row Oriented Databases 🎥 by Hussein Nasser
OLAP vs OLTP 🎥 by IBM Technology
Database vs Data Warehouse vs Data Lake 🎥 by Alex Freberg

Key-value database

( dbms ) ( key-value )

Redis in 100 Seconds 🎥 by Fireship ( key-value ) ( short )
Memcache Basics 🎥 by Google Developers ( key-value ) ( short )

Wide column database

( dbms ) ( wide_column )

Cassandra Database Crash Course 🎥 by Code with Irtiza

Document-oriented database

( dbms ) ( document-oriented )

MongoDB in 100 Seconds 🎥 by Fireship ( document-oriented ) ( short )

Time series database

( dbms ) ( time_series )

What is InfluxDB? 🎥 by CBT Nuggets

Useful Tools

( tool )

Amazing People and Organizations

( subjects )

Professor Immanuel Trummer and his lecture on DBMS : lecturer at Cornell University
Professor Jörg Endrullis and his lectures : lecturer and amazing source of knowledge at Vrije Universiteit Amsterdam
Dr. Daniel Soper and his lectures : lecturer and amazing source of knowledge at California State University
Professor Joseph Hellerstein and his lecture on DBMS : lecturer at Berkley Univirsity

Tags legend

Kind of Resource

🎥 - video material to watch
📄 - reading
📖 - a book
🎓 - online course with or without feedback
📈 - cheat sheets
🗃️ - reference or manual or a standard
📂 - collections of collections
🏴‍☠️ - non-english
📄 - either single article or single video-tutorial
🏗️ - ideas for inspiration of mini-projects to add to your portfolio
💰 - paid
( certificate ) - certification
🔽 - download
⚡ - practice, it is possible to interact and get feedback from the system
( official ) - official material
( blog ) - blogs
( example ) - code sample that can be executed
( short ) - short overview
( tool ) - a tool
( subjects ) - people and organizations
( skill ) - not a theory, but practices oriented

Level of Expertise

( level_0 ) - very basic and trivial, every professional should know no matter which specialization
( level_1 ) - basic but not trivial, every professional should know no matter which specialization
( level_2 ) - medium proficiency, most professional should know no matter which specialization
( level_3 ) - advanced, not recommended unless it fits specialization

Other Categories

( dbms ) - database manageement systems
( key-value ) - key-value database
( systems_design ) - systems design key concepts
( document-oriented ) - document-oriented DBMS
( wide_column ) - wide column database
( relational ) - relational database
( sql ) - sql related