Skip navigation

Bookboon.com Download free eBooks and textbooks

Choose a category

SQL: A Comparative Survey

SQL: A Comparative Survey
4.5 (24 reviews)
ISBN: 978-87-403-0778-8
2 edition
Pages : 169
  • Price: 129.00 kr
  • Price: €13.99
  • Price: £13.99
  • Price: ₹250
  • Price: $13.99
  • Price: 129.00 kr
  • Price: 129.00 kr

Download for FREE in 4 easy steps...

We are terribly sorry, but in order to download our books or watch our videos, you will need a browser that allows JavaScript.
After entering your email address, a confirmation email will be sent to your inbox. Please approve this email to receive our weekly eBook update. We will not share your personal information with any third party.
eLib
Unlock your organization's learning potential
See Demo

Corporate eLibrary

Discover our employee learning solutions

This is a Premium eBook

Bookboon Premium - Gain access to over 800 eBooks - without ads

You can get free access for a month to this - and 800 other books with the Premium Subscription. You can also buy the book below

  • Start a 30-day free trial. After trial: 39.99 kr p/m
  • Start a 30-day free trial. After trial: €5.99 p/m
  • Start a 30-day free trial. After trial: £4.99 p/m
  • Start a 30-day free trial. After trial: ₹299 p/m
  • Start a 30-day free trial. After trial: $3.99 p/m
  • Start a 30-day free trial. After trial: 39.99 kr p/m
  • Start a 30-day free trial. After trial: 39.99 kr p/m
eLib
Unlock your organization's learning potential
Click here!

Corporate eLibrary

Discover our employee learning solutions

About the book

  1. Description
  2. Content

Description

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. Drawing on the author’s long experience as a member of the committee responsible for production of the ISO SQL standard, the book includes copious Historical Notes showing how SQL has evolved from its very beginnings in the 1970s.

Content

  1. Introduction
    1. Introduction
    2. “Collection of Variables”
    3. What Is an SQL Database?
    4. “Table” Not Equal to “Relation”
    5. Anatomy of a Table
    6. What Is a DBMS?
    7. SQL Is a Database Language
    8. What Does an SQL DBMS Do?
    9. Creating and Destroying Base Tables
    10. Taking Note of Integrity Rules
    11. Taking Note of Authorisations
    12. Updating Variables
    13. Providing Results of Queries
  2. Values, Types, Variables, Operators
    1. Introduction
    2. Anatomy of A Command
    3. Important Distinctions
    4. A Closer Look at a Read-Only Operator (+)
    5. Read-only Operators in SQL
    6. What Is a Type?
    7. What Is a Type Used For?
    8. The Type of a Table
    9. Table Literals
    10. Types and Representations
    11. What Is a Variable?
    12. Updating a Variable
    13. Conclusion
  3. Predicates and Propositions
    1. Introduction
    2. What Is a Predicate?
    3. Substitution and Instantiation
    4. How a Table Represents an Extension…
    5. Deriving Predicates from Predicates
  4. Relational Algebra—The Foundation
    1. Introduction
    2. Relations and Predicates
    3. Relational Operators and Logical Operators
    4. JOIN and AND
    5. Renaming Columns
    6. Projection and Existential Quantification
    7. Restriction and AND
    8. Extension and AND
    9. UNION and OR
    10. Semidifference and NOT
    11. Concluding Remarks
  5. Building on The Foundation
    1. Introduction
    2. Semijoin and Composition
    3. Aggregate Operators
    4. Tables within a Table
    5. Using Aggregation on Nested Tables
    6. Summarization in SQL
    7. Grouping and Ungrouping in SQL
    8. Wrapping and unwrapping in SQL
    9. Table Comparison
    10. Other Operators on Tables and Rows
  6. Constraints and Updating
    1. Introduction
    2. A Closer Look at Constraints and Consistency
    3. Expressing Constraint Conditions
    4. Useful Shorthands for Expressing Some Constraints
    5. Updating Tables
This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with EU regulation.