- Prepare (soft due Tu 10/12, hard due 10/18)
- Content below
- Sakai quizzes
- Group Worksheet (soft due W 10/13, hard due 10/18)
- Practice (due M 10/25)
- Perform (due M 11/8)
Content
5A.A – Relational Database (24 min.)
5A.B
- SQL Querying (21 min.)
- SQL with Python and Pandas (12 min.)
Optional Supplements
- SQLite Command Line Interface If you have a Mac/Linux machine, you should already be able to launch by just entering “sqlite3” in a terminal. If you have a Windows machine, you can download the command line interface from the Precompiled Binaries for Windows on the SQLite download page.
- Python SQLite3 API Documentation
- Pandas SQL Documentation
- w3resource SQLite Tutorial