[SGVLUG] Fwd: [Lamp-user] NEW ATTENDEES WELCOME!! This Monday: Workshop on MySQL, phpMyAdmin

[matti]

--- "David P. Benjamin" <davidlamp at peterbenjamin.com> wrote:

> Date: Sun, 17 Jul 2005 01:01:29 -0700
> From: "David P. Benjamin" <davidlamp at peterbenjamin.com>
> To: Lamp-user at maillist.lampsig.org
> Subject: [Lamp-user] NEW ATTENDEES WELCOME!! This Monday: Workshop on
> MySQL,	phpMyAdmi
> 
> 
> NEW ATTENDEES WELCOME!!
> 
> MySQL Class Sequel 2:
> Backend for Graffiti!, a website
> and intermediate multi-table queries
> 
> 
> Monday, July 18, 2005 at 7:00pm
> Location: Caltek.net on Hoover in L.A.
> Cost: Free
> Seating: limited, first-come first served
> 
> 
> Instructor: David Benjamin
> david at peterbenjamin dot com
> 
> 
> The evening's goal is to gain skills with
> MySQL, SQL, and phpMyAdmin.  This evening
> we will be
> 
>    -- designing database tables for Graffiti (guestbook
>       with a twist);
> 
>    -- creating and populating tables with phpMyAdmin;
> 
>    -- working a many-to-many relationship example;
> 
>    -- working intermediate multi-table updates;
> 
>    -- backing up a database.
> 
> 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.
> 
> Class notes will be available at
> 
>    HTTP://peterbenjamin.com/~david/workshop2/index.html
> 
> 
> 6:45 - 7:45 o 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).
> 
>              o Create "Graffiti" database and tables using
> 	      phpMyAdmin
> 
> 7:45 - 8:00 o 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 o We will work several exercises of multi-table
> 	      SELECTs and UPDATES in the World database --
> 	      more hypothetical geopolitical upsets.
> 
> 8:30 - 8:50 o 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.
> 
> 	    o 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.
> 
> The agenda for this week (and last) came from specific input
> from attendees.   This workshop can only continue with your
> input and participation.
> 
> 
> 
> _______________________________________________
> Lamp-user mailing list
> Lamp-user at maillist.lampsig.org
>
http://maillist.lampsig.org/mailman/listinfo/lamp-user_maillist.lampsig.org
> 



		
____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs