Risk Academy · Programme outline
SQL and Data Engineering for Risk
Relational modelling, SQL and pipeline engineering for risk data, with lineage, quality and governance.Результаты обучения
- Model hazard, exposure, vulnerability and loss data relationally with keys and constraints.
- Write analytical SQL with joins, window functions and common table expressions, and read a query plan.
- Build an idempotent batch pipeline with tests, data-quality checks and lineage.
- State the licence, provenance and retention of every dataset a pipeline loads.
Existing course sources: technology-and-data, risk-data-governance.
New course outlines: SQL for Risk Analysts; Data Engineering for Risk.
Modules, labs and assessments
- Relational modelling
Topics: entities, keys, normalisation, constraints.
Lab: Design a loss-event schema. Assessment: Schema review. - Analytical SQL
Topics: joins, aggregation, window functions, CTEs.
Lab: Rank exposure by hazard zone. Assessment: Graded query set. - Performance and plans
Topics: indexes, query plans, partitioning.
Lab: Speed up a slow exposure query. Assessment: Short applied task. - Pipelines
Topics: batch and incremental loads, idempotence, orchestration, tests.
Lab: Build a tested load of an open hazard dataset. Assessment: Code review. - Quality
Topics: data contracts, lineage, licences, retention.
Lab: Document a dataset's provenance. Assessment: Governance memo.
Capstone and credential
A tested pipeline that loads an open dataset into a documented schema with quality checks, lineage and a licence note.
Completion earns a completion record and an achievement badge through the NXS Passport. It records that the learner finished the programme's assessed work. It does not certify competence and is not an accreditation.