SQL 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. Understanding the how as well as the what will aid in creating SQL statements that execute as quickly as possible. The book is organized into five parts. Part I presents the theoretical material underlying relational databases and SQL. Part II covers interactive SQL retrieval. Part III discusses the creation and management of database structure. It also covers non-data elements in the database environment, such as managing users/user accounts and transaction control. Part IV introduces several techniques for SQL programming: embedded SQL (using a high-level host language), dynamic SQL, and triggers/stored procedures. Part V discusses the non-relational extensions that have been added to the SQL standard: XML and object-relational capabilities. It covers object-oriented concepts, including the differences between pure object-oriented databases and object-relational databases. It also looks at SQL's object-relational 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
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.
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 Ch
- No. of pages:
- © Morgan Kaufmann 2010
- 23rd April 2010
- Morgan Kaufmann
- eBook ISBN:
- eBook ISBN:
- Paperback ISBN:
"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