Last updated February 9, 2019 at 10:00PM.

General Information

• Introduction to NanoDB Codebase
• Setting Up NanoDB on Windows
• Automated Testing
• Modifying the NanoDB Parser
• Adding Functions to NanoDB

Assignments

• Assignment 1: NanoDB Set-Up and Storage Layer
• Assignment 2: SQL Translation and Joins
• Assignment 3: Table Statistics and Plan Costing
• Assignment 4: Join Optimization
• Assignment 5: Advanced Subqueries
• Assignment 6: B+ Tree Indexes
• Assignment 7: Write-Ahead Logging

Challenges

• Challenge 1: Load the TPC-H Data Set
• Challenge 2: Run the TPC-H Queries