All Together Now, a Workshop on MySQL and phpMyAdmin

LAMPsig Meetings

3rd Saturday of the Month 1-3pm
Tom Bradley Youth and Family Center
5213 West Pico Blvd.
Los Angeles, CA 90019

Monday, July 11. 2005

All Together Now, a Workshop on MySQL and phpMyAdmin

New! A hands-on workshop focused on MySQL and phpMyAdmin is scheduled for Monday evenings at CalTek starting this Monday, July 11 at 7:00pm.

*Date/Time:* Monday, July 11 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)

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.

The evening's goal is to do a few SELECTs and a few INSERTs and UPDATEs. To make this a little more interesting, we'll use phpMyAdmin, a web-based visual tool that saves a lot of typing and syntax lookups.

*workshop schedule and additional information in further reading section.*

Instructor Notes Workshop 1

*Workshop Schedule*

_7:00 - 7:30_
start up and log in with phpMyAdmin (already on the LAMPSIG boot disk: enter localhost/phpmyadmin" in the address of the browser) and browse database tables using phpMyAdmin

_7:30 - 8:00_
Common SELECT usage -- start simple and using the editor in phpMyAdmin, grow the SELECT to use WHERE, ORDER BY, and LIMIT. Then, learn how to do filtered searches in phpMyAdmin and view the SQL used.

_8:00 - 8:30_
Common INSERT and UPDATE usage -- add/modify database rows in phpMyAdmin and view the SQL used. Cut-and-paste that SQL into the SQL editor to make customizations.

_8:30 - 8:50_
Simplest multi-table SELECT usage -- a short review and refresher and then a couple simple hands-on exercises.

Follow-on workshops will be paced by attendee's progress. Expect topics like (time and interest permitting):

SELECT with SUM/MAX/MIN/COUNT and GROUP BY
how to generate HTML table rows with SELECT
creating databases and setting user permission with phpMyAdmin
creating and altering tables with phpMyAdmin
saving database creation/restore scripts/backups
design of tables for guestbook or reservations

Posted by Sharon Lake in Classes: MySQL at 19:00 | Comments (0) | Trackbacks (0)
View as PDF: This entry | This month | Full blog

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

No comments

Add Comment

Name
Email
Homepage
In reply to
Comment	E-Mail addresses will not be displayed and will only be used for E-Mail notifications To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Enter the string from the spam-prevention image above: BBCode format allowed
	Remember Information? Subscribe to this entry