Table of contents for MySQL weekend crash course / Jay Greenspan.


Bibliographic record and links to related information available from the Library of Congress catalog


Information from electronic data provided by the publisher. May be incomplete or contain other coding.


Counter
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.