Lab 1: Understanding Excel Limitations
Audit duplicates, inconsistent formats, missing values, and cross-file mismatches in the three departmental spreadsheets.
Labs
One lab a week, matched to the Canvas handouts. Earlier labs stay open for review; later ones open when released.
Explore Northshore Coffee with SELECT, aliases, calculated columns, and WHERE conditions.
Build a monthly KPI report from the fictional Grandma’s Marathon registration and race data.
Lab 4: The Deliveries Investigation
Clean records and reconstruct a delivery investigation using SQL string, numeric, date, and NULL functions.
Segment Northshore Coffee transactions with GROUP BY and HAVING, and defend what each group represents.
Lab 6: Meet Your Client (ERD) Current
Model your team’s actual client requirements and produce the ERD and schema design.
Rehearse Exam 1 with a closed-laptop paper section, followed by SQL and schema design on the Marathon data.
Answer questions across the normalized Twin Ports Tool Library tables using JOINs, subqueries, and CASE.
Lab 9: One Report, Many Sources
Combine café, event, and game-session activity into one consistent report with CASE and UNION.
Lab 10: From Paper to Database
Build and load your own client database from the ERD, then reconcile the imported data.
Create a reporting layer with views, transactions, and window functions on the Spirit Mountain data.
Refactor Duluth Market reports with CTEs, enforce rules with triggers, and measure index behavior.
Audit the inherited ticket-sales sheet, normalize it, migrate the data, and prove that nothing was lost.