Skip navigation

Bookboon.com Last ned gratis eBøker og lærebøker

Choose a category

SQL: A Comparative Survey

SQL: A Comparative Survey
4,6 (28 vurderinger)
ISBN: 978-87-403-0778-8
2 utgave
Sider : 169
  • Pris: 129,00 kr
  • Pris: €13,99
  • Pris: £13,99
  • Pris: ₹250
  • Pris: $13,99
  • Pris: 129,00 kr
  • Pris: 129,00 kr

Last ned GRATIS med 4 enkle steg…

Vi beklager, men for å laste ned våre bøker eller se våre videoer må du ha en nettleser som støtter JavaScript.
Kan vi friste med noen KOSTNADSFRIE e-bøker og relevante Bookboon-oppdateringer?
Etter å ha oppgitt e-postadressen blir en bekreftelsesmail sendt til din mailbox. Vennligst godkjenn den for å motta vår ukentlig eBok-oppdatering. Eventuell kontaktinformasjon som blir oppgitt, vil ikke bli oppgitt til noen tredjepart.
eLib
Lås opp ditt selskaps læringspotensial
Se demo

Korporat eBibliotek

Utforsk våre Firmaløsninger for ansattes læring

Dette er en Premium-eBok

Bookboon Premium - Få tilgang til over 800 eBøker - uten annonser

Du kan få gratis tilgang til dette i én måned - og 800 andre bøker med Premium-abonnementet. Du kan også kjøpe boken nedenfor

  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: 39,99 kr p/m
  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: €5,99 p/m
  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: £4,99 p/m
  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: ₹299 p/m
  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: $3,99 p/m
  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: 39,99 kr p/m
  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: 39,99 kr p/m
eLib
Lås opp ditt selskaps læringspotensial
Klikk her!

Korporat eBibliotek

Utforsk våre Firmaløsninger for ansattes læring

Om boken

  1. Beskrivelse
  2. Innhold

Beskrivelse

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.

Innhold

  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.