SQL: A Comparative Survey
Publisher: Bookboon.com
Published: 2013
ISBN-13: 9788740307788
Table of contents: title: Content; title: 1. Introduction; title: 1.1. Introduction; title: 1.2. “Collection of Variables”; title: 1.3. What Is an SQL Database?; title: 1.4. “Table” Not Equal to “Relation”; title: 1.5. Anatomy of a Table; title: 1.6. What Is a DBMS?; title: 1.7. SQL Is a Database Language; title: 1.8. What Does an SQL DBMS Do?; title: 1.9. Creating and Destroying Base Tables; title: 1.10. Taking Note of Integrity Rules; title: 1.11. Taking Note of Authorisations; title: 1.12. Updating Variables; title: 1.13. Providing Results of Queries; title: 2. Values, Types, Variables, Operators; title: 2.1. Introduction; title: 2.2. Anatomy of A Command; title: 2.3. Important Distinctions; title: 2.4. A Closer Look at a Read-Only Operator (+); title: 2.5. Read-only Operators in SQL; title: 2.6. What Is a Type?; title: 2.7. What Is a Type Used For?; title: 2.8. The Type of a Table; title: 2.9. Table Literals; title: 2.10. Types and Representations; title: 2.11. What Is a Variable?; title: 2.12. Updating a Variable; title: 2.13. Conclusion; title: 3. Predicates and Propositions; title: 3.1. Introduction; title: 3.2. What Is a Predicate?; title: 3.3. Substitution and Instantiation; title: 3.4. How a Table Represents an Extension…; title: 3.5. Deriving Predicates from Predicates; title: 4. Relational Algebra—The Foundation; title: 4.1. Introduction; title: 4.2. Relations and Predicates; title: 4.3. Relational Operators and Logical Operators; title: 4.4. JOIN and AND; title: 4.5. Renaming Columns; title: 4.6. Projection and Existential Quantification; title: 4.7. Restriction and AND; title: 4.8. Extension and AND; title: 4.9. UNION and OR; title: 4.10. Semidifference and NOT; title: 4.11. Concluding Remarks; title: 5. Building on The Foundation; title: 5.1. Introduction; title: 5.2. Semijoin and Composition; title: 5.3. Aggregate Operators; title: 5.4. Tables within a Table; title: 5.5. Using Aggregation on Nested Tables; title: 5.6. Summarization in SQL; title: 5.7. Grouping and Ungrouping in SQL; title: 5.8. Wrapping and unwrapping in SQL; title: 5.9. Table Comparison; title: 5.10. Other Operators on Tables and Rows; title: 6. Constraints and Updating; title: 6.1. Introduction; title: 6.2. A Closer Look at Constraints and Consistency; title: 6.3. Expressing Constraint Conditions; title: 6.4. Useful Shorthands for Expressing Some Constraints; title: 6.5. Updating Tables