Welcome to CS186’s online notes! Click on any of the topics on the left to learn more.

PDF

• SQL Part1 - Basic Queries
• SQL Part2 - Joins & Subqueries
• Disks and Files
• B+Trees
• Buffer Management
• Relational Algebra
• Hashing
• Sorting
• Iterators and Joins
• Transactions & Concurrency Ⅰ
• Transactions & Concurrency Ⅱ
• DB Design
• Recovery
• Parallel Query Processing
• Distributed Transactions
• NoSQL
• MapReduce and Spark
• Spatial and Vector Indexes
• Consensus