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

3.8 avg rating
( 5 ratings by GoodReads )
 
9780123756978: SQL Clearly Explained, (The Morgan Kaufmann Series in Data Management Systems)

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. The second edition of this book included some material about the object-relational extensions. However, that set of commands has been greatly extended and the new edition takes that into account. The XML extensions are entirely new to the third edition. A chapter on basic relational concepts will be also added to broaden the audience and make the book more complete in its own right.



All of the chapters will be revised to be sure they are up to date. Chapter 10 ("Views, Temporary Tables, and Indexes") from the second edition will be expanded to include common table expression (CTEs). The material in the existing Chapter 14 ("Unimplemented SQL-92 Features 251") will be disbursed through the chapters where the particular type of operation is discussed. While the content throughout will be updated where necessary, the existing organizational structure through chapter 14 will remain largely intact because this coverage represents the stable portion of the SQL language.



There will be two NEW chapters at the beginning of the book. Chapter 1 ("The Relational Data Model") covers the relational data model conceptual material; Chapter 2 ("Manipulating Relations with Relational Algebra") covers the relational algebra material that will be pulled from the retrieval chapters. Part 5 ("Non-relational SQL Extensions") will now include the non-relational SQL extensions in three chapters. Chapter 17 (NEW) will cover XML. Chapter 18 will contain the object-relational conceptual material from the original chapter 15 and chapter 19 (NEW) will cover SQL object-relational support. (Some of chapter 19 will come from the second edition, however, a great deal of object-relational support has been added to the current standard and therefore needs to be added.) The other NEW chapter is Chapter 14, which covers triggers and stored procedures. This material was missing from previous editions. Many readers should find it a useful addition.




  • 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

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

Review:

"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

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.

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

Top Search Results from the AbeBooks Marketplace

1.

Jan L. Harrington
Published by ELSEVIER SCIENCE TECHNOLOGY, United States (2010)
ISBN 10: 0123756979 ISBN 13: 9780123756978
New Paperback Quantity Available: 1
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description ELSEVIER SCIENCE TECHNOLOGY, United States, 2010. Paperback. Book Condition: New. 3rd Revised edition. 229 x 190 mm. Language: English . Brand New Book. 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. * 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. Bookseller Inventory # LIB9780123756978

More Information About This Seller | Ask Bookseller a Question

Buy New
40.74
Convert Currency

Add to Basket

Shipping: FREE
Within United Kingdom
Destination, Rates & Speeds

2.

Jan L. Harrington
Published by Morgan Kaufmann (2010)
ISBN 10: 0123756979 ISBN 13: 9780123756978
New Paperback Quantity Available: 1
Seller
Herb Tandree Philosophy Books
(Stroud, GLOS, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann, 2010. Paperback. Book Condition: NEW. 9780123756978 This listing is a new book, a title currently in-print which we order directly and immediately from the publisher. Bookseller Inventory # HTANDREE0892592

More Information About This Seller | Ask Bookseller a Question

Buy New
37
Convert Currency

Add to Basket

Shipping: 3.77
Within United Kingdom
Destination, Rates & Speeds

3.

Jan L. Harrington
Published by Morgan Kaufmann (2010)
ISBN 10: 0123756979 ISBN 13: 9780123756978
New Paperback Quantity Available: 1
Seller
Herb Tandree Philosophy Books
(Stroud, GLOS, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann, 2010. Paperback. Book Condition: NEW. 9780123756978 This listing is a new book, a title currently in-print which we order directly and immediately from the publisher. Bookseller Inventory # HTANDREE01196684

More Information About This Seller | Ask Bookseller a Question

Buy New
37
Convert Currency

Add to Basket

Shipping: 3.77
Within United Kingdom
Destination, Rates & Speeds

4.

Jan L. Harrington
Published by Oxford Elsevier LTD Jul 2010 (2010)
ISBN 10: 0123756979 ISBN 13: 9780123756978
New Taschenbuch Quantity Available: 1
Rating
[?]

Book Description Oxford Elsevier LTD Jul 2010, 2010. Taschenbuch. Book Condition: Neu. 235x192x34 mm. Neuware - 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. 448 pp. Englisch. Bookseller Inventory # 9780123756978

More Information About This Seller | Ask Bookseller a Question

Buy New
38.63
Convert Currency

Add to Basket

Shipping: 4.37
From Germany to United Kingdom
Destination, Rates & Speeds

5.

Jan L. Harrington
Published by ELSEVIER SCIENCE TECHNOLOGY, United States (2010)
ISBN 10: 0123756979 ISBN 13: 9780123756978
New Paperback Quantity Available: 1
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description ELSEVIER SCIENCE TECHNOLOGY, United States, 2010. Paperback. Book Condition: New. 3rd Revised edition. 229 x 190 mm. Language: English . Brand New Book. 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. * 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. Bookseller Inventory # LIB9780123756978

More Information About This Seller | Ask Bookseller a Question

Buy New
46.33
Convert Currency

Add to Basket

Shipping: FREE
Within United Kingdom
Destination, Rates & Speeds

6.

Jan L. Harrington
Published by Oxford Elsevier LTD Jul 2010 (2010)
ISBN 10: 0123756979 ISBN 13: 9780123756978
New Taschenbuch Quantity Available: 1
Seller
AHA-BUCH GmbH
(Einbeck, Germany)
Rating
[?]

Book Description Oxford Elsevier LTD Jul 2010, 2010. Taschenbuch. Book Condition: Neu. 235x192x34 mm. Neuware - 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. 448 pp. Englisch. Bookseller Inventory # 9780123756978

More Information About This Seller | Ask Bookseller a Question

Buy New
38.63
Convert Currency

Add to Basket

Shipping: 7.86
From Germany to United Kingdom
Destination, Rates & Speeds

7.

Jan L. Harrington
Published by Oxford Elsevier LTD Jul 2010 (2010)
ISBN 10: 0123756979 ISBN 13: 9780123756978
New Taschenbuch Quantity Available: 1
Seller
Rheinberg-Buch
(Bergisch Gladbach, Germany)
Rating
[?]

Book Description Oxford Elsevier LTD Jul 2010, 2010. Taschenbuch. Book Condition: Neu. 235x192x34 mm. Neuware - 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. 448 pp. Englisch. Bookseller Inventory # 9780123756978

More Information About This Seller | Ask Bookseller a Question

Buy New
38.63
Convert Currency

Add to Basket

Shipping: 8.74
From Germany to United Kingdom
Destination, Rates & Speeds

8.

Jan L. Harrington
Published by Oxford Elsevier LTD Jul 2010 (2010)
ISBN 10: 0123756979 ISBN 13: 9780123756978
New Taschenbuch Quantity Available: 1
Seller
Agrios-Buch
(Bergisch Gladbach, Germany)
Rating
[?]

Book Description Oxford Elsevier LTD Jul 2010, 2010. Taschenbuch. Book Condition: Neu. 235x192x34 mm. Neuware - 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. 448 pp. Englisch. Bookseller Inventory # 9780123756978

More Information About This Seller | Ask Bookseller a Question

Buy New
38.63
Convert Currency

Add to Basket

Shipping: 8.74
From Germany to United Kingdom
Destination, Rates & Speeds

9.

Jan L. Harrington
Published by Morgan Kaufmann (2010)
ISBN 10: 0123756979 ISBN 13: 9780123756978
New Softcover Quantity Available: 1
Seller
Rating
[?]

Book Description Morgan Kaufmann, 2010. Book Condition: New. Bookseller Inventory # L9780123756978

More Information About This Seller | Ask Bookseller a Question

Buy New
43.04
Convert Currency

Add to Basket

Shipping: 4.41
From Germany to United Kingdom
Destination, Rates & Speeds

10.

Jan L. Harrington
Published by Elsevier Science & Technology
ISBN 10: 0123756979 ISBN 13: 9780123756978
New Paperback Quantity Available: 1
Seller
THE SAINT BOOKSTORE
(Southport, United Kingdom)
Rating
[?]

Book Description Elsevier Science & Technology. Paperback. Book Condition: new. BRAND NEW, SQL Clearly Explained (3rd Revised edition), Jan L. Harrington, 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. * 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. Bookseller Inventory # B9780123756978

More Information About This Seller | Ask Bookseller a Question

Buy New
44.71
Convert Currency

Add to Basket

Shipping: 2.75
Within United Kingdom
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book