Intro to SQL for Organizing with BigQuery
Turn a real organizing question into a documented BigQuery starting point. Six 20-minute modules. One final Organizer Query Brief.
MdR Palacios
Maria del Rosario Palacios is an author, data engineer, policy expert, and civic technology builder with more than 12 years of multilingual data and community work. Rosario previously served as Training Manager at Generation Data, where she launched the first Spanish-language Intro to Progressive Data course and taught data visualization, WhatsApp outreach, and community data practice to organizers across the South. MdR, also known as Rosario, has published three books, including Project Management for Xingones. Rosario has helped turn instructor knowledge into deployable learning systems in both leadership development and civic tech. She has been a 10-year certified train the trainer instructor with UGA's Fanning Institute for Leadership. She has developed multilingual curriculum for over fourteen years. Rosario has made the courses in this LMS build happen with Irma's QA systems thinking and Elton's civic storytelling lens, translating campaign needs into technical architecture that learners can actually use.
SQL and BigQuery
Frames SQL as a practical language for answering organizing questions, inspecting tables, and sharing reproducible findings.
Data engineering
Builds small, documented systems that make civic data easier to trust, reuse, and teach.
GitHub learning projects
Helped build the Movement Nerds and DatosLab GitHub course system, including SQL modules, project templates, and static LMS patterns.
Generation Data
Worked 4 years across intro progressive data, Spanish intro progressive data, visualization, and data engineering course support.
What you will do
You will play the role of a movement-tech data analyst. The course centers on the question a campaign, organizer, or community group would actually ask: we have a table that may answer this : can we get to a clean starting query and a plain-language finding in one sitting?
Question first
Every query starts from a real organizing question, not a syntax tour.
Build small artifacts
Each module adds one section to your Organizer Query Brief.
Practice with checkpoints
Short knowledge checks with feedback for correct and incorrect answers.
Earn badges
Six badges: Question Framer, Console Navigator, Schema Reader, First Query, Filter Builder, Brief Finisher.
Modules in this course
Six 20-minute modules. Each ends with one small artifact that feeds the final Organizer Query Brief.
SQL for Organizing
Define SQL in plain language, connect it to your team's real questions, and write the first sentence of your Organizer Query Brief.
Begin Module 1 MODULE 2 · 20 MINBigQuery Setup and Interface
Open BigQuery, get oriented in the console, and pick the project, dataset, and table you will inspect for your brief.
Begin Module 2 MODULE 3 · 20 MINReading a Table: Schema, Preview, Row Counts
Inspect schema, preview, and row counts before writing any query. Describe in plain language what one row of your table represents.
Begin Module 3 MODULE 4 · 20 MINYour First Query: SELECT, FROM, LIMIT
Write your first working BigQuery query against your chosen table. Learn the three pieces of every query, plus DISTINCT, commas, and backticks.
Begin Module 4 MODULE 5 · 20 MINFiltering and Sorting: WHERE, ORDER BY, LIMIT
Narrow rows with WHERE, combine conditions with AND/OR, handle NULLs the right way, and sort with ORDER BY so the headline row floats to the top.
Begin Module 5 MODULE 6 · 20 MIN · FINALSummarizing and Sharing: GROUP BY, COUNT, Saved Queries
Count and group rows with GROUP BY, filter groups with HAVING, save and share the query, and submit the completed Organizer Query Brief.
Begin Module 6Course content adapted from the SQL 101 in BigQuery slide deck by Maria del Rosario Palacios (2024).
Final artifact: Organizer Query Brief
A one-page brief that names your organizing question, points to the BigQuery table you used, sketches the query, and explains the finding in plain language. Every module contributes one section so the brief is mostly written by the time you reach Module 6.
| Section | Built in | What it contains |
|---|---|---|
| Organizing question | Module 1 | One sentence, in plain language. |
| Project, dataset, table | Module 2 | The full project.dataset.table path. |
| Table inspection notes | Module 3 | What one row represents, identifier and date columns, row count. |
| Starter query | Module 4 | A working SELECT … FROM … LIMIT against your table. |
| Filter and sort | Module 5 | The WHERE and ORDER BY that match your question. |
| Summary insight | Module 6 | One grouped finding, plus a saved or shared query link. |
How the course works
| Design need | How it appears in this course |
|---|---|
| Self-regulated learning | Set a goal at the start, return to it at each checkpoint. |
| Technology self-efficacy | BigQuery use starts with interpretation, then a starter query, then filtering and grouping. |
| Adaptive feedback | Checkpoints include feedback for both correct and incorrect answers. |
| Interaction | Plain-language rewriting, question sorting, schema reading, query writing. |
| Cognitive load reduction | Short LMS pages with one primary action per page. |
| Practical skill development | Each module produces one piece of the Organizer Query Brief. |
Accessibility & mobile
- Every diagram has alt text and a plain-language caption.
- Color is never the only signal for correctness or category.
- Pages are readable on phones; desktop is recommended for the BigQuery console activities in Modules 2 through 6.