Module 09: Databases and SQL

1. Prepare (due Mon 11/6)
   1. Content below
   2. Sakai quizzes
2. Peer Instructions – See on the class forum
3. Homework (due Sun 11/12) [LINK]
4. Worked Example [LINK]

Content

09.A – Predictive Modeling and Regression

1. Relational Database (24 min.)

09.B – Machine Learning and Classification

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