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

Harrington, Jan L.

 
9780123756978: SQL Clearly Explained (The Morgan Kaufmann Series in Data Management Systems)
Softcover
ISBN 10: 0123756979 ISBN 13: 9780123756978
Publisher: Morgan Kaufmann, 2010

Synopsis

SQL 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. Understanding the how as well as the what will aid in creating SQL statements that execute as quickly as possible. The book is organized into five parts. Part I presents the theoretical material underlying relational databases and SQL. Part II covers interactive SQL retrieval. Part III discusses the creation and management of database structure. It also covers non-data elements in the database environment, such as managing users/user accounts and transaction control. Part IV introduces several techniques for SQL programming: embedded SQL (using a high-level host language), dynamic SQL, and triggers/stored procedures. Part V discusses the non-relational extensions that have been added to the SQL standard: XML and object-relational capabilities. It covers object-oriented concepts, including the differences between pure object-oriented databases and object-relational databases. It also looks at SQL's object-relational features.

"synopsis" may belong to another edition of 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.

"About this title" may belong to another edition of this title.

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