Mastering MySQL 4 / Edition 1
by Ian GilfillanMySQL Can Do More, and Now You Need to Know More
MySQL has proved it can compete with the big names in database management, such as SQL Server and Oracle, and with MySQL 4 this is truer than ever. Mastering MySQL 4 is your one-stop resource for all the information you need to create, maintain, use, and extend a MySQL
… See more details belowOverview
MySQL Can Do More, and Now You Need to Know More
MySQL has proved it can compete with the big names in database management, such as SQL Server and Oracle, and with MySQL 4 this is truer than ever. Mastering MySQL 4 is your one-stop resource for all the information you need to create, maintain, use, and extend a MySQL database. It’s also essential reading for anyone developing database applications in a MySQL environment. If you’re new to MySQL, this is a great way to get up and running--fast. If you’re upgrading, it will help you get all you can out of new features and support. Coverage includes:
- Installing MySQL
- Adding, removing, and updating records
- Choosing appropriate table types
- Choosing appropriate data types
- Optimizing MySQL queries
- Designing a database
- Normalizing table structure
- Maintaining and repairing databases
- Backing up and replicating data
- Managing user permissions and security
- Optimizing the MySQL server
- Extending MySQL
- Developing database applications
Product Details
- ISBN-13:
- 9780782141627
- Publisher:
- Wiley
- Publication date:
- 01/21/2003
- Pages:
- 772
- Product dimensions:
- 7.50(w) x 9.25(h) x 1.49(d)
Table of Contents
Introduction.
Part I: Using MySQL.
Chapter 1: Quickstart to MySQL.
Chapter 2: Data Types and Table Types.
Chapter 3: Advanced SQL.
Chapter 4: Indexes and Query Optimization.
Chapter 5: Programming with MySQL.
Chapter 6: Extending MySQL.
Part II: Designing a Database.
Chapter 7: Understanding Relational Databases.
Chapter 8: Database Normalization.
Chapter 9: Database Design.
Part III: MySQL Administration.
Chapter 10: Basic Administration.
Chapter 11: Database Backups.
Chapter 12: Database Replication.
Chapter 13: Configuring and Optimizing MySQL.
Chapter 14: Database Security.
Chapter 15: Installing MySQL.
Chapter 16: Multiple Drives.
Appendixes.
Appendix A: MySQL Syntax Reference.
Appendix B: MySQL Function and Operator Reference.
Appendix C: PHP API.
Appendix D: Perl DBI.
Appendix E: Python Database API.
Appendix F: Java API.
Appendix G: C API.
Appendix H: ODBC and .NET.
Index.
Customer Reviews
Average Review: