Course Introduction
Programme monitoring databases store valuable information about project activities, beneficiaries, service delivery, geographical coverage, indicator performance and implementation progress. However, the usefulness of these systems depends on the ability of programme teams to retrieve accurate, relevant and timely information. SQL, or Structured Query Language, enables users to query relational databases systematically without relying entirely on manual spreadsheet exports. This course introduces SQL as a practical tool for extracting, filtering, combining and summarizing monitoring information to support evidence-based programme management, reporting and decision-making.
The course begins with the fundamentals of relational databases, including tables, records, columns, primary keys, foreign keys and relationships between datasets. Participants explore how monitoring systems may organize beneficiaries, projects, activities, locations, indicators and reporting periods across interconnected tables. They learn to interpret basic database schemas, identify relevant fields and understand how table relationships influence query results. This foundation helps participants formulate accurate queries and avoid common mistakes, such as counting the same beneficiary multiple times or combining unrelated records when extracting programme information.
A major component of the training focuses on writing SQL queries to retrieve and filter monitoring records. Participants practise using SELECT statements, column aliases, DISTINCT, WHERE conditions, comparison operators, logical expressions, sorting and result limits. These techniques enable users to extract records for specific projects, implementation locations, reporting periods or beneficiary categories. The training also introduces practical approaches to filtering dates, handling NULL values and applying multiple conditions, helping participants answer routine monitoring questions while retrieving only the information required for a particular reporting or analytical task.
The programme develops skills in combining information across related database tables using INNER JOIN, LEFT JOIN and other commonly used join types. Participants learn how to connect beneficiary records with programme participation, activity monitoring, location reference data and indicator tables. They examine the importance of matching keys, understanding one-to-many relationships and checking whether joins create unexpected increases in record counts. Practical exercises demonstrate how to identify unmatched records, reconcile results and maintain a clear understanding of the unit of analysis, supporting more reliable consolidation of monitoring information from multiple database sources.
Participants also learn to summarize monitoring information through aggregate functions and grouped queries. They practise using COUNT, SUM, AVG, MIN and MAX alongside GROUP BY and HAVING to calculate totals, averages and performance summaries by project, partner, location, indicator or reporting period. The course introduces CASE expressions, subqueries and common table expressions for organizing more complex analytical tasks. Participants learn how to prepare query outputs for dashboards, indicator tracking tables and management reports, while recognizing the importance of appropriate denominators, missing values and consistent indicator definitions when interpreting results.
The final component emphasizes query accuracy, responsible access and practical application to programme monitoring workflows. Participants practise checking output counts, comparing query results against known totals, identifying duplicate records and reviewing the effect of filters and joins on reported findings. They also learn introductory techniques for improving query readability, understanding database permissions and minimizing unnecessary exposure of personal information. Through a practical capstone, participants develop a set of reusable SQL queries that answer realistic monitoring questions and produce structured outputs for reporting, programme review and evidence-informed decision-making.
Duration
5 days
Who Should Attend
-
Monitoring, Evaluation, Accountability and Learning (MEAL) officers who retrieve information from programme databases.
-
Monitoring and evaluation specialists responsible for preparing indicator summaries and performance reports.
-
Programme data officers working with relational databases and structured reporting systems.
-
Information management officers consolidating data across projects, partners and implementation locations.
-
Database users who need to extract monitoring records without manually exporting entire tables.
-
Data analysts preparing programme monitoring summaries and management information reports.
-
Programme managers who want to understand how monitoring data can be queried and summarized.
-
Reporting officers responsible for monthly, quarterly and annual programme reporting.
-
Research officers working with structured administrative and programme datasets.
-
Monitoring coordinators overseeing activity records and implementation progress.
-
Data quality assurance officers checking the completeness and consistency of database outputs.
-
Accountability officers querying feedback, complaints and response-tracking records.
-
Humanitarian information management staff working with structured operational databases.
-
Public health monitoring personnel analyzing service-delivery and programme activity records.
-
Education, livelihoods and social development practitioners using database-backed monitoring systems.
-
Business intelligence and dashboard developers who prepare source datasets for reporting tools.
-
Excel users transitioning from spreadsheet-based data extraction to SQL querying.
-
Technical and programme staff supporting monitoring information system implementation.
-
Consultants who need practical SQL skills for programme reviews and evaluation assignments.
Course Objectives
-
Explain relational database concepts, table structures, keys and relationships relevant to programme monitoring and reporting systems.
-
Navigate a database schema and identify the tables, columns and relationships required to answer specific monitoring and management questions.
-
Write SELECT queries to retrieve relevant fields and records using column aliases, DISTINCT, sorting and result limits.
-
Apply WHERE conditions, comparison operators, logical expressions and date filters to extract monitoring data for defined projects, locations and reporting periods.
-
Combine related database tables using appropriate joins and matching keys while checking unmatched records and unintended duplication.
-
Use aggregate functions, GROUP BY and HAVING to calculate monitoring totals, averages and performance summaries by relevant programme dimensions.
-
Apply CASE expressions, subqueries and common table expressions to organize queries for more complex monitoring and reporting requirements.
-
Identify common data-quality issues in query results, including NULL values, duplicate observations, inconsistent keys and unexpected record counts.
-
Develop readable, reusable and efficient SQL queries while respecting database permissions, confidentiality requirements and approved data-access procedures.
-
Produce a practical collection of validated SQL queries that answer routine programme monitoring questions and generate outputs suitable for reporting and analysis.
Comprehensive Course Outline
Module 1: Introduction to SQL and Programme Monitoring Databases
-
Explain the role of SQL in retrieving and summarizing information from monitoring information systems and relational programme databases.
-
Explore relational database concepts, including tables, rows, columns, primary keys, foreign keys and relationships between datasets.
-
Interpret a sample monitoring database schema containing projects, beneficiaries, activities, locations, indicators and reporting periods.
-
Translate routine monitoring questions into query requirements by identifying the required fields, filters, relationships and expected outputs.
Module 2: Basic SQL Queries and Data Retrieval
-
Write SELECT statements to retrieve specified columns from monitoring tables and use aliases to create clear, report-friendly output headings.
-
Apply DISTINCT to identify unique projects, locations, partners, indicator codes or beneficiary categories within a dataset.
-
Use ORDER BY to sort records by date, location, performance value or other relevant monitoring fields.
-
Apply TOP, LIMIT or equivalent platform-specific syntax to inspect sample records and understand how result limits differ across database systems.
Module 3: Filtering Records and Applying Conditions
-
Use WHERE clauses to retrieve records that match specified project codes, implementation locations, status categories and reporting periods.
-
Apply comparison operators, AND, OR, NOT and parentheses to construct accurate filters for multi-condition monitoring questions.
-
Filter records by date ranges, numeric thresholds and text patterns using appropriate date and string comparison techniques.
-
Handle NULL values using IS NULL and IS NOT NULL and understand why missing information requires different treatment from zero or blank text.
Module 4: Joining Related Monitoring Tables
-
Use INNER JOIN to retrieve records that have matching keys across related programme tables.
-
Apply LEFT JOIN to retain records from a primary table while identifying missing matches in a related reference or reporting table.
-
Join beneficiary, activity, project, location and indicator datasets using appropriate primary and foreign key relationships.
-
Validate join results by comparing row counts, checking key uniqueness and investigating unexpected duplication or unmatched records.
Module 5: Aggregate Functions and Monitoring Summaries
-
Apply COUNT, SUM, AVG, MIN and MAX to summarize monitoring records and calculate basic measures of programme activity and performance.
-
Use GROUP BY to generate totals and summaries by project, partner, location, indicator or reporting period.
-
Apply HAVING to filter aggregated results, such as locations with activity totals below an agreed threshold or partners with specified record counts.
-
Interpret aggregation results carefully by identifying the unit of analysis, handling missing values and distinguishing unique beneficiaries from activity records.
Module 6: Conditional Logic and Derived Monitoring Indicators
-
Use CASE expressions to classify records into meaningful categories such as completed, pending, overdue or requiring follow-up.
-
Create derived fields for reporting periods, performance categories and other measures using supported SQL expressions.
-
Apply conditional aggregation to calculate selected counts or totals for different statuses within the same reporting group.
-
Document calculation logic and compare derived indicator values against approved definitions and expected reporting rules.
Module 7: Subqueries, Common Table Expressions and Set Operations
-
Use subqueries to filter records based on results from other queries, such as projects that meet specified performance or participation criteria.
-
Create common table expressions using WITH to organize multi-step query logic into readable and maintainable components.
-
Apply UNION and UNION ALL to combine compatible result sets from different reporting sources while understanding their treatment of duplicate rows.
-
Compare query outputs using set operations where supported and identify records that appear in one reporting dataset but not another.
Module 8: Data Quality Checks and Query Validation
-
Identify duplicate records, missing identifiers, invalid categories and unexpected date values through targeted SQL quality-control queries.
-
Reconcile record counts and summary totals against source tables, approved reports or known reference values.
-
Investigate the effects of filters, joins and aggregation on row counts and identify common causes of inconsistent results.
-
Build validation queries that flag incomplete submissions, unmatched reference records and monitoring observations requiring further review.
Module 9: Query Readability, Performance and Responsible Access
-
Structure queries with consistent indentation, descriptive aliases and clear formatting to improve readability and team review.
-
Learn introductory performance principles, including selecting only required columns, filtering early where appropriate and understanding the role of indexes.
-
Review execution plans at an introductory level where supported and identify when complex joins or broad scans may affect query performance.
-
Apply least-privilege access, approved database connections and data-minimization practices when querying confidential beneficiary or programme records.
Module 10: Practical SQL for Programme Monitoring and Reporting
-
Develop queries to retrieve monitoring records for a selected project, location and reporting period from a sample relational database.
-
Join activity, indicator, partner and location tables to produce a consolidated dataset for programme performance review.
-
Calculate grouped totals, status summaries and selected indicator measures, then validate the outputs against source records.
-
Compile a reusable SQL query portfolio with documented assumptions, validation checks and outputs designed for routine monitoring reports or dashboards.
Training Approach
This course will be delivered by our skilled trainers who have vast knowledge and experience as expert professionals in the fields. The course is taught in English and through a mix of theory, practical activities, group discussion and case studies. Course manuals and additional training materials will be provided to the participants upon completion of the training.
Tailor-Made Course
This course can also be tailor-made to meet organization requirement. For further inquiries, please contact us on: Email: training@upskilldevelopment.com Tel: +254 721 331 808
Training Venue
The training will be held at our Upskill Training Centre. We also offer training for a group (at a discount of 10% to 50%) at requested location all over the world. The Onsite course fee covers the course tuition, training materials, two break refreshments, buffet lunch, airport transfers, Upskill gift package, and guided tour.
Visa application, travel expenses, dinners, accommodation, insurance, and other personal expenses are catered by the participant
Certification
Participants will be issued with Upskill certificate upon completion of this course.
Airport Pickup and Accommodation
Airport pickup and accommodation is arranged upon request. For booking contact our Training Coordinator through Email: training@upskilldevelopment.com, +254 721 331 808
Terms of Payment:
Unless otherwise agreed between the two parties’ payment of the course fee should be done 3 working days before commencement of the training so as to enable us to prepare better.








