Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
Explore the inner workings of databases by building one from scratch using Python. Learn how to create an interface for communicating with the database, develop a simple SQL-based language for queries, and implement a REPL using Prompt toolkit. Dive into data storage techniques, starting with in-memory dictionaries and progressing to disk persistence. Discover the importance of indexing by implementing a basic B-tree index to improve query performance. Gain insights into future improvements such as ACID transactions, concurrency support, and lock handling. By the end of this talk, gain a deeper understanding of database fundamentals through hands-on development.
