jackmyers.info
Class Materials
- See syllabus in Canvas
- Class Schedule - Spring 2021
- 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
- Variations in SQL (MySQL vs SQLite vs Postgres)
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
- AdventureWorks 2005 Schema
- Chinook - a music DB that is the sample for SQLite [schema]
- Sakila - the movie database that comes with MySQL
- NOAA - water data from the National Oceanic and Atmospheric Administration's (NOAA) Center in Influx [description]
- Northwind - simpler business DB from Microsoft (2010) [schema]
- Northwind on Neo4j - suppliers, products and categories [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 and alternative enron.email2- JSON dataset for Mongo/Elasticsearch with Enron emails. Background and information about the dataset. Its use in data science.
- sakila.films, sakila.profiles - MongoDB representation of Sakila
MySQL Manual
- String data types
- Numeric data types
- Date/Time data types
- Spatial data types (tie in to GIS)