Class 8 Prep
Databases Part 2
Now you should have a good grasp on basic SQL syntax and commands, as well as an understanding of how relational databases work. In this lesson, we'll continue using a real database on your computer and also expand our knowledge of SQL by working through some additional exercises. If you haven't already please download and install Table Plus.
| Done | Task | Resource Type | Link | Instructions |
|---|---|---|---|---|
| Do | Exercises | SQLITE DATA DEFINITION | All sections (found on the right-hand column) | |
| Do | Exercises | SQLITE FUNCTIONS | All sections (found on the right-hand column) | |
| BONUS | Walkthrough | Writing SQLite in Python3 | Please attempt this walkthough if you have the time. The first 5 green boxes are the most important as they show you how to correctly write SQL in your Python code. |