Intro to Database Systems

Intro to Database Systems

Taught by Professor Andy Pavlo at Carnegie Mellon University, this in-depth course teaches the core design and implementation concepts behind modern database systems — from data modeling to distributed architectures.

🗄️ What You’ll Learn:

• Data Models: Relational, document, and key/value
• Storage Models: N-ary, decomposition, and log-structured
• Query Languages: SQL, stored procedures
• Indexing: B-trees, hash tables, and order-preserving structures
• Transactions: ACID properties, concurrency control
• Recovery Techniques: Logging, checkpoints
• Query Processing: Joins, sorting, aggregation, and optimization
• Parallel Architectures: Multi-core and distributed systems
• Case Studies: Open-source and commercial DBMS design trade-offs

🧠 Why Watch This Course?

• Taught by a leading expert in database research
• Covers both theory and real-world implementations
• Ideal supplement for systems programming knowledge
• Clear, engaging, and academically rigorous

✅ Requirements

• Comfort with systems programming and basic computer science concepts
• SQL basics will help, but not strictly required at the start

👨‍💻 Who Is It For?

• Computer science students interested in databases
• Backend developers who want to understand DB internals
• Engineers looking to build high-performance or distributed apps

Get a deep understanding of the systems that power the modern web — learn from one of the best.