Darwen Hugh. SQL: A Comparative Survey

2nd Edition. — Bookboon.com (Ventus Publishing ApS), 2012. — 172 p.
ISBN: 978-87-403-0778-8.Collection of Variables.
What Is an SQL Database?
Table Not Equal to Relation.
Anatomy of a Table.
What Is a DBMS?
SQL Is a Database Language.
What Does an SQL DBMS Do?
Creating and Destroying Base Tables.
Taking Note of Integrity Rules.
Taking Note of Authorisations.
Updating Variables.
Providing Results of Queries.Values, Types, Variables, Operators.Anatomy of A Command.
Important Distinctions.
A Closer Look at a Read-Only Operator (+).
Read-only Operators in SQL.
What Is a Type?
What Is a Type Used For?
The Type of a Table.
Table Literals.
Types and Representations.
What Is a Variable?
Updating a Variable.Predicates and Propositions.What Is a Predicate?
Substitution and Instantiation.
How a Table Represents an Extension.
Deriving Predicates from Predicates.Relational Algebra — The Foundation.Relations and Predicates.
Relational Operators and Logical Operators.
JOIN and AND.
Renaming Columns.
Projection and Existential Quantification.
Restriction and AND.
Extension and AND.
UNION and OR.
Semidifference and NOT.
Concluding Remarks.
Exercises.Building on The Foundation.Semijoin and Composition.
Aggregate Operators.
Tables within a Table.
Using Aggregation on Nested Tables.Summarization in SQL.
Grouping and Ungrouping in SQL.
Wrapping and unwrapping in SQL.
Table Comparison.
Other Operators on Tables and Rows.
Exercises.Constraints and Updating.A Closer Look at Constraints and Consistency.
Expressing Constraint Conditions.
Useful Shorthands for Expressing Some Constraints.
Updating Tables.
Exercises.
Appendix A: References and Bibliography.