Skip to main content
Elsevier
View Cart

SQL Clearly Explained

  • 3rd Edition - May 28, 2003
  • Latest edition
  • Author: Jan L. Harrington
  • Language: English

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 more

World Book Day celebration

Where learning shapes lives

Up to 25% off trusted resources that support research, study, and discovery.

Explore resources

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.

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

Readership

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

Table of contents

Part I: Introduction Chapter 1: The Relational Data Model Schemas and Entities Relations and Tables Representing Relationships Views The Design of the Sample Database Chapter 2: Relational Algebra Making Vertical Subsets: Project Making Horizontal Subsets: Restrict Choosing Columns and Rows: Restrict and Then Project Union Join Difference Intersect Divide Chapter 3: Introduction to SQL A Bit of SQL History Conformance Levels SQL Environments Elements of a SQL StatementPart II: Interactive SQL Chapter 4: Simple SQL Retrieval Choosing Columns Ordering the Result Table Choosing Rows Nulls and Retrieval: Three-Valued Logic Chapter 5: Retrieving Data From More Than One Table SQL Syntax for Inner Joins Finding Multiple Rows in One Table: Joining a Table to Itself Outer Joins Table Constructors in Queries Avoiding Joins with Uncorrelated Subqueries Chapter 6: Advanced Retrieval Operations Union Negative Queries The EXISTS Operator The INTERSECT Operator Performing Arithmetic String Manipulation Date and Time Manipulation CASE Expressions Chapter 7: Working with Groups of Rows Set Functions Changing Data Types: CAST Grouping Queries Windowing and Window Functions Chapter 8: Data Modification Inserting Rows Updating Data Deleting Rows MERGEPart III: Managing Database Structure Chapter 9: Schemas and Tables Database Object Hierarchy Schemas Domains Tables Assertions Determining When Constraints are Checked Chapter 10: Views, Temporary Tables, CTEs, and Indexes Views Temporary Tables Common Table Expressions (CTEs) Indexes Chapter 11: Keeping the Design Up to Date Modifying Tables Modifying Domains Deleting Database Elements Chapter 12: Users and Access Rights Managing User Accounts Granting and Revoking Access Rights Roles Chapter 13: Users, Sessions, and Transaction Control The Concurrent Use Data Environment Database Sessions and Connections Transaction ControlPart IV: SQL Programming Chapter 14: Writing and Executing SQL Routines and Modules—Triggers and Stored Procedures SQL Programming Elements Executing Modules as Triggers Executing Modules as Stored Procedures Chapter 15: Embedded SQL The Embedded SQL Environment Using Host Language Variables DBMS Return Codes Retrieving a Single Row Retrieving Multiple Rows: Cursors Embedded SQL Data Modification Chapter 16: Dynamic SQL Immediate Execution Dynamic SQL with Dynamic ParametersPart V: Non-Relational SQL Extensions Chapter 17: XML Support XML Basics SQL/XML The XML Data Type Chapter 18: The Object-Relational Data Model Getting Started: Object-Orientation Without Computing Basic OO Concepts Benefits of Object-Orientation Pure Object-Oriented Databases The Object-Relational Data Model Chapter 19: Object-Relational Support An Additional Sample Database SQL Data Types for Object-Relational Support User-Defined Data Types and Typed Tables MethodsPart VI: Appendices Appendix A: Common Acronyms and Abbreviations Appendix B: SQLSTATE Return Codes Appendix C: SQL Syntax SummaryGlossaryIndex

Review quotes

"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

Product details

  • Edition: 3
  • Latest edition
  • Published: April 23, 2010
  • Language: English

About the author

JH

Jan L. Harrington

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.
Affiliations and expertise
Professor and Department Chair, Computer Science, Marist College, Hyde Park, NY, USA

View book on ScienceDirect

Read SQL Clearly Explained on ScienceDirect