MEET OUR TRAINER.
Trainer Profile:
Hi, I’m Barongo—a data professional with a foundation in software engineering and a deep appreciation for systems thinking. I’ve worked across SaaS and fintechs, building applications using data as our driving undercurrents. I learnt SQL on survival mode, but out of this traumatic experience came the inspiration for this workshop.
Outside the syntax and Leetcode challenges is a powerhouse in the data space. This SQL AMA Workshop is built to reflect and contextualize the value of this language in business and tech teams. Over eight weeks, we’ll explore one dataset deeply, iteratively, and practically. You’ll sharpen how you ask questions, how you structure solutions, and ultimately how you think in SQL.
And yes—this is the session where you can ask me anything. Link to the same intro, but longer: SQL AMA Full
Objectives
Again, this isn’t a syntax sprint. It’s a workshop about reasoning.
Together, we’ll go beyond keywords to understand how SQL helps us shape data, structure problems, and find clarity.
COURSE OUTLINE
| Objective | Delivery |
8/12/2025 | Course orientation:Discuss objective for SQL AMA, align participant and my expectations, and discuss collaboration guidelines Environment setup: DuckDB Introduction, usecases, ensure participants understand how to use this dataframe tool to write SQL Introduction to the NYC Taxi dataset: trip records, zones, payments
| Online (Live Session) |
8/16/2025 | Data types and Schema basics: NUMERIC, VARCHAR, DATE, JSON CRUD operations: INSERT, UPDATE, DELETE Data integrity: PRIMARY KEY, FOREIGN KEY, NOT NULL Clarify on GitHub workflow for collaborative coding Demonstrate how to submit to GitHub repo
| Online (Live Session) |
8/19/2025 | String manipulation (TRIM, CONCAT, REPLACE, LIKE) Date/time manipulation (DATEPART, TIMESTAMP, EXTRACT, formatting) Logical query processing order: FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY Discuss Practical tips for readable, maintainable queries
| Online (Live Session) |
8/23/2025 | | Online (Live Session) |
8/27/2025 | Join types: INNER, LEFT, RIGHT, FULL OUTER Using joins with NYC trip data and zone lookups Subqueries: scalar, nested, correlated
| Online (Live Session) |
8/30/2025 | Practical scenarios: linking trip data to zone names, identifying top tips by zone Join trip data with zones to find busiest pickup/dropoff locations; write subqueries to get various subsets of the data
| Online (Live Session) |
9/2/2025 | Aggregate functions: SUM, AVG, COUNT, MIN, MAX Advanced GROUP BY use cases: group by zone, day of week Window functions: RANK, ROW_NUMBER, DENSE_RANK moving averages CTEs for modular, reusable queries
| Online (Live Session) |
9/6/2025 | Discuss Trip duration averages, peak hour analysis with window functions Write queries with window functions to calculate rolling trip counts by zone
| Online (Live Session) |
9/9/2025 | Indexing strategies Query performance tuning: avoiding nested loops, reordering joins Best practices for query optimization
| Online (Live Session) |
9/13/2025 | Indexing strategies: clustered, nonclustered, covering, composite Query performance tuning: avoiding nested loops, reordering joins Best practices for query optimization
| Online (Live Session) |
9/16/2025 | | Online (Live Session) |
9/20/2025 | | Online (Live Session) |
9/23/2025 | | Online (Live Session) |
9/27/2025 | Project Support | Online (Live Session) |
9/30/2025 | Project Support | Online (Live Session) |
10/4/2025 | Submissions | Online (Live Session) |
10/5/2025 | CLOSING CEREMONY | Online (Live Session) |
