Objective

Delivery

8/12/2025

Week 1: Kickoff & Setup – Foundations of SQL with DuckDB and NYC Taxi Dataset 

• 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

Week 1: Kickoff & Setup – Foundations of SQL with DuckDB and NYC Taxi Dataset

• 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

Week 2: Core Query Constructs – Strings, Dates & Logical Order Introduce week topics:

• 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

Week 2: Core Query Constructs – Strings, Dates & Logical Order 

• Engage audience to write queries to clean up trip timestamps,and peform simple, standard manipulation on string and date types

Online(Live Session)

8/27/2025

Week 3: Joins, Subqueries & Nested Types Introduce week topics:

• 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

Week 3: Joins, Subqueries & Nested Types

• 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

Week 4: Aggregation, Window Functions & CTEs Introduce week topics:

• 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

Week 4: Aggregation, Window Functions & CTEs

• 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

Week 5: Indexing, Query Optimization & TuningDiscuss week topics:

• Indexing strategies: clustered, nonclustered, covering, composite

• Query performance tuning: avoiding nested loops, reordering joins

• Best practices for query optimization

Online(Live Session)

9/13/2025

Week 5: Indexing, Query Optimization & Tuning Discuss week topics:

• 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

Week 6: Views, Stored Procedures & Error Handling Discuss implementation and week topics:

• Creating views for zonelevel trip KPIs and summaries

• Stored procedures: automating daily trip summary updates

• Error handling

Online(Live Session)

9/20/2025

Week 6: Views, Stored Procedures & Error Handling 

• Creating a view to expose only cleaned/verified trip data

• Create a view for daily zone trip metrics and a stored procedure for refreshing aggregated data

Online(Live Session)

9/23/2025

Week 7- Week 8: Putting it all Together, Final Projects & WrapUp 

• Analytical workflows: trip trends, customer profiles

• Final project discussions

Online(Live Session)

9/27/2025

Project Support

Online(Live Session)

9/30/2025

Project Support

Online(Live Session)

10/4/2025

Project Submissions

Online(Live Session)

10/5/2025

CLOSING CEREMONY

Online(Live Session)