Databases from Scratch

Databases from Scratch

The Ubuntu TechHive (Abidjan, Côte d'Ivoire)
Upcoming Online python algorithms database fundamentals sql

🗄️ From Theory to Disk in 2 Hours

Ever wondered what happens when you run SELECT * FROM users? Join us for an intensive deep-dive into database internals! 🚀

📋 What You'll Learn

**🎯 The Foundation **

  • Why databases exist beyond simple text files
  • The relational model and SQL as a declarative interface
  • Real-world problems: concurrency, atomicity, and search performance

**⚙️ Engine Architecture **

  • Transport layer and connection handling
  • Query optimizer: turning SQL into execution plans
  • Storage engines: the muscle behind the magic
  • Buffer pools and memory management

**💾 Storage Deep-Dive **

  • How databases read in "pages" not rows
  • B-Trees vs LSM Trees: the eternal trade-off
  • Indexes: your data's phonebook 📞

**🔒 ACID & Transactions **

  • Atomicity, Consistency, Isolation, Durability
  • Locking vs MVCC: handling concurrent users
  • Write-Ahead Logs: surviving power outages

🎁 Bonus Live Demo Watch a simple CSV file transform into a lightning-fast "database" with just 10 lines of code! ⚡

🎯 Perfect For

  • Backend developers curious about database internals
  • Students learning computer science fundamentals
  • Anyone who's ever wondered "how does this actually work?"

📅 Event Details

Date: March 7, 2026
Time: 10:30 AM ET
Format: Interactive online session

Ready to peek behind the database curtain? Let's build understanding from the ground up! 🏗️

Connect with our vibrant community:

Details

Time:

Duration: 120 minutes

Organized by Aziz Sereme, ChiefKemist