This book is designed for anyone who needs to use SQL (Structured Query Language) with any database management system that supports the language. The book is equally useful to readers who have had little-to-no exposure to SQL and those with some experience. It's packed with a great many tips, tricks, and "that's how it works" information The book explains SQL syntax and what each syntax is asking an SQL command processor to do so that the impact of any given query upon system performance is completely understood. The relationship between the distribution of data in a database and the way in which queries of various types are processed is also covered at length.
- Covers structure of SQL queries
- Teaches readers how to produce a desired result and minimize burden on SQL command processors
- Shows readers how to modify data and database structure for ease of use and increased efficiency