Outcomes
What students should leave with
- Write queries that filter, sort, group, and summarize records.
- Join related tables to answer operational questions with context.
- Prepare clean result sets for dashboards, exports, or automation.
Reference map
Core topics to cover
SELECT
WHERE
ORDER BY
JOIN
GROUP BY
CASE
Views
Module sequence
ICCT lesson flow
Module 1
Reading one table well
Lessons: 2
Start with accurate filtering and sorting before adding complexity.
Selecting fields and narrowing results
WHERE clauses, wildcards, and date windows
Sorting and shaping output
ORDER BY, aliases, and readable result sets
Checkpoint lab
Create a roster report that isolates active students by campus and program year.
Module 2
Joining related records
Lessons: 2
Connect people, courses, terms, and outcomes into useful reporting views.
Inner joins for connected records
matching tables and preventing duplicate confusion
Grouping and summary metrics
COUNT, AVG, and grouped rollups
Checkpoint lab
Build a section-level report that combines enrollment counts, teacher assignments, and attendance totals.
Module 3
Operational decision support
Lessons: 2
Turn raw queries into repeatable reporting habits.
Conditional labels and status logic
CASE statements and clean interpretation
Views, exports, and handoff readiness
saved reporting patterns and stakeholder delivery
Checkpoint lab
Create an at-risk progress report that combines grades, attendance signals, and enrollment status.
Capstone prompts
Projects students can actually ship
Enrollment Health Report
Surface active counts, new starts, and recent withdrawals by campus or term.
Completion Progress Dashboard
Summarize course completion signals and staff follow-up priorities.