Synopses & Reviews
Written with both beginner and intermediate database developers in mind, this clear, concise guide teaches readers about
the relationships between the distribution of data in a database and the way in which queries of various types are
processed. SQL (structured query language) is a complete data manipulation language for relational databases that allows
users to modify database structure (tables, views, and indexes), as well as modify and retrieve data. The book teaches not
only SQL syntax but also explains the proper structure of SQL queries and how a query affects the SQL processor and
system performance.
Key Features:
Covers proper 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 efficiencySynopsis
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.
KEY FEATURES
- 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
About the Author
Jan L. Harrington, the author of 30 books, including SQL, Clearly Explained (Academic Press), has been writing about databases since 1984. She is a professor and chair of the department of computer science and information systems at Marist College, where she teaches database design and management, object-oriented programming, data communications, and computer architecture.
Table of Contents
Introduction.
Simple SQL Retrieval.
Retrieving Data from More Than One Table: Joins.
Advanced Retrieval Operations.
Calculations and Grouping Queries.
Data Modification.
Managing Database Structures: Part I.
Managing Database Structures: Part II.
Users, Sessions, and Transaction Control.
Embedded SQL.
Dynamic SQL.
Appendices.
Glossary.
Index.