SQL Clearly Explained,

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