Oracle Database, SQL & PL/SQL

Develop and administer enterprise database solutions using Oracle SQL and PL/SQL foundations.

Part of these pathways

Data and databases

Course outline: enrolment opens after THNF content and assessment review.

What you will be able to do

Clear outcomes. Practical evidence.

Use Oracle SQL effectively
Create PL/SQL program units
Manage transactions and exceptions
Understand enterprise database operations

Course structure

Modules and lessons

Enterprise database programming

Use Oracle database features for dependable data services.

Oracle SQL and data integrity25 min
PL/SQL procedures and exceptions25 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 8 GB RAM and 60 GB free, or use the managed lab device 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 data assistant
Database-support assistant
Reporting and information assistant

Possible progression pathways

Data and databases