Module 09: Databases and SQL

1. Prepare (due Mon 03/25)
   1. Content below
   2. Canvas quizzes
2. Class Participation – See on the class forum
3. Homework (due Sun 03/31) [LINK]
4. Worked Example [LINK]

Content

09.A – Relational Database

1. Relational Database (24 min.)

09.B – SQL Python and Pandas

1. SQL Querying (21 min.)
2. 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
• Database Schema Visualizer