MySQL Weekend Crash Course

Jay Greenspan is a writer and most recently a producer of Wired Digital's Webmonkey. He has written on PHP, ASP, and XML, and has spoken at various conferences. A Forrester's Research report listed him as a "thought leader" in the XML community. Prior to joining Webmonkey, Jay was a technical consultant, developing LANs and database-driven applications for small businesses.

PART 1: FRIDAY EVENING. Evening PO; 1. Why MySQL?; 2. MySQL Installation and Post-Installation Review; 3. Creating Databases: Governing Principles; 4. Creating Databases in MySQL; Friday Evening Part Review; PART 2: SATURDAY MORNING. PO; 5. Viewing and Altering Databases and Tables; 6. Inserting, Updating, and Deleting MySQL Data; 7. Getting Data from MySQL, Part I: The Basic SELECT; 8. Getting Data from MySQL, Part II: Using SELECT with Multiple Tables; 9. Basic Functions in MySQL; 10. Date Functions in MySQL; Saturday Morning Part Review; PART 3: SATURDAY AFTERNOON; 11. Other MySQL Functions; 12. Beyond LIKE: Using Regular Expressions and FULLTEXT Indexes; 13. Transactions with MyISAM and BDB Tables; 14. Using InnoDB and Gemini Tables; 15. Working with MySQL and PHP; 16. MySQL and PHP: Best Practices; Saturday Afternoon Part Review; PART 4: SATURDAY EVENING; 17. Using MySQL with Perl; 18. MySQL and Perl: Best Practices; 19. Optimizing MySQL Queries; 20. Securing MySQL, Part I: The GRANT Tables; Saturday Evening Part Review; PART 5: SUNDAY MORNING; 21. Securing MySQL, Part II: Your Unix Environment; 22. Advanced Configuration Options; 23. MySQL Client Applications; 24. Backing Up and Exporting MySQL Data; 25. Transferring and Importing Data into MySQL; 26. Replication; Sunday Morning Part Review; PART 6: SUNDAY AFTERNOON; 27. Diagnosing and Repairing Table Problems; 28. MySQL GUI Clients; 29. Optimizing MySQL; 30. Answering Remaining Questions; Sunday Afternoon Part Review; Appendix A: Answers to Part Reviews; Appendix B: What's on the CD-ROM