SQL unleashed

Aimed at intermediate to advanced SQL programmers, database administrators, and IT professionals, this book should serve as a useful guide in day-to-day SQL programming, in understanding the underlying concepts of SQL, and in learning the most efficient way to get the job done.Topics include: retrieving information, where readers should become proficient at creating, testing and improving select statements; manipulating information and database objects, dealing with manipulating information and database objects; obtimizing issues, which identifies the key optimization and performance issues that are key to SQL programming, and teaches readers ways to improve performance; and advanced issues, a catch-all section for topics that are difficult to classify, including modularized reporting, data warehousing, integrating and scrubbing data, and security issues.

The CD-ROM includes all SQL code from the book as well as third part programs that help create and analyze SQL statements.