SQL Clearly Explained

Demonstrates how to formulate SQL queries and how queries are processed to maximize performance of the database management system. This title explains use of SQL to enter, modify or delete data to maintain database structural elements. It covers SQL application for XML to meet the XML usage in development of online content.

Autorentext
Jan L. Harrington, author of more than 35 books on a variety of technical subjects, has been writing about databases since 1984. She retired in 2013 from her position as professor and chair of the Department of Computing Technology at Marist College, where she taught database design and management, data communications, computer architecture, and the impact of technology on society for 25 years.

Klappentext

There are tens of thousands of database professionals who could benefit from this book, and their number is growing rapidly worldwide. The market opportunity for this book lies in the explosive growth expected in the use of SQL (including XML and object-relational extensions) and the variety of uses being made by those using SQL. The most recent release of the SQL standard (SQL:2008) includes two sets of extensions: 1) support for object-relational databases and 2) support for XML. This set of commands has been greatly extended, and the new edition takes that into account. The XML extensions are entirely new to the 3e. A new chapter on basic relational concepts has been added to broaden the audience and make the book more complete in its own right.

Zusammenfassung

"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

Inhalt

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