Information Management Home

Class Materials

• See syllabus in Canvas
• Class Schedule - Graduate Spring 2025
• Elvis SQL console
• Software to download
  • MySQL Community Server (incl. MySQL Workbench)
    Windows users are strongly recommended to run the MSI to the very end.
  • A terminal editor / FTP tool like MobaXterm.
• Slides
• Exercises
• DATABASES
  - a home page for UG and Grad DB courses.
• Files (e.g.,quantum code)
• Solutions

Available Databases

• AdventureWorks
  • AdventureWorks 2005 Schema
    (Use [Ctrl +] and [Ctrl -] to zoom in and out)
  • AdventureWorks Data Dictionary for field definition & usage
• Chinook - a music DB [schema]
• Sakila - a movie database for MySQL
• Northwind - simpler business DB from Microsoft (2010) [schema]
• Nwind - very basic version of Northwind (circa 2003) [schema]
• Murach - from Murach 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

Manuals

MySQL Practice

• SQL Zoo
• SQL Zoo (AdventureWorks)
• Hacker Rank
• SQL Bolt
• W3 resource
• W3 Resource (AdventureWorks)
• AdventureWorks Basic SQL
• AdventureWorks SQL Joins
• AdventureWorks SQL Aggregation
• AdventureWorks Subqueries