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

Class Materials

• Class Syllabus
• Class Schedule: Summer 2017
• SQL Files
• Slides
• Exercises
• Files (e.g., schema creation scripts, Access databases)
• Neo4j scripts and more
• Sakila Web (PHP examples)
• Solutions

References

• Readings for class
• Various ER diagram formats
• AdventureWorks 2005 Schema
  (Use [Ctrl +] to zoom in and [Ctrl -] to zoom out)
• Northwind Schema (key tables)