Browse content
Table of contents
Actions for selected chapters
- Full text access
- Book chapterNo access
Appendix A - Common Acronyms and Abbreviations
Pages 419-420 - Book chapterNo access
Appendix B - SQLSTATE Return Codes
Pages 421-431 - Book chapterNo access
Appendix C - SQL Syntax Summary
Pages 433-444 - Book chapterNo access
Glossary
Pages 445-454 - 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