Overview
If you are looking to manage data using something more powerful than a spreadsheet, this course is for you. You will learn how the backend of a database works. SQL is a coding language that is used to build many databases. It’s likely that you’ve used a database built with SQL!
In this course, you will practice finding data in a database, adding data to a database, and learn the fundamentals for building your own database. For the duration of this course, we will provide sample data, and a “sandbox” account where you can work with the data.
Who is this course for?
Pre-requisites:
- No prior SQL knowledge is necessary; you should however understand how to do use the Vlookup formula in Excel or Google Sheets.
- If you are looking to learn Vlookup, you can take our Building Analytics Reports in Google Sheets course
- If you already know some SQL, including WHERE, SUM, and AVG, we suggest taking one of our other courses.
Ideal applicants come from all walks of life, from seasoned organizers and campaigners looking to sharpen their skills, to beginners who are passionate about organizing and want to start their learning journey. Here are some attributes shared by all our applicants:
Technical Aptitude: Whether you have experience in organizing online or not, we are interested in organizers and campaign practitioners who want to rapidly develop their technical skills.
Organizing Insight: You don’t need to be a professional politico, but we’re looking for applicants with experience doing organizing work on the ground. That work can be tied to grassroots, electoral, and/or issue organizing. We seek to support organizers who are currently part of a campaign effort or are seeking to build one.
Dedication to Inclusive Politics and Intersectional Solutions: At re:power, we center race, class, gender and sexuality across all our trainings – it’s part of our practice of inclusive politics. We want organizers to be open to new ideas regarding it and to the ideas and contributions from their fellow organizers who will reflect our diverse communities.
Lesson Plan
- Intro to SQL + Data Structures
- SELECT Statements
- Aggregates
- JOINS
- Case Statements
- Maps + GIS
Questions? Please email data@repower.org.
