SQL Clearly Explained
Free Global Shipping
No minimum orderDescription
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 Statement
Part 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
MERGE
Part 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 Control
Part 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 Parameters
Part 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
Methods
Part VI: Appendices
Appendix A: Common Acronyms and Abbreviations
Appendix B: SQLSTATE Return Codes
Appendix C: SQL Syntax Summary
Glossary
Index
Product details
- No. of pages: 480
- Language: English
- Copyright: © Morgan Kaufmann 2010
- Published: May 28, 2003
- Imprint: Morgan Kaufmann
- Paperback ISBN: 9780123756978
About the Author
Jan 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