LAMPsig MySQL Class

LAMPsig Meetings

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

LAMPsig MySQL Class

This 8 week class was held during May and June, 2005 as part of the LAMPsig free �Of Course� offerings.

The syllabus followed the first 9 chapters of the MySQL Certification Study Guide (ISBN 0672326329) quite closely.

Syllabi, instructor notes, and MySQL Manual references are posted below.

The Class schedule

Date	Instructor	Topic
April 25, 2005	David Benjamin	Optional informal introductory lab covering MySQL / Knoppix LiveCD / General Database concepts
May 2, 2005	David Benjamin	Class intro / MySQL and MySQL AB / MySQL software and components (Chap 1 & 2 / MySQL-M 1, 2, 3.3, 3.4, 5, 8, 21, 22)
May 9, 2005	Steve Glasser	Using the MySQL client (Chap 3 / MySQL-M 3.1, 4, 25)
May 16, 2005	David Rolston	Data Definition Language (Chap 4 / MySQL-M 1.2.4, 1.5.6.1, 3.3.2, 3.6.9, 11, 13.2, 13.5.4, 14, 15)
May 23, 2005	David Benjamin	Select Statements / Expressions and Functions (Chap 5 & 6 / MySQL-M 9.2, 12, 13.1.7, 13.1.8, A.5.4)
(no class Memorial day)
June 6, 2005	David Benjamin	Insert and Replace Statements (Chap 7 / MySQL-M 13.1.1, 13.1.4, 13.1.6, 13.1.9, 13.1.10 Additional references on optimization (not covered in class): 7.2.16, 7.2.17)
June 13, 2005	Solomon Chang	Relational DB structure and theory and Joins (Chap 8 / MySQL-M 13.1.7.1, 12.1.10, 12.1.1 Additional references on optimization (not covered in class): 7.2.9)
June 20, 2005	Solomon Chang	Relational DB structure and theory and Joins cont. (Chap 8)
June 27, 2005	Christopher Thompson	Importing and Exporting Data (Chap 9 / MySQL-M 1.7.5.2, 2.3.16, 8.8, 8.10, 13.1.5, 13.6.2.3)

Optional Lab :: Agenda
Optional Lab :: Instructor Notes

Class #1 :: Syllabus
Class #1 :: Instructor Notes

Class #2 :: Syllabus
Class #2 :: Instructor Notes

Class #3 :: Syllabus
Class #3 :: John M's Student Notes

Class #4 :: Syllabus
Class #4 :: Instructor Notes

Class #5 :: Syllabus
Class #5 :: Instructor Notes

Class #6 & #7 :: Syllabus (Draft)
Class #6 & #7 :: Instructor Notes

Class #6 & #7 :: Example data in spreadsheet (.doc) format, Example data in spreadsheet (.sxc) format.

SQL txt file of 2NF - improved with data

Database Design Modeling diagram examples

Class #8 :: Syllabus

Chris Thompson

2006-03-19

View as PDF: This month | Full blog