jackmyers.info

Class Materials

References

Available Databases

  • AdventureWorks - complex business DB from Microsoft (2005)
  • Chinook - a music DB that is the sample for SQLite [schema]
  • Sakila - the movie database that comes with MySQL
  • Northwind - simpler business DB from Microsoft (2010) [schema]
  • Nwind - very basic version of Northwind (circa 2003) [schema]
  • Murach - the databases from the Murach MySQL textbook
    • ap (accounts payable)
    • om (order management)
    • ex (examples)
    • note: ap and om have been merged into a database called "murach"; ex not recreated as it was repetitive with ap and om.
  • SampDB - sample database from O'Reilly
  • enron.email - MongoDB database containing Enron emails
  • sakila.films, sakila.profiles - MongoDB representation of Sakila

MySQL Manual

Neo4j Manual

Oracle Documentation

SQLAlchemy Manual

Connectivity

  • Connections to the MongoDB or the elvis server must be through Rowan's network. For remote users, connect to Citrix (applications.rowan.edu) and then use PuTTy from there for command line access or use MySQL Workbench (under Developer folder).