Week 5
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.
5.1 SQL Overview
SQL (Structured Query Language) is the standard language for communicating with relational database management systems. It was developed at IBM in the 1970s based on Codd's relational model. SQL is declarative, you specify WHAT data you want, not HOW to retrieve it.