SQL: A Comparative Survey
Publisher: Bookboon.com
Published: 2013
ISBN-13: 9788740307788
Table of contents: title: Sisältö; title: Introduction; title: Introduction; title: “Collection of Variables”; title: What Is an SQL Database?; title: “Table” Not Equal to “Relation”; title: Anatomy of a Table; title: What Is a DBMS?; title: SQL Is a Database Language; title: What Does an SQL DBMS Do?; title: Creating and Destroying Base Tables; title: Taking Note of Integrity Rules; title: Taking Note of Authorisations; title: Updating Variables; title: Providing Results of Queries; title: Values, Types, Variables, Operators; title: Introduction; title: Anatomy of A Command; title: Important Distinctions; title: A Closer Look at a Read-Only Operator (+); title: Read-only Operators in SQL; title: What Is a Type?; title: What Is a Type Used For?; title: The Type of a Table; title: Table Literals; title: Types and Representations; title: What Is a Variable?; title: Updating a Variable; title: Conclusion; title: Predicates and Propositions; title: Introduction; title: What Is a Predicate?; title: Substitution and Instantiation; title: How a Table Represents an Extension…; title: Deriving Predicates from Predicates; title: Relational Algebra—The Foundation; title: Introduction; title: Relations and Predicates; title: Relational Operators and Logical Operators; title: JOIN and AND; title: Renaming Columns; title: Projection and Existential Quantification; title: Restriction and AND; title: Extension and AND; title: UNION and OR; title: Semidifference and NOT; title: Concluding Remarks; title: Building on The Foundation; title: Introduction; title: Semijoin and Composition; title: Aggregate Operators; title: Tables within a Table; title: Using Aggregation on Nested Tables; title: Summarization in SQL; title: Grouping and Ungrouping in SQL; title: Wrapping and unwrapping in SQL; title: Table Comparison; title: Other Operators on Tables and Rows; title: Constraints and Updating; title: Introduction; title: A Closer Look at Constraints and Consistency; title: Expressing Constraint Conditions; title: Useful Shorthands for Expressing Some Constraints; title: Updating Tables