The creation of a clean database was only the first step in the objectives list.
concrete evidence that you know how to use the database you created.
exporting data to Pandas for visualization
creating 2dimensional plots that demonstrate that you have a working knowledge of the two linked databases.
Glue like stuff.
PostgreSQL by Douglas and Douglas
Practical PostgreSQL by Drake and Worsley
Downloaded and installed using graphical installer found at:
Told postgres to listen on port 5432
Used StackBuilder to install psqlODBC v09.02.0100-1
postgres commands live at /opt/local/lib/postgresql93/bin
Created a database cluster at /usr/local/pgsql/data
Start database server using: /opt/local/lib/postgresql93/bin/postgres -D /usr/local/pgsql/data
Created a user, “mattmoellman”, and a test database, “mydb”