Databases from Scratch
·
The Ubuntu TechHive North America (Atlanta, Georgia USA)
Próximo
En línea
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:
Ubicación
Detalles
Hora:
Duración: 120 minutos
Organizado por Aziz Sereme, ChiefKemist