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: Fall 2017
• Slides
• Exercises
• Files (e.g., schema creation scripts, Access databases)
• Sakila Web (PHP examples)
• Solutions

References

• Readings for class
• How to use an SSH tunnel to connect to elvis MySQL remotely (with sincerest thanks to Justin Gavin)
• Various ER diagram formats
• My database YouTube channel
• AdventureWorks 2005 Schema
  (Use [Ctrl +] to zoom in and [Ctrl -] to zoom out)
• Northwind Schema (key tables)