Database Design & Development
Database Design & Development lessons
All Database Design & Development topics in sequence. Available lessons will open directly; remaining topics are shown so the full database pathway is visible.
Available
11 of 11
Unit
DDD
Progress
100%
DDD1
Analysis: end-user and functional requirements
Identifying who needs the database and what it must do
Available
DDD2
ER diagrams: entities, attributes, relationships
Modelling the data needed before building tables
Available
DDD3
ER diagrams: cardinality and entity-occurrence diagrams
Showing how many records can take part in each relationship
Available
DDD4
Compound keys and data dictionaries
Defining fields, data types, keys, and table structure
Available
DDD5
Validation: presence check, restricted choice, field length, range
Reducing invalid data before it enters the database
Available
DDD6
Query design: tables, fields, criteria, sort, calculations, grouping
Planning queries to retrieve and process useful information
Available
DDD7
SQL: SELECT, WHERE, ORDER BY, wildcards
Retrieving and filtering records with SQL
Available
DDD8
SQL: aggregate functions, GROUP BY, computed values, aliases
Summarising and calculating values in query output
Available
DDD9
SQL: INSERT, UPDATE, DELETE
Changing database contents safely with action queries
Available
DDD10
DDD testing and evaluation
Checking queries, validation, and fitness for purpose
Available
DDD11
DDD past paper practice and unit test
Final consolidation and exam-style practice
Available