Skip to main content

Learning Resources

This generated surface maps a learner-facing curriculum unit to its canonical source routes.

Curriculum surface​

  • Open learner-facing unit
  • Curriculum path: content/curriculum/architecture/semester-06-databases-distributed/module-01-relational-databases-sql/resources.md
  • App: architecture
  • Semester: semester-06-databases-distributed
  • Module: module-01-relational-databases-sql
  • Unit kind: resource
  • Curation level: module_curated

Learning objectives​

  • Explain Learning Resources using the language of schema, constraints, query semantics, and tradeoffs instead of isolated SQL syntax.
  • Connect the learner-facing explanation of Learning Resources to real database behavior you can inspect in a running system or reason about from execution plans.
  • Use database-system-concepts, ddia to tie relational ideas back to formal models, practical query behavior, and design decisions.

Prerequisites​

  • Comfort with sets, functions, and the idea of data modeling from earlier semesters.

Source books​

  • database-system-concepts
  • ddia

Source routes​

Database System Concepts​

  • /books/database-system-concepts via Silberschatz: Additional basic operations, Silberschatz: Aggregate functions, Silberschatz: Algorithms for decomposition, Silberschatz: Basic structure of SQL queries, part 1, Silberschatz: Basic structure of SQL queries, part 2, Silberschatz: Choice of evaluation plans, Silberschatz: Database schema, Silberschatz: Decomposition using FDs, part 1, Silberschatz: Estimating statistics of expression results, Silberschatz: Extended ER features, part 1, Silberschatz: Features of good relational designs, Silberschatz: Functional dependency theory, part 1, Silberschatz: Functions and procedures, Silberschatz: Index definition in SQL, Silberschatz: Integrity constraints, part 1, Silberschatz: Integrity constraints, parts 2-3, Silberschatz: Join expressions, Silberschatz: Join operation, parts 1-6, Silberschatz: Keys, Silberschatz: Materialized views, Silberschatz: Measures of query cost, part 1, Silberschatz: Modification of the database, Silberschatz: Nested subqueries, Silberschatz: Normal forms, part 1, Silberschatz: Null values, Silberschatz: Reducing ER diagrams to relational schemas, Silberschatz: SQL data definition, Silberschatz: SQL data types and schemas, Silberschatz: Schema diagrams, Silberschatz: Selection operation, part 1, Silberschatz: Set operations, Silberschatz: Structure of relational databases, Silberschatz: The relational algebra, part 1, Silberschatz: The relational algebra, parts 2-4, Silberschatz: Transaction concept (17.1), Silberschatz: Transaction isolation levels, Silberschatz: Transactions as SQL statements, Silberschatz: Transformation of relational expressions, Silberschatz: Triggers, Silberschatz: Views, part 1
  • /books/database-system-concepts/chapter-26-blockchain-databases via Silberschatz: Query processing overview (15.1)

Ddia​

Supporting curriculum routes​

No supporting curriculum routes linked yet.

External enrichment​

  • PostgreSQL Documentation: Table Expressions (official_docs_companion) - Anchors relational and query-structure ideas in an authoritative database reference learners can revisit later.
  • PostgreSQL Tutorial (read_if_stuck) - Provides runnable examples that help convert the relational model from vocabulary into working intuition.

AI companion modes​

  • Explain simply
  • Diagnose my confusion
  • Revision mode
  • Connect forward / backward

Source-of-truth note​

This teaching unit is learner-facing guidance assembled from multiple canonical book routes. Use the listed source books as the primary conceptual spine for Learning Resources, and treat outside material as supporting enrichment only.