Introduction

Notes on databases are categorized into three main buckets:

1. Database Engineering: Focuses on how to use and configure a database.
2. Database Systems: Covers the internals of databases and how to build them.
3. SQL: Explores the SQL language, its syntax, grammar, and how it works.

Contents

1. Database
   1. SQL
   2. Database Engineering
      1. Connection Pooling
      2. Transactions
      3. ACID
      4. Locks
      5. Indexes
      6. Query Optimization
      7. Partitioning
      8. Sharding
      9. Replication
      10. Cursor
   3. Database Systems
      1. Introduction
      2. Database Storage
      3. Log Structured Tree
      4. Index Organized Storage
      5. Hash Tables
      6. B-Trees
      7. Bloom Filter
      8. Skip List
      9. Trie
      10. Inverted Index
      11. Vector Index