PostgreSQL / Basic: relational foundations

PostgreSQL โ€” Basic: relational foundations

Model valid facts and compose deterministic queries and scoped changes.

6 lessons ยท No account required

What you will learn

  • Explain schemas, types, keys, joins and aggregate grain.
  • Read and change synthetic data with explicit PostgreSQL semantics.

  1. PostgreSQL servers, sessions and schemas

    Locate a query inside the PostgreSQL architecture and resolve object names deliberately. Separate a cluster, database, schema and client before diagnosing SQL behavior.

    Start learning

  2. Types, constraints and generated identity

    Describe parcel facts with exact types, valid relationships and deliberate missing-value rules. Distinguish identity generation from uniqueness and time-zone display.

    Start learning

  3. SELECT, NULL ordering and pagination

    Turn a parcel question into a deterministic result. Control boolean logic, date boundaries, parameter binding and PostgreSQLโ€™s default null placement.

    Start learning

  4. Joins and relational cardinality

    Combine customers, bookings and payments without losing optional relationships or multiplying business measures. Predict each intermediate row count before aggregating.

    Start learning

  5. Aggregates and reporting stages

    Produce reliable counts, totals and conditional summaries. Separate pre-group filtering from group filtering and distinguish an empty set from a zero measure.

    Start learning

  6. Writes, RETURNING and conflict handling

    Make inventory writes state their own preconditions and return their actual effects. Separate a duplicate-key update from business-level idempotency.

    Start learning
Back to course