Pro MySQL is the first book that exclusively covers intermediate and advanced features of MySQL, the world's most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or you're a database expert searching for a fast-paced introduction to MySQL's advanced features, this book is for you.

The first part of this book discusses topics related to design and development. Topics include transaction processing and indexing theory, benchmarking and profiling, and advanced coverage of storage engines and data types. The authors also delve deep into the MySQL source code and system architecture at a level you won't find anywhere else. Essential advanced SQL is also covered, with discussion of subqueries, derived tables, and joins. These concepts are demonstrated in a range of situation-specific examples&emdash;from dealing with hierarchical data to performing Geographic Information System (GIS) examples with just MySQL. This section also covers MySQL 5's new enterprise features like stored procedures, triggers, and views.

The latter part of this book devotes itself to administration topics. Topics include MySQL installation and upgrading, user administration, database backups, replication, and clustering. You'll also learn about the new data dictionary features available in MySQL 5.

If you are a MySQL user who wants to find out more about the program, but is not interested in becoming a database administrator just to be able to read books on MySQL, then MySQL Crash Course is for you. This tutorial-based book is organized into a series of short, easy-to-follow lessons that take a very hands-on approach to meeting the needs of the average MySQL user. The essentials of MySQL are taught through a series of self-paced lessons in which you will complete exercises that illustrate the most important aspects of MySQL. You will learn how to:

- Use the MySQL toolset.
- Use the aggregate functions to analyze data.
- Perform insert, update and delete operations.
- Combine queries using unions.
- Create and modify tables and access table schemas.
- Manage databases, users and security privileges.

Pro ADO.NET 2.0 is a guide and reference for.NET developers who are looking to further their understanding of ADO.NET 2.0.

This book takes a new approach, focusing on the practical tasks like connecting to the database, retrieving data, and working with transactions, rather than rehashing much of the MSDN documentation. Pro ADO.NET 2.0 offers the deep and much needed practical understanding, viewpoint, and knowledge developers are looking for.

This book explains what is available in ADO.NET by associating it with the need to solve a practical problem and better architect an application, rather than mugging up the hundreds of classes and properties available in the framework.

SQL Server 2005 is the next generation of SQL Server database and represents a massive leap forward in terms of programming options, productivity, database management, and analysis. This book takes a deep look at the full range of SQL Server enhancements, and includes meaningful and relevant examples showing how these new features work and how you can architect applications effectively.

You'll be able to work on your own SQL Server 2005 solutions quickly and painlessly. The book's core topics include enhancements to database programmability features and languages, such as ADO.NET, XML, .NET assemblies, and T-SQL. Other topics include services and tools like Reporting Services, the Service Broker, and DTS, and enhancements to the BI capabilities such as Analysis and Notification services.