Sams Teach Yourself MySQL in 24 Hours

Sams Teach Yourself MySQL in 24 Hours teaches the reader everything from basic installation to using MySQL in Web application development.

First, the basic concepts of database design are taught, and then the reader jumps right into planning and creating a database.The book then walks the reader through all the basics of using MySQL - working with tables and data, using MySQLs query functions, using transactions, and database administration - before the reader finally learns to put everything together to properly create the foundation database for a Web-based application.

Table of Contents

Introduction.

I. INTRODUCTION TO MYSQL AND RELATIONAL DATABASES.

Hour 1. Introducing MySQL.
Hour 2. Understanding Database Terminology.
Hour 3. Learning the Database Design Process.

II. SETTING UP YOUR ENVIRONMENT.

Hour 4. Using the MySQL Client.
Hour 5. Securing MySQL.

III. LEARNING TO PLAN FOR YOUR DATABASE-DRIVEN APPLICATIONS.

Hour 6. Planning and Creating Your Database.
Hour 7. Creating Your Database Tables-Part I.
Hour 8. Creating Your Database Tables-Part II.

IV. WORKING WITH YOUR TABLES.

Hour 9. Populating Your Database Tables.
Hour 10. Selecting Data from Your Tables.
Hour 11. Advanced Usage of SELECT Statements.
Hour 12. Modifying and Deleting Data.
Hour 13. More About DELETE.
Hour 14. Modifying Table Structure.

V. USING BUILT-IN FUNCTIONS IN MYSQL QUERIES.

Hour 15. Using MySQL String Functions.
Hour 16. Using MySQL Numeric Functions.
Hour 17. Using MySQL Date and Time Functions.

VI. USING TRANSACTIONS.

Hour 18. Transactions Overview.
Hour 19. Practical Transaction Usage.

VII. ADMINISTERING YOUR MYSQL SERVER.

Hour 20. Optimizing and Tuning Your Database.
Hour 21. Backing Up and Restoring Your Database.
Hour 22. Basic Administrative Commands.

VIII. INTERFACING WITH MYSQL.

Hour 23. Using MySQL with Perl.
Hour 24. Using MySQL with PHP.

IX. APPENDICES.

Appendix A. Installing MySQL.
Appendix B. Using MyODBC.
Appendix C. Reserved Words.
Appendix D. Practical MySQL/PHP Examples.
Index.