Cover for SQL Clearly Explained

SQL Clearly Explained

A volume in The Morgan Kaufmann Series in Data Management Systems

Book • Third Edition2010

Author:

Jan L. Harrington

SQL Clearly Explained

A volume in The Morgan Kaufmann Series in Data Management Systems

Book • Third Edition2010

 

Cover for SQL Clearly Explained

Author:

Jan L. Harrington

About the book

Browse this book

Book description

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. Al ... read full description

Browse content

Table of contents

Actions for selected chapters

Select all / Deselect all

  1. Full text access
    1. Book chapterNo access
      Appendix A - Common Acronyms and Abbreviations

      Pages 419-420

    2. Book chapterNo access
      Appendix B - SQLSTATE Return Codes

      Pages 421-431

    3. Book chapterNo access
      Appendix C - SQL Syntax Summary

      Pages 433-444

    4. Book chapterNo access
      Glossary

      Pages 445-454

    5. Book chapterNo access
      Index

      Pages 455-462

About the book

Description

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.

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.

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

Details

ISBN

978-0-12-375697-8

Language

English

Published

2010

Copyright

Copyright © 2010 Elsevier Inc. All rights reserved

Imprint

Morgan Kaufmann

Authors

Jan L. Harrington