Home > db-class-resources

db-class-resources

Db-class-resources is a project mainly written in Shell, based on the View license.

Collection of resources for people taking Stanford's online database class

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

Download the dbclass.db file
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


            
                
                    
                        Previous：rhaptos.sword.buildout
Next：android_build_target