Database Performance Optimization Workshop
Hands-on workshop on SQL optimization, indexing strategies, and query tuning for PostgreSQL and MySQL.
About This Event
Hands-on workshop on SQL optimization, indexing strategies, and query tuning for PostgreSQL and MySQL.
Agenda
Day 1 9:00 AM - Query Performance Fundamentals
Day 1 10:00 AM - EXPLAIN ANALYZE Deep Dive
Day 1 11:30 AM - Indexing Strategies & B-Trees
Day 1 1:00 PM - Lunch Break
Day 1 2:00 PM - Composite & Covering Indexes Lab
Day 1 3:30 PM - Query Rewriting Techniques
Day 1 4:30 PM - JOIN Optimization Workshop
Day 1 5:00 PM - Day 1 Review
Day 2 9:00 AM - Connection Pooling & Configuration
Day 2 10:30 AM - Table Partitioning Strategies
Day 2 12:00 PM - Materialized Views & Caching
Day 2 1:00 PM - Lunch Break
Day 2 2:00 PM - Normalization vs Denormalization
Day 2 3:00 PM - Monitoring & Maintenance Best Practices
Day 2 4:00 PM - Real-World Case Studies
Day 2 4:45 PM - Open Lab: Optimize Your Queries
Day 2 5:30 PM - Certification & Closing
Event Details
Date & Time
May 22-23, 2026
9:00 AM - 5:00 PM (Both days)
Location
Logicode Training Center, Nairobi
Category
workshopDiscover
Related Events
FinTech Innovation Hackathon: Build Payment Solutions
48-hour hackathon building financial technology solutions - M-Pesa integration, payment gateways, and digital banking.
Next.js 15 Masterclass: Building Production Apps
Intensive 3-day workshop covering Server Components, App Router, and advanced patterns - build a full production app.
Nairobi Dev Meetup: Tech Talks & Networking
Monthly gathering of developers, tech entrepreneurs, and IT professionals - presentations, networking, and knowledge sharing.