SQL Performance Tuning is a handbook of practical
solutions for busy database professionals charged with managing an
organization’s critically important data. Covering today’s most popular
and widely installed database environments, this book is an
indispensable resource for managing and tuning SQL across multiple
platforms.

Packed with tips, techniques, and best practices, this
hands-on guide covers SQL commands and queries over a wide range of
conditions and environments. Every facet of the SQL environment is
covered, from concurrency control to optimization�and every issue in
between. The book includes an overview of each of the most widely used
database management systems (DBMS) and provides tuning tips for common
day-to-day situations.

Topics covered include:

Whether
you are a programmer, consultant, or user, you will find SQL
Performance Tuning an indispensable guide to optimizing SQL performance
across today’s popular database environments.

(more…)

The authoritative study guide to prepare for the MySQL Core Certification and MySQL Professional Certification exams.

When
you purchase a copy of the MySQL Certification Study Guide, you
automatically receive 25% off the cost of registration for the MySQL
Core Certification exam. Details on the back cover of the book.

The
MySQL certification program is a carefully developed, high-quality
certification process that can help you prove your skills in using,
maintaining, and administering MySQL database servers and other
technologies from MySQL AB.

Covering both the basic MySQL Core Certification exam and the advanced MySQL Professional Certification exam, MySQL Certification Study Guide
is the one authority to look to when you�re preparing for either test.
The book teaches you all the concepts, principles, and techniques that
you�ll need to know for the Core and Professional certification exams,
and it includes an array of learning aids, practice questions, and
real-world examples to help you prepare for test day.

Certified
computer professionals often find that having proven, recognized
credentials can advance them farther in their fields, give their
careers a boost, and make them better, more productive employees for
their companies or organizations. Whatever reason for becoming MySQL
certified, MySQL Certification Study Guide gives you the information you need to help you better understand MySQL technologies and prepare for and pass the exams.

(more…)

Microsoft SQL Server 2000 Unleashed, 2E offers a variety of
topics for system and database administrators to help them learn new
features of the product and to solve problems they face on a daily
basis. It shows them how to build upon their working knowledge of the
product and take their experience and knowledge to a higher level. This
new edition of Microsoft SQL Server 2000 Unleashed covers the
latest updates and service packs to SQL Server 2000, including full
support for XML, notification services, and SQL Server CE.

(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

(more…)

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.

(more…)

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.

(more…)

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.

(more…)

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.

(more…)

Focused on the latest research on text and document management, this
guide addresses the information management needs of organizations by
providing the most recent findings. How the need for effective
databases to house information is impacting organizations worldwide and
how some organizations that possess a vast amount of data are not able
to use the data in an economic and efficient manner is demonstrated. A
taxonomy for object-oriented databases, metrics for controlling
database complexity, and a guide to accommodating hierarchies in
relational databases are provided. Also covered is how to apply
Java-triggers for X-Link management and how to build signatures.

(more…)

MySQL is a popular and robust open source database product that
supports key subsets of SQL on both Linux and Unix systems. MySQL is
free for nonprofit use and costs a small amount for commercial use.
Unlike commercial databases, MySQL is affordable and easy to use. This
book includes introductions to SQL and to relational database theory.
If you plan to use MySQL to build web sites or other Linux or Unix
applications, this book teaches you to do that, and it will remain
useful as a reference once you understand the basics. Ample tutorial
material and examples are included throughout. This book has all you
need to take full advantage of this powerful database management
system. It takes you through the whole process from installation and
configuration to programming interfaces and database administration.
This second edition has a greatly enhanced administration chapter that
includes information on administrative tools, server configuration,
server startup and shutdown, log file management, database backup and
restore, and database administration and repair. In addition, a new
chapter on security describes data, server, and client-server security,
while a chapter on extending MySQL provides an overview of MySQL
internals and describes the use of MySQL user-defined functions. If you
know C/C++, Java, Perl, PHP, or Python, you can write programs to
interact with your MySQL database. In addition, you can embed queries
and updates directly in an HTML file so that a web page becomes its own
interface to the database. Managing and Using MySQL includes chapters
on the programming language interfaces, and it also includes a complete
reference section with specific function calls for each language. Also
included in the reference section are references to the SQL language,
and details of the MySQL system variables, programs, and utilities. New
to the second edition is a reference to the internal MySQL tables,
which will be of particular interest to those who want to work
extensively with MySQL security.

(more…)