الدخول جرب مجانًا

Follow us

مرحبًا بك في Bookboon

لكي نتمكن من توفير خدماتنا، نعتمد على سلسلة من ملفات تعريف الأرتباط الأساسية التي تساعد مستخدمينا على الاستفادة من على المزايا التي نقدمها.

عرض بيانات ملفات تعريف الارتباط
الفئات الشركات
كتاب دراسي مجاني

SQL: A Comparative Survey

بواسطة Hugh Darwen
(31 التقييمات)
1 تعليق
169
اللغة:  English
SQL: A Comparative Survey is a companion to Hugh Darwen’s An Introduction to Relational Database Theory, best studied in parallel with that text.
حمل كتب دراسية مجانية في صيغة PDF أو اقرأها في وضع الاتصال بالإنترنت. أعلانات أقل بنسبة 15%
اشتراك الشركات ‎‎ مجاني‎‎لأول ‎‎ ‏30 يوم‏‎‎ ، بعد ذلك ‎‎ ‎$5.99‎ ‎‎/شهر
الوصف
المحتوى
التعليقات

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.

  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
Punit
Great Book
More reviews
اكتب تعليقًا
نبذة عن المؤلف
Hugh

Hugh Darwen

تعرف على المؤلف
محتوى مُشابِه