PhillyDB: Introductory Database Course - Part 2 - Data Modeling

In part 1 - Intro to SQL - you learned the basics of CRUD:

- Create - put data into tables using INSERT
- Read - access the data in tables using SELECT
- Update - change the data in tables using UPDATE
- Delete - remove the data from tables using DELETE

This gave you an understanding of how to work with databases that other people created. But many of you are working on your own projects, and sometimes have trouble understanding how to create your databases.

So in this meetup we're going to talk about data modeling - how to organize your data and structure the tables that the data will be stored in.

The goal of this meetup is to work our way through several examples, from simple to more complex. We think that you will learn best if these examples are relevant to you. So if you're having trouble figuring out how to start a project - for work, for a non-profit, for a hobby, whatever - let me know via email, and we'll see if we can work that into the agenda