ICCT logo

Internal academy

ICCT Training Library

Data & Automation

SQL Reporting

Give students the query skills needed to answer operational questions, join related records, and build reporting confidence.

Beginner to Intermediate 3 credits 50+ guided hours 5 weeks Modules: 3 Projects: 2

Easy Interactive curriculum

Data Arcade for short, easy-to-digest learning

This course breaks big data & automation ideas into short missions, plain-language definitions, and interactive practice rounds. Give students the query skills needed to answer operational questions, join related records, and build reporting confidence.

Class missions: 3 10 minutes per topic Lab + quiz + homework + game

Class mission

Reading one table well

Minutes: 20

Big idea: Start with accurate filtering and sorting before adding complexity. We keep it simple, hands-on, and easy to explain back.

10 min

Selecting fields and narrowing results

SQL means the language used to ask a database for information In this topic we use it for WHERE clauses, wildcards, and date windows.

Quick picture: imagine using this in enrollment summaries.

Mission: use SQL to practice WHERE clauses, wildcards, and date windows.

SQL Query Database Spreadsheet
10 min

Sorting and shaping output

SQL means the language used to ask a database for information In this topic we use it for ORDER BY, aliases, and readable result sets.

Quick picture: imagine using this in at-risk student flags.

Mission: use SQL to practice ORDER BY, aliases, and readable result sets.

SQL Query Database Spreadsheet

Word wall

Terms made easy

SQL

the language used to ask a database for information

Query

a question you ask a database to find or change information

Database

a place where information is stored in an organized way

Spreadsheet

a grid of rows and columns used to organize and calculate information

Lab mission

Lab Mission

Create a roster report that isolates active students by campus and program year.

  1. Look at one example from enrollment summaries and point to where SQL shows up.
  2. Build one tiny version that uses SQL and Query in the right place.
  3. Tell a teacher or partner what you changed, what worked, and what you would improve next.
Homework

Homework: teach SQL in your own words, then create saved query library with one example, one picture, or one tiny screenshot.

Quick quiz

Check understanding in a friendly way

Game mode

Term Match Sprint

Matches: 0 / 4

Match each word to the right meaning as fast as you can.

Words
Meanings

Pick a word, then pick the matching meaning.

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.