Books & Videos

Table of Contents

  1. Foundations

    1. Chapter 1 Basic Database Concepts

      1. What’s a database?
      2. What’s a DBMS?
      3. What’s a relational DBMS?
      4. Database systems vs. programming systems
      5. Exercises
      6. Answers
    2. Chapter 2 Relations and Relvars

      1. Relations
      2. Relvars
      3. Exercises
      4. Answers
    3. Chapter 3 Keys, Foreign Keys, and Related Matters

      1. Integrity constraints
      2. Keys
      3. Foreign keys
      4. Relvar definitions
      5. Loading the database
      6. Database systems vs. programming systems bis
      7. Exercises
      8. Answers
    4. Chapter 4 Relational Operators I

      1. Codd’s original algebra
      2. Restrict
      3. Project
      4. Exercises I
      5. Answers I
      6. Union, intersection, and difference
      7. Rename
      8. Exercises II
      9. Answers II
      10. Join
      11. Relational comparisons
      12. Update operator expansions
      13. Exercises III
      14. Answers III
    5. Chapter 5 Relational Operators II

      1. MATCHING and NOT MATCHING
      2. EXTEND
      3. Image relations
      4. Aggregation and summarization
      5. Exercises
      6. Answers
    6. Chapter 6 Constraints and Predicates

      1. Database constraints
      2. Relvar predicates
      3. Predicates vs. constraints
      4. Exercises
      5. Answers
    7. Chapter 7 The Relational Model

      1. The relational model defined
      2. Types
      3. The RELATION type generator
      4. Relation variables
      5. Relational assignment
      6. Relational operators
      7. Concluding remarks
  2. Transactions and Database Design

    1. Chapter 8 Transactions

      1. What’s a transaction?
      2. Recovery
      3. Concurrency
      4. Locking
      5. A remark on SQL
      6. Exercises
      7. Answers
    2. Chapter 9 Database Design

      1. Nonloss decomposition
      2. Functional dependencies
      3. Second normal form
      4. Third normal form
      5. Boyce/Codd normal form
      6. Concluding remarks
      7. Exercises
      8. Answers
  3. SQL

    1. Chapter 10 SQL Tables

      1. A little history
      2. Basic concepts
      3. Properties of tables
      4. Table updates
      5. Equality comparisons
      6. Table definitions
      7. SQL systems vs. programming systems
      8. Exercises
      9. Answers
    2. Chapter 11 SQL Operators I

      1. Restrict
      2. Project
      3. Union, intersection, and difference
      4. Rename
      5. Exercises I
      6. Answers I
      7. Join
      8. Evaluating table expressions
      9. Table comparisons
      10. Displaying results
      11. Exercises II
      12. Answers II
    3. Chapter 12 SQL Operators II

      1. MATCHING and NOT MATCHING
      2. EXTEND
      3. Image relations
      4. Aggregation and summarization
      5. Exercises
      6. Answers
    4. Chapter 13 SQL Constraints

      1. Database constraints
      2. Type constraints
      3. Exercises
      4. Answers
    5. Chapter 14 SQL vs. the Relational Model

      1. Some generalities
      2. Some SQL departures from the relational model
      3. Exercises
      4. Answers
  4. Appendixes

    1. Appendix A Tutorial D Grammar

      1. Expressions
      2. Assignments
    2. Appendix TABLE_DUM and TABLE_DEE

    3. Appendix Set Theory

      1. What’s a set?
      2. Subsets and supersets
      3. Set operators
      4. Some identities
      5. The algebra of sets
      6. Cartesian product
      7. Concluding remarks
    4. Appendix Relational Calculus

      1. Sample queries
      2. Sample constraints
      3. A simplified grammar
      4. Exercises
      5. Answers
    5. Appendix A Guide to Further Reading

      1. Papers by E. F. Codd
      2. Books by C. J. Date
      3. Books by C. J. Date and Hugh Darwen
      4. Other Publications Related to SQL
      5. Miscellaneous