← Course catalogue

DBS-105Foundation

Databases

SQLite for Offline Applications

Use a small, dependable embedded database for desktop, mobile and offline-first applications.

Part of these pathways

Next delivery

16 November 2026 – 11 December 2026

Teaching days: Monday–Thursday
Time: 13:30–16:30
Mode: Hybrid / Remote
Enrolment: Open for enrolment

What you will be able to do

Clear outcomes. Practical evidence.

Create SQLite schemas
Use transactions and constraints
Plan migrations
Protect local application data

Course structure

Modules and lessons

Data without a server

Explain when an embedded database is a better fit than a remote service.

Data without a server45 min

Tables, fields, records and data types

Model a small real-world process as tables with appropriate columns and types.

Tables, fields, records and data types45 min

Creating SQLite databases and schemas

Create a schema with keys, required fields, defaults and useful constraints.

Creating SQLite databases and schemas45 min

Adding, reading, updating and deleting data

Perform CRUD safely and verify the intended rows changed.

Adding, reading, updating and deleting data45 min

Filtering, sorting and aggregate queries

Turn stored records into useful, verifiable summaries.

Filtering, sorting and aggregate queries45 min

Relationships, joins and data integrity

Query related tables while preserving valid relationships.

Relationships, joins and data integrity45 min

Using SQLite safely from Python

Use Python's sqlite3 module with parameters, transactions and controlled error handling.

Using SQLite safely from Python45 min

Capstone offline data application

Deliver and justify a resilient, privacy-conscious offline application.

Capstone offline data application45 min

Access and progression

Know what the course requires.

The required capability matters; the learner does not have to personally own every device.

Who it is for

Aspiring developers, technical learners, career changers and practitioners seeking applied computing skills.

Hardware access

Personal 64-bit computer with 4 GB RAM and 20 GB free, or use the required device and software at a readiness-approved THNF centre.

Software and practical access

Course software is available through the text-first pack, an approved offline installer or a readiness-approved THNF centre.

Possible progression

Junior development, data, web, application-support or technical-project progression appropriate to the completed portfolio.

Progression is not a guarantee of employment or external certification.

Sierra Leone context

Mobile-first, low-data solutions for Sierra Leonean schools, traders, transport, agriculture, NGOs and SMEs using synthetic local names, districts and NLe values.

Skills in context

Career directions and next steps

These are realistic directions that the skills can support—not promises of employment, job titles or external certification.

Junior front-end developer
Web-content assistant
Freelance website builder
Junior software developer
Application-support assistant
Software-testing assistant
Junior data assistant
Database-support assistant
Reporting and information assistant

Possible progression pathways

Beginner to intermediate web developer · Programming and software engineering · Data and databases