Public Sector Database Records and Retention Training Course

Course overview

Public-sector databases often hold case files, licensing data, benefits records, regulatory evidence, correspondence metadata and operational transactions long after their immediate business use has ended. Teams must keep these records reliable, searchable and protected while applying retention schedules, disposal holds, access controls and audit requirements consistently. Poorly designed retention rules create two costly failures: information is destroyed before its authorised disposal date, or sensitive and obsolete data remains in live systems indefinitely, increasing disclosure, cyber-security and litigation risk.

This course equips participants to design and operate defensible database records and retention controls across public-sector environments. Participants examine how to distinguish records from transient data; map database entities and fields to business classifications; translate retention schedules into system rules; apply event-based retention triggers; manage legal holds; and document appraisal, transfer, archival and disposal decisions. Practical work covers SQL-based record identification, metadata design, retention-rule configuration principles, audit logging, data-quality controls, and evidence required to defend disposal decisions.

Teaching combines instructor-led demonstrations, public-sector case studies, database design workshops and guided exercises using PostgreSQL, Microsoft SQL Server and Microsoft Purview Records Management concepts. Participants work through a realistic service database containing citizen, case, document and transaction data. They leave with a completed records-retention control pack: a data inventory, retention mapping matrix, trigger specification, hold process, disposal approval workflow and implementation action plan that can be adapted to their own authority or agency.

The course is designed for database, information governance, records management, digital transformation and compliance professionals who already work with structured public-sector information and need to make retention operational rather than merely policy-based.

Course objectives

By the end of this course, participants will be able to:

• Classify database tables, fields and generated documents as records, supporting information or transient operational data
• Map business functions and record series to database entities using a retention mapping matrix
• Define event-based retention triggers, including case closure, contract expiry, supersession and final action dates
• Configure a logical retention-rule specification with disposition dates, holds, exceptions and approval states
• Write SQL queries to identify record populations due for review, transfer, deletion or sampling
• Design metadata fields that support provenance, classification, access decisions, retention calculation and audit evidence
• Apply legal-hold and information-request controls that suspend automated disposition without losing traceability
• Produce a defensible database records-retention control pack for a selected public-sector service

Benefits of attending

Target competencies

Who should attend

• Database Administrators — who must translate retention and disposal requirements into reliable database controls
• Records Managers — who need to apply records schedules to structured data rather than document repositories alone
• Information Governance Managers — who oversee retention compliance, information risk and accountable disposal decisions
• Data Architects — who design data models and metadata structures for public services
• Digital Transformation and Service Managers — who modernise case-management systems while preserving recordkeeping obligations
• Compliance, Audit and Data Protection Officers — who test whether database retention controls are evidenced and defensible

Requirements and prerequisites

Participants should have practical familiarity with relational databases, including tables, primary keys, relationships, queries and basic SQL filtering. They should understand the purpose of records retention schedules and have some exposure to their organisation's information governance, records management, privacy or audit processes. Experience with PostgreSQL, Microsoft SQL Server or another SQL database is useful, but advanced administration, programming and data engineering are not required. The course does not assume knowledge of a particular national archives framework or jurisdiction-specific retention law; participants work with adaptable control methods and should bring examples of their own schedules where permitted.

Training methodology

The instructor uses a simulated public-service case-management database throughout the week, moving from policy interpretation to technical control design. Short teaching sessions introduce records concepts, SQL techniques, metadata patterns and disposition governance; guided labs then require participants to inspect schemas, query record populations and write rule specifications. Small groups resolve contested scenarios involving closed cases, appeals, information requests and system migration. Each participant develops an application plan and receives structured feedback on their retention mapping matrix and disposal-control design.

Course outline

Day 1: Records in public-sector database systems

• Public-sector recordkeeping obligations for structured operational data
• Distinguishing authoritative records, working data, reference data and system logs
• Database record lifecycles across case-management and line-of-business systems
• Business function analysis and record-series classification
• Relational data model review: entities, keys, relationships and transaction histories
• Provenance, authenticity, reliability and integrity metadata
• ISO 15489-1 principles applied to database-held records

Workshop: Participants analyse a sample public-service schema and produce a record-status classification for its tables, fields and generated documents.

Day 2: Retention schedules and rule design

• Reading retention schedules as operational control requirements
• Retention mapping matrices linking functions, record series and database entities
• Fixed-term, event-based and review-based retention models
• Trigger dates based on closure, final action, expiry, supersession and death of subject
• Retention exceptions for appeals, investigations and unresolved obligations
• Disposition states, approval gates and segregation of duties
• Retention requirements for replicated, exported and reporting datasets

Workshop: Participants build a retention mapping matrix and event-trigger specification for a licensing and enforcement service.

Day 3: Metadata, querying and lifecycle automation

• Retention metadata fields and controlled value lists
• Designing classification codes, trigger dates and calculated disposal dates
• SQL SELECT, JOIN, WHERE and date functions for retention reporting
• Identifying orphaned records, incomplete metadata and inconsistent classifications
• PostgreSQL views for retention review populations
• Microsoft SQL Server stored procedures and scheduled retention checks
• Audit logging for rule changes, review actions and disposition decisions

Workshop: Participants write and test SQL queries that identify closed cases due for review while flagging missing trigger dates and incomplete approvals.

Day 4: Holds, disposal and defensible governance

• Legal holds and preservation notices in structured databases
• Suspending automated disposition while retaining normal retention calculations
• Information-access requests, investigations and audit exceptions
• Secure deletion, logical deletion, anonymisation and archival transfer decisions
• Disposal certificates, authorisation records and evidential audit trails
• Microsoft Purview Records Management labels and disposition-review concepts
• Risk assessment for vendor-hosted and cloud database retention controls

Workshop: Teams resolve a legal-hold scenario and produce a hold register entry, exception workflow and documented disposition decision.

Day 5: Implementation, assurance and improvement planning

• Assessing current-state retention maturity in operational databases
• Control testing for retention rules, holds, access and audit logs
• Sampling methods for validating disposition populations
• Data migration, decommissioning and legacy-system retention planning
• Supplier requirements for configurable retention and exportable audit evidence
• Roles, escalation paths and governance reporting for database disposition
• Ninety-day roadmap for retention remediation and implementation

Workshop: Participants complete and present a database records-retention control pack and 90-day implementation plan for their chosen service scenario.

Tools & standards covered

PostgreSQL, Microsoft SQL Server, Microsoft Purview Records Management, ISO 15489-1:2016

A typical training day

Live online deliveries follow the same structure in the East Africa Time zone, with shorter screen blocks and longer breaks.

What the fee includes

How you can take this course

Certification

Participants who complete the full five days receive the Skillset Development Certificate of Completion, stating the course title, course code, dates and delivery format — suitable for professional-development records and employer reimbursement.

Frequently asked questions