SQL Clearly Explained (The Morgan Kaufmann Series in Data Management Systems) - Softcover

Harrington, Jan L.

Softcover

ISBN 10: 0123756979 ISBN 13: 9780123756978

Publisher: Morgan Kaufmann, 2010

Synopsis

SQL Clearly Explained, Third Edition, provides an in-depth introduction to using SQL (Structured Query Language). Readers will learn not only SQL syntax, but also how SQL works.

Although the core of the SQL language remains relatively unchanged, 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. As a result, the set of standard SQL commands has been greatly extended and this new edition takes that into account.

This new edition includes updated tips and tricks to reflect the current concepts of SQL and XML standards; several new chapters covering object-relational and XML extensions; and an ancillary package that includes case studies, a syllabus, exams and more.

This book is intended for working SQL programmers, database administrators, database designers, database analysts, and application system developers as well as those who are developing new features for database management systems who want to know about user needs. This would include anyone working with electronic content in the relational database context but also XML. Web services, etc.

• Demonstrates how to formulate SQL queries and how queries are processed to maximize performance of the database management system
• Explains use of SQL to enter, modify or delete data to maintain database structural elements
• Covers in great detail new SQL application for XML to meet the growing XML usage in development of online content

About this title

About the Author

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.

From the Back Cover

SQL Clearly Explained, Third Edition details the release of the SQL standard (SQL:2008), including two sets of extensions to support object-relational databases and XML. NEW chapters include coverage of the relational data model, relational algebra, SQL object-relational support, triggers and stored procedures, as well as XML. This expanded edition is packed with tips, tricks and other vital information for working with SQL.

Edition details

• Publisher: Morgan Kaufmann
• Publication date: 2010
• Language: English
• ISBN 10: 0123756979
• ISBN 13: 9780123756978
• Binding: Paperback
• Edition number: 3
• Number of pages: 480