DB-class notes and resources

This is a collection of notes and resources ment to help fellow students with their studies in Standford's online intro to database class

Structure

dbclass.db - database use for in-class lecutre
homework/ - Collection of resqurces give, or implied for homework. NO SOLUTIONS WILL BE POSTED!
lecture/ - Collection of resources give, or implied for help with lectures
lecture/sql - sql quries used in class. Copied from website.

For an easy way to drop into into a SQL prompt with tables used in class##

First download a copy of this directory:
$ git://github.com/Chingzilla/db-class-resources.git

Then run this script:

$ ./start_database

If you simply want to run the SQLite database

1. Download the dbclass.db file
2. Start sqlite with the database:
   $ sqlite3 dbclass.db

Helpfull resources

Here are some links that might be helpful

SQLite

• Getting started with SQLite
• SQLite datatypes