Subsection 1.1

Course roadmap

~3 min

Reading

Welcome to Intro to SQL for Organizing with BigQuery.

In this course, you will use a real organizing question to learn the building blocks of SQL inside BigQuery. You do not need to be a developer. You do not need to be a data engineer. You do not need to be a Google Cloud expert.

You need three things:

A real question.
A Google account.
A willingness to read tables and schemas carefully.

Your role in this course is to act like a movement-tech data analyst. A campaign team, community group, labor organization, civic organization, or newsroom might come to you with a practical question:

We have a table that should help answer this. Can we get from the question to a clean starter query and a plain-language finding in one sitting?

That is the workflow you will practice.

You will move through six short modules:

SQL for Organizing: define SQL and name the question.
BigQuery Setup and Interface: open BigQuery and find the right table.
Reading a Table: inspect schema, preview, row counts, and data types.
Your First Query: write a SELECT, FROM, and LIMIT query.
Filtering and Sorting: use WHERE, AND, OR, NULL checks, and ORDER BY.
Summarizing and Sharing: use GROUP BY, COUNT, saved queries, and a final brief.

Each module adds one section to your Organizer Query Brief. By the end, you will have a one-page artifact that names the question, points to a real BigQuery table, sketches the query, and explains the finding in plain language.

Before you begin, place yourself on the confidence scale:

Level 1: I have never written SQL and I am unsure what a database is.
Level 2: I have heard of SQL but never run a query.
Level 3: I have used SQL once or twice from a tutorial.
Level 4: I write SQL occasionally and want a refresher tied to organizing work.

At Level 1, focus on plain-language explanations and checkpoints. At Level 2, pay attention to syntax patterns. At Level 3, use the brief as a portfolio piece. At Level 4, treat the course as a model for how you might teach SQL to your own team.

Learner action

Choose one organizing or program question you want data to help answer. Keep it nearby. You will return to it throughout the course.

Welcome to Intro to SQL for Organizing with BigQuery.

In this course, you will use a real organizing question to learn the building blocks of SQL inside BigQuery. You do not need to be a developer, data engineer, or a Google Cloud expert. You only need a real question, a Google account, and a willingness to read schemas carefully.

Your role is to act like a movement-tech data analyst. A campaign team, community group, or newsroom might ask:

"We have a table that should help answer this : can we get from the question to a clean starter query and a plain-language finding in one sitting?"

By the end of the course, you will produce an Organizer Query Brief: one page that names the question, points at a real BigQuery table, sketches the query, and explains the finding in plain language.

Diagram 1.1 · Course roadmap. Six 20-minute modules build one Organizer Query Brief, one section at a time.

Confidence pulse

Before you begin, choose the statement that best describes you.

Level 1. I have never written SQL and I am unsure what a database is.
Level 2. I have heard of SQL but never run a query.
Level 3. I have used SQL once or twice from a tutorial.
Level 4. I write SQL occasionally and want a refresher tied to organizing work.

What to expect at your level

Level 1: Focus on the plain-language explanations and checkpoints. Level 2: Pay attention to syntax patterns. Level 3: Use the brief as a portfolio piece. Level 4: Treat the course as a way to model how you teach SQL to your team.

Action: Pick your confidence level, then continue to the case framing.

Slide to complete