Week 02

Basic SQL

What is SQL?

Link to Slides


Link to Slides

SQLite Demo

We will be using SQLite as our model SQL-style database. Although we will be primarily interacting with it through Python 3's sqilte3 built-in module. You can install it on your local computer to experiment with (Download Link Here). The documentation for SQLite is quite excellent, so please check it out if you are running into syntax trouble.

SQL Datatypes

Link to Slides