This module will introduce the learner to the basic concepts in the theory, design and implementation of relational databases and how it fits into the area of information management. The student will learn basic database design techniques and will gain expertise in the main constructs of SQL. Students will be introduced to cloud-based databases and will learn how to connect to a cloud-based relational database, and run SQL queries in the cloud.
Introduction to Databases
Database approach, Roles in the database environment. Functions of a DBMS, Components of a database system, Retrieval of data, Creation of links between tables
Database Design: Introduction to ER Modelling
Basic Modelling concepts, The ER model: attributes & relationships, application of business rules
Data Manipulation
Simple select queries, Nested queries, Aggregate functions, Group-by operator , Table Joins.
Data Definition
Data definition commands, Understanding datatypes, Creating table structures, Basic SQL constraints.
Cloud-based Databases
Introduction to cloud-based databases, Connecting to a cloud-based database, SQL queries in the cloud
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 100 |