MODULE DETAILS

 

Module 19: SQL Databases

 

Nominal duration: 3 weeks (24 hours total time commitment).

 

This time commitment includes the preparation reading, attendance at each webinar (1 hour plus 15-30 minutes for discussion), and the time necessary to complete the assignments and further study.

 

MODULE PURPOSE

 

SQL forms the cornerstone of all relational database operations. The ability to write the SQL language is essential for those who develop database applications. This module provides a solid foundation of the SQL programming language that enables students to build, query and manipulate databases.

 

PRE-REQUISITE MODULES, UNITS

/CO-REQUISITES

 

None

 

ASSESSMENT STRATEGY

 

To evaluate the achievement of the learning outcomes; written assignments, group projects and practical exercises are set.

 

SUMMARY OF LEARNING OUTCOMES

 

1.      Examine and discuss the fundamentals of SQL

 

2.      Demonstrate the ability to modify table contents

 

3.      Demonstrate the ability to construct nested queries

 

 



Learning Outcome 1

 

Examine and discuss the fundamentals of SQL

 

Assessment Criteria

 

1.1   Examine and discuss the fundamentals of SQL, with emphasis on:

(a)    SQL as the basis of database activity

(b)    Relevant ANSI/ISO standards

(c)    Fundamental building blocks

(d)    Terminology

 

 



Learning Outcome 2

 

Demonstrate the ability to modify table contents

 

Assessment Criteria

 

2.1 Modify table contents by performing the following:

       (a)   Adding, removing and restricting rows

       (b)   Writing and retrieving data

       (c)   Performing queries

       (d)   Sorting results

       (e)   Handling NULL values in expressions and filter        conditions

 

 



Learning Outcome 3

 

Demonstrate the ability to construct nested queries

 

Assessment Criteria

 

3.1 Explain the difference between correlated and non-correlated sub-queries

 

 

3.2 Test for the existence of rows

 

 

3.3 Apply sub-queries under various conditions

 

 


Delivery mode

A combination of asynchronous and synchronous e-learning delivery comprising a judicious mix of interactive online web conferencing, simulation (virtual labs) software, remote online labs, online videos, PowerPoints, notes, reading and study materials (in PDF, HTML and Word format) accessed through the Moodle Learning Management System (LMS).

Software/Hardware Used

Software

  • MySQL

  • Add-Ons: optional, any DEMS

Hardware

  •  N/A