All Together Now, a Workshop on MySQL and phpMyAdmin

The agenda for this week (and last) came from specific input from attendees. This workshop can only continue with your input and participation.

This will be workshop format with the goal of learning by doing. There will be brief introductions followed by "now you do it" exercises. The instructor will give individual help and share answers to the most common questions.


Instructor Notes Workshop 2
SQL file of example Graffiti database for the typing adverse. Note that the plan is to allow time to enter these tables and rows via phpMyAdmin

*Workshop Schedule*

_6:45 - 7:45_
Start up and log in with phpMyAdmin (Available on the LAMPSIG/class boot disk: enter "localhost/phpmyadmin" in the address of the browser; a few CDROMS are available free at the class).

Create "Graffiti" database and tables using phpMyAdmin

_7:45 - 8:00_
Discussion of relational database representation of many-to-many relationships with the Graffiti example. Discussion of foreign keys, referential integrity, and cascading deletes (not available with MyISAM tables). We will write the SQL for a Graffiti web application, such as recording a guest visit to the Graffiti home page.

_8:00 - 8:30_
We will work several exercises of multi-table SELECTs and UPDATES in the World database -- more hypothetical geopolitical upsets.

_8:30 - 8:50_
Export from MySQL using phpMyAdmin for backup and for moving a development database to production. Export your Graffiti database to email yourself. Import (restore) using phpMyAdmin.

Discussion of the steps required to make a website using the Graffiti database and PHP.As time permits, we will start building a simple home page for Graffiti.