MySQL Introduction

This page is reference material and links to be used during the our classes on MySQL, but may be useful afterwards as well.

Cloud 9

Getting Started with Cloud 9

Downloads

• https://cs.wellesley.edu/~cs304/downloads/wmdb.sql
• https://cs.wellesley.edu/~cs304/downloads/part1.tar
• https://cs.wellesley.edu/~cs304/downloads/part2.tar
• https://cs.wellesley.edu/~cs304/downloads/part3.tar
• https://cs.wellesley.edu/~cs304/downloads/part4.tar
• https://cs.wellesley.edu/~cs304/downloads/part5.tar

WMDB

• The wmdb.sql file with the WMDB (Wellesley Movie Database) contents.

MySQL Reference

• The MySQL website's tutorial.
• The SELECT statement
• date and time functions
• Primary Key Optimization
• CREATE TABLE statement
• Date and Time types
• Integer types
• Using AUTO_INCREMENT
• GROUP BY functions, AKA aggregate functions

Learning More

I suggest you start with the W3Schools SQL Tutorial

1. This work is licensed under a Creative Commons License
2. 
3. 
4. 
5.