README

Awesome Database Learning

A list of learning materials to understand databases internals, including but not limited to:

- papers
- blogs
- courses
- talks

Please submit a pull request if there is any material that you think should be included in this collection.

 Table of Contents



 Recommended Courses, Books and Talks
     Courses
     Books
     Talks
     Blogs
 SQL & Relation Algebra
 Query Optimizer
     Planner Models
     Subquery Optimization
     Join Order Optimization
     Functional Dependency & Physical Properties
     Cost Model
     Statistics
 Query Execution
     Execution Framework
     Vectorization vs Compilization
     Join
     Hash Table
     Bloom Filter
 DDL
 Relational Model
     Codd's Rules
     Relational Data Model
     Relational Algebra
     ER to Relational Model
     SQL - Overview
 Transaction
     Isolation Levels
     Concurrency Control
 Network
 Storage
     NoSQL Systems
     Buffer Management
     Disk IO
     B-Tree
     LSM-Tree
     Learned Indexes Structures
 Serializing & RPC
 Data Partitioning
 Replication & Consistency
 Consensus
 Scheduling
 Benchmark & Testing
 HTAP
 TLA+



 Recommended Courses, Books and Talks

 Courses

- CMU Database Systems (15-445/645), thanks to Andy Pavlo
- CMU Advanced Database Systems (15-721), thanks to Andy Pavlo
- UC Berkeley Introduction to Database Systems
- Stanford Database System Implementation
- Cornell Introduction to Database Systems by Prof. Trummer
- Let's Build a Simple Database, thanks to cstack

 Books

- Stanford Database Systems: The Complete Book
- Designing Data-Intensive Applications, 中文翻译
- Database Internals
- Foundations of Databases
- Readings in Database Systems, 5th Edition
- Database Design and Implementation: Second Edition (Data-Centric Systems and Applications)
- Principles of Distributed Database Systems, 4th ed
- Inside SQLite
- Architecture of a Database System
- Relational Database Index Design and the Optimizers
- Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control

 Talks

- Data Structures and Algorithms for Big Databases
- A Journey From A Quick HackTo A High-Reliability Database Engine

 Blogs

- How does a relational database work
- The Internals of PostgreSQL
- Books propose
- what is database and its types

 SQL & Relation Algebra

Courses:

- CMU Database Systems (15-445/645), thanks to Andy Pavlo
    - Course Introduction and the Relational Model
    - Advanced SQL

- UC Berkeley Introduction to Database Systems
    - Introduction + SQL I
    - SQL II
    - Relational Algebra

 Query Optimizer

Courses:

- CMU Database Systems (15-445/645), thanks to Andy Pavlo
    - Query Planning & Optimization I
    - Query Planning & Optimization II

Blogs:

- 数据库内核杂谈, thanks to 顾仲贤
    - 数据库内核杂谈（七）：数据库优化器（上）
    - 数据库内核杂谈（八）：数据库优化器（下）
- SQL优化器原理 - 查询优化器综述, thanks to 勿烦

 Planner Models

Blogs:

- 数据库内核杂谈, thanks to 顾仲贤
    - 数据库内核杂谈（九）：开源优化器 ORCA
- SQL 查询优化原理与 Volcano Optimizer 介绍, thanks t