Skip to content

Risk Academy · Programme outline

SQL and Data Engineering for Risk

Relational modelling, SQL and pipeline engineering for risk data, with lineage, quality and governance.

outline. not open for enrolmentintermediate · 44 planning hours · prerequisites: none

Learning outcomes

  • 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

  1. Relational modelling
    Topics: entities, keys, normalisation, constraints.
    Lab: Design a loss-event schema. Assessment: Schema review.
  2. Analytical SQL
    Topics: joins, aggregation, window functions, CTEs.
    Lab: Rank exposure by hazard zone. Assessment: Graded query set.
  3. Performance and plans
    Topics: indexes, query plans, partitioning.
    Lab: Speed up a slow exposure query. Assessment: Short applied task.
  4. Pipelines
    Topics: batch and incremental loads, idempotence, orchestration, tests.
    Lab: Build a tested load of an open hazard dataset. Assessment: Code review.
  5. 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.

Çavkanî