SQL Unleashed is broken into four distinct parts to help readers find the information they need: Retrieving Information The largest section focuses on the accurate, reliable, and efficient retrieval of information. Readers will become proficient at creating, testing and improving select (simple, nested, or correlated). Manipulating Information and Database Objects This section deals with manipulating information and database objects. Readers will understand the best ways to manipulate single table data while controlling transactions. They will also learn the most efficient way to create tables and relationships, and to customize the appearance of tables through views. Optimizing Issues This section identifies the key optimization and performance issues that are vital to SQL programming. The reader will learn ways to improve performance, to optimize statements, and to avoid unnecessary database accesses. Advanced Issues A catch-all section for many difficult to classify topics, this section will key on some specific issues that have not been addressed in other books. Ensuring the accuracy of complex queries, modularized reporting, data warehousing, integrating and scrubbing data, and security issues will all be described in detail.SQL Unleashed will serve as the one comprehensive resource for SQL programming.The market lacks a large, encompassing SQL book. This book fills that void!SQL is the standard command set used to communicate with the most important relational database systems on the market today (Oracle, Informix, Sybase, DB2, MS SQL-Server and Access) and a working knowledge of SQL is needed by all database programmers and administrators.