...
| View file | ||
|---|---|---|
|
Pre-watching
Nathan Williams does a really good introduction to SQL broken down into easy-to-learn videos, so I’ve linked to the videos in his playlist for all but the first video below. I won’t be using pgAdmin or using the Northwind data set (which he covers in the first and second video, respectively) for our LiteFarm specific session, but it probably makes sense to watch those videos when you’re getting started so that you can more effectively follow along with the videos we do cover.
What is SQL? (4 minutes)Basics of
SQL (15 minutes, jump to 2:22Basic SQL queries (7 minutes)
What is a data model?
A data model is a structured collection of tables. Following object oriented principles, tables are generally created to hold information about a conceptual idea such as a task, farm, or user. There are important exceptions to this rule, but in general, this is the case. Each table has certain attributes or columns that fit within the concept of the table. For example, the user table would have columns such as username, email, and name that relate to every user. Each row in that table is a one instance - or record - of that table. Using our user table example, you could have:
...