MySQL Weekend Crash Course
Published on 15. April 2002
Book
Mixed media product
XXII, 362 pages
978-0-7645-3634-2 (ISBN)
Description
Quickly learn MySQL -- the leading open source relational database management system! With MySQL Weekend Crash Course, you can get up to speed creating MySQL database applications in a single weekend! This book is for Web Developers and Programmers with no prior knowledge of MySQL. This crash course will help you learn how to use MySQL to get database applications to work quickly on the Web.
More details
Person
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.
Content
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