* Shows Java developers everything they need to know to build Java database applications with MySQL.
* Takes a hands-on, code-intensive approach in which readers will learn how to build a sophisticated Web database management application.
* Begins with a review of the fundamentals of MySQL.
* Explains using Java's JDBC with MySQL, as well as servlet and JSP programming with MySQL.
* Provides a code-rich tutorial on how to build the sample Java database application using EJBs.
* The companion Web site provides the full code examples plus links to useful sites.

Product Description
Perfectly intelligent programmers often struggle when forced to work with SQL. Why?Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity.

This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you'll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you'll be coding more quickly, writing more efficient code, and applying the full power of SQL

. Filled with the insights of one of the world's leading SQL authorities - noted for his knowledge and his ability to teach what he knows.

. Focuses on auxiliary tables(for computing functions and other values by joins), temporal tables(for temporal queries, historical data, and audit information), and virtual tables(for improved performance).

. Presents clear guidance for selecting and correctly applying the right table technique.

With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.