Software installation

MySQL

In this class we will use MySQL Community Edition as our Database Management System (DBMS) (note: you do not have to create an Oracle account, click the link that says, "No thanks, just start my download"). Follow the instructions on the linked page to install a local copy of MySQL on your computer. We will also access an installation on the sunapee server.

MySQL Workbench

Most of the time you will interact with the MySQL DBMS through MySQL Workbench. You should install this on your local machine (note: you do not have to create an Oracle account, click the link that says, "No thanks, just start my download"). Follow instructions on the linked page to install a local copy of MySQL Workbench.

Connect to database

Once you've installed MySQL and MySQL Workbench, connect to your database server (either sunapee or your localhost) from the MySQL Workbench home screen by first clicking on the plus next to "MySQL Connections" and entering the required connection information (for sunapee see Canvas under Pages for login credentials) as shown here.

Node.js

We will use Node.js to create a RESTful web API. Install Node on your local machine.