ERD: Data modelling
Apply ERD through entities, relationships, constraints.
Beginner / Structured learning draft / Version 0.9
Structured learning draftDatabase Design & Modelling
Model, query and explain dependable data. You will finish with a working data model with validated queries.
This open learning manuscript is undergoing course-specific editorial review. It does not provide certification. Progress and notes are stored only in this browser.
DatabasesTool stack
PostgreSQL
12guided lessons
4focused modules
1reviewable project
PDFoffline workbook
The problem
What this course helps you do
Database Design & Modelling is a structured, practical course covering ERD, Normalisation, Schemas, Relationships. It emphasizes explainable methods, checked work and a final outcome that can be reviewed.
Who it is for
Developers and analysts who need dependable data systems.
Prerequisites
- Basic programming or spreadsheet experience
Portfolio-ready project
Produce a reviewable Database Design & Modelling project using ERD, Normalisation, Schemas.
Deliverable: A working Database Design & Modelling artefact plus an evidence-based self-review.
Practice fileRelational data practiceSafe SQL schema and queries for a fictional service business.Planning template · MarkdownProject briefDefine the user, outcome, boundaries, evidence and acceptance criteria before building.Printable workbook · PDFComplete course workbookA4-ready lesson prompts, project worksheets, evidence logs and references.
Downloads open without an account. Practice data is fictional; review each file before using it in another system.
Definition of done
- The output matches the stated outcome.
- Inputs and decisions are reproducible.
- Boundary and failure evidence is included.
- Limitations and responsibility considerations are explicit.
Course plan
From first concept to finished work
Normalisation: Querying
Apply Normalisation through selection, joins, aggregation.
Schemas: Reliability
Apply Schemas through transactions, indexes, backups.
Relationships: Production design
Apply Relationships through security, performance, operations.
Source-led learning
Authoritative references
Course claims are grounded in primary documentation and recognized public guidance. Recheck version-sensitive information before professional use.
- PostgreSQL TutorialPostgreSQL Global Development Group
- SQL LanguagePostgreSQL Global Development Group