PostgreSQL SQL Foundations for Data & Applications in Uganda

Course outline and learning expectations

This is a tutor-led course. The outline shows what your tutor will cover; teaching materials and examinations are provided directly to enrolled students.

What you will learn

• Explain relational database and PostgreSQL concepts
• Install and navigate PostgreSQL tools
• Create databases, schemas and tables
• Write SELECT, INSERT, UPDATE and DELETE statements
• Filter, sort and aggregate business data
• Combine tables with joins
• Apply keys and data constraints
• Build a complete small database project

Modules

1. 1

   PostgreSQL and relational database foundations

   Understand how databases organise reliable information

   Database conceptsPostgreSQL use casesTables rows and relationshipsClient-server basics
2. 2

   Installing PostgreSQL and using database tools

   Set up a practical PostgreSQL learning environment

   PostgreSQL installationpgAdmin navigationpsql introductionCreating a first database
3. 3

   Tables, data types and data integrity

   Build structured tables for real organisational data

   CREATE TABLECommon PostgreSQL data typesPrimary and foreign keysNOT NULL UNIQUE and CHECK constraints
4. 4

   Core SQL data operations

   Add, retrieve and maintain records safely

   SELECT statementsINSERT statementsUPDATE statementsDELETE statements
5. 5

   Filtering, sorting and useful expressions

   Answer everyday business questions with SQL

   WHERE conditionsORDER BYLIMIT and OFFSETAliases and calculated columnsNULL handling
6. 6

   Aggregations and reporting queries

   Summarise operational data for decisions

   COUNT SUM AVG MIN and MAXGROUP BYHAVINGDate and text functionsBasic reports
7. 7

   Joining related tables

   Combine data across customers, services, payments and activities

   INNER JOINLEFT JOINMultiple-table joinsAvoiding duplicate results
8. 8

   Applied PostgreSQL database project

   Create a portfolio-ready database for an African organisation

   Requirements and data modelDatabase implementationBusiness queries and reportsTesting and project presentation