Promotional Information

A lucid guide to SQL which provides the tools to put practical instruction to work immediately!

Table of Contents

1. The relational data model2. Manipulating relations with relational algebra3. Introduction to SQL4. Simple SQL retrieval5. Retrieving data from more than one table6. Advanced retrieval operations7. Calculations and grouping queries8. Data Modifications9. Schemas and tables10. Views, temporary tables, CTEs and indexes11. Keeping the design up to date12. Users and access rights13. Users, sessions, and transaction manipulation14. Triggers and stored procedures15. Embedded SQL16. Dynamic SQL17. XML support18. The object-relational data model19. Object-relational support

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.

Reviews

"This book functions as a very good tutorial, taking you from the basics through expert topics in a very straightforward manner." --Bill Arledge, Consulting DB2 Product Manager

"SQL Clearly Explained is one of those rare books that delivers 100 percent what its title promises. If you need to use SQL on the job, and who doesn't, then this book should be on your desk." --Craig S. Mullins, DB2 Consultant and IBM Information Champion, Mullins Consulting, Inc.

"This book is of great value to SQL practitioners. It also makes an excellent college-level text." --Rudy Limeback, SQL Consultant, r937.com