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