Portfolio Projects
CV-ready, instructor-reviewed deliverables on regulated UK data. Add a sector standalone or take the trilogy to cover three sectors at a saving.
What you get
Real Regulated-Sector DataAcceptance CriteriaGraded SlicesInstructor Review (10 working days)LinkedIn-ready SummaryTrilogy Discount (16% off any 3)Certificate on Completion.
- Trilogies
- 6
- Standalones
- 18
- Trilogy saving
- 16%
Trilogy Projects(3)
A Trilogy is three portfolio projects bundled together — one in each of three different regulated sectors (e.g. NHS, energy, retail) — all at the same level. You build all three, an instructor reviews each one, and your final LinkedIn-ready summary covers the full breadth. Save about 16% versus buying the three standalones separately, and earn a completion bonus when you pass all three. Pick this if you want a CV that shows you can deliver across industries, not just one.
SQL Applied Portfolio Trilogy
All three SQL Applied capstones — clinical data quality, customer-billing data quality, parcel-network data quality. Investigation Framework discipline across three regulated UK sectors, three reusable audit-card Views. Save £78 vs buying standalones individually.
View details →SQL Core Portfolio Trilogy
All three SQL Core capstones across regulated UK sectors — NHS Patient Snapshot, energy Meter Read Snapshot, parcel Shipment Volume Snapshot. Same assessor pool reviews all three. LinkedIn-ready portfolio summary on completion. Save £48 vs buying standalones individually.
View details →SQL Pro Portfolio Trilogy
All three SQL Pro analytics engines — Clinical Analytics, Customer Insight, Network Analytics. Recursive CTEs, parameterised stored procedures, window-function segmentation, idempotent pipelines, gap detection, performance rewrites across all three regulated UK sectors. LinkedIn-ready portfolio summary including architecture write-up. Save £148 vs buying standalones individually.
View details →Individual Projects(9)
An Individual Project is one portfolio project in one regulated sector — buy it on its own and submit when you're ready. You get the same real dataset, acceptance brief, and instructor-written review (within 10 working days; 15 for Professional) that ships with a Trilogy. Choose this if you're targeting a specific industry on your CV, or you want to start small. Cards flagged with a Trilogy link can save you ~16% when bundled with two more sectors.
EnergyLT Applied — Standalone
Twelve-output Customer & Billing Data Quality Audit across the full EnergyLT schema. Referral chains, debt-ageing FULL OUTER JOIN, contract-continuity checks, and a reusable vw_CustomerAuditCard View. 30-minute live code review.
View details →LogisticsLT Applied — Standalone
Twelve-output Network Data Quality Audit across the full LogisticsLT schema. Depot-hub orphan detection, shipment-event sequence checks, SLA breach attribution, and a reusable vw_ShipmentAuditCard View. 30-minute live code review.
View details →PatientLT Applied — Standalone
Twelve-output Clinical Data Quality Audit across the full PatientLT schema. Investigation Framework discipline, the four investigation patterns (orphan / duplicate / missing / reconciliation), and a reusable vw_PatientAuditCard View. 30-minute live code review.
View details →EnergyLT Core — Standalone
Single-table Meter Read Snapshot capstone. Eight outputs against EnergyLT.MeterReading covering actual-vs-estimated splits, monthly consumption trends, failed-read audit, and a single-row completeness dashboard. Assessor-led defence on completion.
View details →LogisticsLT Core — Standalone
Single-table Shipment Volume Snapshot capstone. Eight outputs against LogisticsLT.Shipment covering status mix, weight-band CASE distributions, SLA breach DATEDIFF, daily creation trend, and an unassigned-shipment audit. Assessor-led defence on completion.
View details →PatientLT Core — Standalone
Single-table NHS Patient Snapshot capstone. Eight Board-ready outputs against PatientLT.Patient — GROUP BY, CASE, DATEDIFF, NULL-safe full-name concatenation, UNION ALL summary, single-row completeness audit. Assessor-led defence on completion.
View details →EnergyLT Pro — Standalone
Seven-pane Customer Insight Engine — referral-tree recursive CTE, parameterised stored procedure, NTILE/RANK/ROW_NUMBER segmentation, NetCashPosition running balance, retention priority list, silent-meter detection, and a performance rewrite. 45-minute code-review defence.
View details →LogisticsLT Pro — Standalone
Seven-pane Network Analytics Engine — depot-hierarchy recursive CTE, parameterised stored procedure, weight-band quartile segmentation, NetPending running balance, top-route SLA positioning, LAG-based stuck-parcel detection, and a performance rewrite. 45-minute code-review defence.
View details →PatientLT Pro — Standalone
Seven-pane Clinical Analytics Engine — Views, recursive CTEs, parameterised stored procedure, window functions, idempotent temp-table pipeline, subquery-vs-CTE comparison, LAG-based 30-day readmission detection, and a performance rewrite. 45-minute code-review defence.
View details →