Check nearby libraries
Buy this book
SQL: A Comparative Survey is a companion to Hugh Darwen’s An Introduction to Relational Database Theory, best studied in parallel with that text. Closely following the structure of the theory book, it shows how the examples in that book can be expressed in SQL. SQL’s many deviations from relational database theory are thus exposed and their consequences discussed.
Publish Date
2013
Publisher
Bookboon.com
Check nearby libraries
Buy this book
Subjects
IT & ProgrammingShowing 2 featured editions. View all 2 editions?
Edition | Availability |
---|---|
1 |
zzzz
Libraries near you:
WorldCat
|
2 |
aaaa
Libraries near you:
WorldCat
|
Book Details
Table of Contents
Content
1. Introduction
1.1. Introduction
1.2. “Collection of Variables”
1.3. What Is an SQL Database?
1.4. “Table” Not Equal to “Relation”
1.5. Anatomy of a Table
1.6. What Is a DBMS?
1.7. SQL Is a Database Language
1.8. What Does an SQL DBMS Do?
1.9. Creating and Destroying Base Tables
1.10. Taking Note of Integrity Rules
1.11. Taking Note of Authorisations
1.12. Updating Variables
1.13. Providing Results of Queries
2. Values, Types, Variables, Operators
2.1. Introduction
2.2. Anatomy of A Command
2.3. Important Distinctions
2.4. A Closer Look at a Read-Only Operator (+)
2.5. Read-only Operators in SQL
2.6. What Is a Type?
2.7. What Is a Type Used For?
2.8. The Type of a Table
2.9. Table Literals
2.10. Types and Representations
2.11. What Is a Variable?
2.12. Updating a Variable
2.13. Conclusion
3. Predicates and Propositions
3.1. Introduction
3.2. What Is a Predicate?
3.3. Substitution and Instantiation
3.4. How a Table Represents an Extension…
3.5. Deriving Predicates from Predicates
4. Relational Algebra—The Foundation
4.1. Introduction
4.2. Relations and Predicates
4.3. Relational Operators and Logical Operators
4.4. JOIN and AND
4.5. Renaming Columns
4.6. Projection and Existential Quantification
4.7. Restriction and AND
4.8. Extension and AND
4.9. UNION and OR
4.10. Semidifference and NOT
4.11. Concluding Remarks
5. Building on The Foundation
5.1. Introduction
5.2. Semijoin and Composition
5.3. Aggregate Operators
5.4. Tables within a Table
5.5. Using Aggregation on Nested Tables
5.6. Summarization in SQL
5.7. Grouping and Ungrouping in SQL
5.8. Wrapping and unwrapping in SQL
5.9. Table Comparison
5.10. Other Operators on Tables and Rows
6. Constraints and Updating
6.1. Introduction
6.2. A Closer Look at Constraints and Consistency
6.3. Expressing Constraint Conditions
6.4. Useful Shorthands for Expressing Some Constraints
6.5. Updating Tables
ID Numbers
Community Reviews (0)
Feedback?History
- Created April 24, 2015
- 4 revisions
Wikipedia citation
×CloseCopy and paste this code into your Wikipedia page. Need help?
August 22, 2020 | Edited by ISBNbot2 | normalize ISBN |
April 24, 2015 | Edited by Alice Kirk | Edited without comment. |
April 24, 2015 | Edited by Alice Kirk | Added new cover |
April 24, 2015 | Created by Alice Kirk | Added new book. |