Web Resources for Persistent Data Management

This page keeps source links outside the lessons so the modules remain easy to read.

Use the labels in this order:

• Easy second explanation: learn the idea in another friendly way.
• Official technical reference: verify exact definitions or product behavior.
• Practice resource: watch, run, or solve examples yourself.

Module 1: Introduction to Data Models

• Easy second explanation: PostgreSQL database tutorial
• Official technical reference: PostgreSQL architectural fundamentals
• Practice resource: University of Wisconsin database slides

Module 2: Functional Dependency and Normalization

• Easy second explanation: IBM overview of database normalization
• Official technical reference: IBM Db2 normalization guide
• Practice resource: University of Wollongong normalization examples

Module 3: Relational Algebra

• Easy second explanation: University of Wisconsin DBMS slides
• Official technical reference: University of Wisconsin database slides
• Practice resource: Rework the three practice queries in Module-3.md with the school schema.

Module 4: Relational Calculus

• Easy second explanation: Read the English-to-logic translation method in Module-4.md.
• Official technical reference: University of Wisconsin database slides
• Practice resource: Translate the English questions in Module-4.md into TRC and DRC.

Module 5: SQL

• Easy second explanation: PostgreSQL SQL tutorial
• Official technical reference: PostgreSQL SQL command index
• Practice resource: PostgreSQL tutorial exercises

Module 6: Indexing and Hashing

• Easy second explanation: PostgreSQL introduction to indexes
• Official technical reference: PostgreSQL index types
• Practice resource: PostgreSQL CREATE INDEX

Module 7: Query Processing and Optimization

• Easy second explanation: PostgreSQL plan-reading introduction
• Official technical reference: PostgreSQL planner statistics
• Practice resource: Run EXPLAIN on the query in Module-7.md and identify scans and joins.

Module 8: Transaction Management

• Easy second explanation: PostgreSQL transaction tutorial
• Official technical reference: PostgreSQL transaction isolation
• Practice resource: PostgreSQL savepoints

Module 9: Concurrency Control

• Easy second explanation: PostgreSQL MVCC introduction
• Official technical reference: PostgreSQL explicit locking
• Practice resource: Draw wait-for graphs for the deadlock examples in Module-9.md.

Module 10: Advanced Topics

• Easy second explanation: Apache Spark quick start
• Official technical reference: W3C XML standard, Apache HDFS guide
• Practice resource: Apache Spark examples

Best way to use these links

1. Read the module's simple idea and worked example.
2. Try its self-check without looking at the answer.
3. Open the easy resource if the idea is still unclear.
4. Use the official reference to verify technical details.
5. Finish with the practice resource.