Magnificent Marvel Supersale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | April 6, 2015

    Mary Norris: IMG Voracious



    In the summer of 2012, I got a contract for a book about language, based on my experiences of more than 30 years as a copy editor at The New Yorker.... Continue »

    spacer
Qualifying orders ship free.
$59.95
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside Database- SQL

More copies of this ISBN

Other titles in the Clearly Explained series:

SQL Clearly Explained (Clearly Explained)

by

SQL Clearly Explained (Clearly Explained) Cover

 

Synopses & Reviews

Publisher Comments:

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:

Updated to cover the new XML extensions in the latest release of the SQL standard, this title is designed for anyone who needs to use SQL with any database management system that supports the language. The book is packed with tips and tricks.

Synopsis:

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

Synopsis:

SQL Clearly Explained, 3rd 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.

  • 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 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.

Professor and Department Chair, Computer Science, Marist College, Hyde Park, New York, U.S.A.

Table of Contents

Chapter 1: The relational data model

Chapter 2: Manipulating relations with relational algebra

Chapter 3: Introduction to SQL

Chapter 4: Simple SQL retrieval

Chapter 5: Retrieving data from more than one table

Chapter 6: Advanced retrieval operations

Chapter 7: Calculations and grouping queries

Chapter 8: Data Modifications

Chapter 9: Schemas and tables

Chapter 10: Views, temporary tables, CTEs and indexes

Chapter 11: Keeping the design up to date

Chapter 12: Users and access rights

Chapter 13: Users, sessions, and transaction manipulation

Chapter 14: Triggers and stored procedures

Chapter 15: Embedded SQL

Chapter 16; Dynamic SQL

Chapter 17: XML support

Chapter 18: The object-relational data model

Chapter 19: Object-relational support

Product Details

ISBN:
9780123756978
Author:
Harrington, Jan L
Publisher:
Morgan Kaufmann Publishers
Author:
Harrington, Jan L.
Subject:
Database Management - General
Subject:
Programming Languages - SQL
Subject:
Sql (computer program language)
Subject:
Computer Languages-SQL
Copyright:
Series:
The Morgan Kaufmann Series in Data Management Systems
Publication Date:
20100531
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
480
Dimensions:
9.25 x 7.5 in

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management
Health and Self-Help » Psychology » General

SQL Clearly Explained (Clearly Explained) New Trade Paper
0 stars - 0 reviews
$59.95 In Stock
Product details 480 pages Morgan Kaufmann Publishers - English 9780123756978 Reviews:
"Synopsis" by , Updated to cover the new XML extensions in the latest release of the SQL standard, this title is designed for anyone who needs to use SQL with any database management system that supports the language. The book is packed with tips and tricks.
"Synopsis" by , A lucid guide to SQL which provides the tools to put practical instruction to work immediately!
"Synopsis" by , SQL Clearly Explained, 3rd 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.

  • 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

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.