Class Materials

• Undergrad Class Syllabus
• Class Schedule: Summer 2020
• Software to download
• Slides
• Exercises
• Videos
• Online quiz system (featuring SQL tests)
• Files (e.g., schema creation scripts, Access databases)
• Handouts
• Rubrics
• Sakila Web or AdventureWorks web (PHP examples)
• Sakila AJAX
• Solutions

References

• Readings for class
• Various ER diagram formats
• My database YouTube channel

Available Databases

• AdventureWorks - complex business DB from Microsoft (2005)
  
  • AdventureWorks 2005 Schema
    (Use [Ctrl +] to zoom in and [Ctrl -] to zoom out)
  • AdventureWorks Data Dictionary for field definition & usage
• 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

• MANUAL HOME
• MySQL WorkBench
• Regular Expressions

• String functions
• Numeric functions
• Date/Time functions
• Control Flow functions

• String data types
• Numeric data types
• Date/Time data types
• Spatial data types (tie in to GIS)

• MySQL as NoSQL

Neo4j Manual

• Full manual (current version)
• Chapter 3 - Cypher

Oracle Documentation

• Oracle Spatial geometry explained
• Procedures and Functions - Oracle vs. MySQL

SQLAlchemy Manual

• Full manual (current version)

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).