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

The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Database Design and Tuning is
the only guide with coverage of both the basics and advanced topics,
including reliability, performance, optimization and tuning for MySQL.
This clear, concise and unique source for the most reliable MySQL
performance information will show you how to:

• Deploy the right MySQL product for your performance needs.
• Set up a performance management and monitoring environment using tools from MySQL.
• Implement the right indexing strategy
• Apply good performance strategy when developing software to work with the MySQL database.
• Configure dozens of variable to correctly tune the MySQL engine.

If
you deal with the intricacies and challenges of advanced MySQL
functionality on a daily basis, you will be able to build on your
knowledge with author Robert Schneider’s real-world experiences in MySQL Database Design and Tuning.

Joe Celko’s Trees and Hierarchies in SQL is an intermediate to
advanced-level practitioners guide to mastering the two most
challenging aspects of developing database applications in SQL. In this
book, Celko illustrates several major approaches to representing trees
and hierarchies and related topics that should be of interest to the
working database programmer. These topics include hierarchical encoding
schemes, graphs, IMS, binary trees, and more. This book covers SQL-92
and SQL:1999.

� Includes graph theory and programming techniques.
� Running examples throughout the book help illustrate and tie concepts together.
� Loads of code, available for download from www.mkp.com.

Do you need an introductory book on data and databases? If the book is by Joe Celko, the answer is yes. Data and Databases: Concepts in Practice
is the first introduction to relational database technology written
especially for practicing IT professionals. If you work mostly outside
the database world, this book will ground you in the concepts and
overall framework you must master if your data-intensive projects are
to be successful. If you’re already an experienced database programmer,
administrator, analyst, or user, it will let you take a step back from
your work and examine the founding principles on which you rely every
day-helping you to work smarter, faster, and problem-free.

Whatever
your field or level of expertise, Data and Databases offers you the
depth and breadth of vision for which Celko is famous. No one knows the
topic as well as he, and no one conveys this knowledge as clearly, as
effectively-or as engagingly. Filled with absorbing war stories and
no-holds-barred commentary, this is a book you’ll pick up again and
again, both for the information it holds and for the distinctive style
that marks it as genuine Celko.

* Supports its extensive conceptual information with example code and other practical illustrations.
*
Explains fundamental issues such as the nature of data and data
modeling, and moves to more specific technical questions such as
scales, measurements, and encoding.
* Offers fresh, engaging
approaches to basic and not-so-basic issues of database programming,
including data entities, relationships and values, data structures, set
operations, numeric data, character string data, logical data and
operations, and missing data among others.
* Covers the conceptual foundations of modern RDBMS technology, making it an ideal choice for students.

Improve functionality and develop robust SQL Server applications with
confidence using this collection of pre-written solutions. Best-selling
programming author Greg Buczek brings you the most authoritative and
useful collection of expert techniques and ready-to-use applications
available.