This class will cover:
* How to break down a business problem into data
* Modeling a business problem based on the domains of the business
* Creating and normalizing relational data models
* Using Airtable to create robust prototype relational data models
* Using QuickDBD to create SQL Schemas (homework)
During the class we will discuss the basic approach to break business problems down and define them as data models. We'll cover how to decide what is a table, and what's a field, how to determine what data type to use, and how to "normalize" data. We'll practice creating databases in Airtable or QuickDBD for those who are more interested in a SQL schema. For the exercises, we'll create two example databases in Airtable based on your own ideas after we practice together.
If you're looking to learn how to use these skills to define schemas in SQL, resources will be provided after class for you to apply the principles from class to a SQL schema.
PREREQUISITES / PREPARATION
This class will be best for those who have used a spreadsheet before, like Google Sheets, Excel, or Numbers. If you use a spreadsheet for anything at work, even better!
This class does not require a familiarity with code, though the skills learned will be directly applicable to SQL if you intend to take our next class (https://www.meetup.com/Girl-Develop-It-San-Francisco/events/259353380/).
* Sign up with Airtable: https://airtable.com/invite/r/MHud1Ail (Liz's affiliate link, non affiliate link: https://airtable.com/)
* Imagine at least one business problem you would like to solve with data
• Your laptop (Mac, PC, Linux) and charger
• A modern web browser (Chrome, Firefox, Safari)
• An Airtable account
If you do not have a laptop, please contact the instructors. We have a limited number of Chromebooks for students to borrow.
Payment is required to attend. If you'd like to attend but cannot afford the cost, click here to request a scholarship (https://docs.google.com/forms/d/19YePb1ncNgHLFze40_BJRM7w8SG5mh1D0uB4qyKjwWs/viewform). Due to the number of applications, only the scholarship recipient will receive an email a few days before the workshop. Thank you for your understanding!
ABOUT THE TEACHERS
Liz Howard helped get the GDI SF chapter off the ground from 2012-2014 by teaching classes and organizing the chapter. She's helped found several schools, including Hackbright Academy, and the Web Development Immersive at Galvanize. Now she's a traveling instructor, focused on bringing the power of technology to everyone.
Check out Intro to SQL on Tuesday, April 2nd (https://www.meetup.com/Girl-Develop-It-San-Francisco/events/259353380/).