SQL Unleashed is a comprehensive reference that helps you find the information you need. Learn the most accurate, reliable, and efficient ways to retrieve information. Become proficient at creating, testing and improving select (simple, nested, or correlated). Learn to manipulate information, database objects, and single table data while controlling transactions. Identify the key optimization and performance issues that are vital to SQL programming. Learn ways to improve performance, optimize statements, and avoid unnecessary database accesses. A catch-all section explains many difficult to classify topics, keying on some specific issues that have not been addressed in other books.
- Understand the underlying concepts of SQL
- Test, scrub and control data in a SQL environment
- Solve the problem of denormalized data
- CD-ROM includes over 600 listings of the author's source code and examples, evaluation versions of several third-party applications, and two books fast-linked in electronic format
SQL Unleashed, Second Edition, covers ANSII SQL and how to implement them with several major relational database platforms used on a day-to-day basis. SQL Unleashed focuses on more intermediate to advanced topics and the latest trends forthcoming in SQL. Designed to be used as both a reference and implementation tool, this book serves as a practical, pragmatic guide to day-to-day SQL programming and provide the most efficient solutions for getting the job done. Topics include database design and data definition, data manipulation, data selection, more advanced, QL implementations, the future of SQL, and vendor SQL extensions.