1. Prepare (due M 2/21)
   1. Content below
   2. Sakai quizzes
2. Peer Instructions – See on the class forum
3. Homework (due Su 2/27)
4. Worked Example

Content

7.A – Relational Database (24 min.)

7.B

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