Section outline

    • Week 5 Book

      Teaching and Learning Methods to be Employed

      1.    Interactive lecture with live SQL demonstrations in MySQL

      2.    Hands-on SQL lab session — students write and execute queries

      3.    Pair programming: SQL query challenges

      4.    Real dataset exercise using Nigerian banking/demographic sample data

       

      Learning Outcomes / Objectives

      By the end of this week, students should be able to:

      1.    Write SQL DDL statements to create and alter tables.

      2.    Write SQL DML statements to insert, update, and delete data.

      3.    Write SQL SELECT queries with WHERE, ORDER BY, and LIMIT clauses.

      4.    Apply SQL aggregate functions (COUNT, SUM, AVG, MIN, MAX) with GROUP BY and HAVING.

      5.    Write SQL JOIN queries to combine data from multiple tables.

      6.    Write basic subqueries.

    • Course Discussion Forum
      Due: Thursday, 2 July 2026, 7:50 PM
      Not available unless: The activity Course Outline is marked complete