Ships from: BAY SHORE, NY
Usually ships in 1-2 business days
Ships from: Murphy, TX
Usually ships in 1-2 business days
Ships from: fallbrook, CA
Usually ships in 1-2 business days
Anonymous
Posted Sun Feb 16 00:00:00 EST 2003
While I am not new to databases, I am new to mysql and always spend the most time learning new syntax, processes and ¿features¿. The MySQL manual is very clear but left some questions unanswered for me. Mastering MySQL left me with no such gaps, and the numerous in-depth examples (including output) in this book help clarify commands and proper syntax. The book covers everything from installation to administration and includes syntax and function/operator references. These references are clearly detailed and contain a generous number of examples as well. The book is written from a hands-on point of view which is how I learn best. One very nice aspect of the book is that it provides information for Windows and UNIX environments as opposed to focusing on one or the other. There are very handy sections on several of the programming APIs, including PHP, Perl, Python, Java, C, ODBC and .NET. Database beginners will find the sections on Understanding Relational Databases, Database Normalization and Database Design very helpful in understanding database terminology and functionality. Finally, there is a very detailed index in the back of the book ¿ I really dislike not being able to locate a topic in an index, especially when I know I read it somewhere in the book. This is a very good overall book for the MySQL database and I¿d recommend it to anyone looking to learn about MySQL.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
More About This Textbook
Overview
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
Editorial Reviews
From Barnes & Noble
The Barnes & Noble ReviewMySQL 4.0 is finally here -- with enough power and performance for virtually any mainstream application, and a licensing model that will make Oracle and Microsoft users drool. In Mastering MySQL, Ian Gilfillan shows you how to use, manage, and optimize MySQL in just about any environment.
Gillfallan offers beginners “quickstarts” for both database developers and administrators, then moves rapidly into more advanced concepts and techniques. For example, there’s extensive coverage of optimization, from indexes to the performance-related intricacies of mysqld variables.
You’ll find detailed coverage of both traditional applications and transactional applications utilizing MySQL 4’s new transactional storage engine. (While many of Gillfalan’s code examples utilize PHP, he also provides reference information for developers using Perl DBI, the Python Database API, Java and C APIs, ODBC, even .NET database access.) The book also contains a full section on database design -- including a practical, chapter-length introduction to normalization.
Gillfalan’s systematic coverage of MySQL database administration encompasses MySQL utilities; startup/shutdown; logging; table checking and repair; backup, replication, database security, and more. Whatever your MySQL application, Mastering MySQL will help you build it better, run it faster, and manage it more effectively. Bill Camarda
Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks For Dummies®, Second Edition.
Product Details
Related Subjects
Meet the Author
Read an Excerpt
Click to read or download
Table of Contents
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.