-
01: Introduction
-
Introduction to databases
-
Select statements
- 01: Introduction
-
-
02: Conceptual Database Design
-
Conceptual database design
-
Aggregate queries
- 02: Conceptual Design
-
-
03: Logical Database Design
-
Logical database design
-
Join queries
- 03: Logical Design
-
-
04: Enhanced ER diagrams
-
Enhanced ER Modelling
-
Multi-table and Outer Joins
- 04: Enhanced ER Diagrams
-
-
05: Normalisation
-
Normalisation
-
Data Manipulation
- 05: Normalisation 1
-
-
06: Advanced Normalisation
-
Normalisation example
-
Normalisation beyond 3NF
-
Data Definition
- 06: Normalisation 2
-
-
07: Physical Database Design
-
Conceptual and Logical recap
-
Physical database design
-
Subqueries and views
- 07: Physical Database Design
-
-
08: Security, Indexes and Triggers
-
Database Security
-
Indexes, Triggers, User and Privileges
- 08: Security, Indexes and Triggers
-
-
9: Database Concurrency
-
Transaction Management
-
MySQL Backup and Recovery
- 09: Database Concurrency
-
-
10: Backup and Recovery
-
Backup and Recovery
-
Installing MongoDB
- 10: Backup and Recovery
-
-
11: NoSQL 1
-
NoSQL Databases
-
MongoDB - Create
-
MongoDB - Read
- 11: NoSQL 1
-
-
12: NoSQL 2
-
Document-oriented modelling
-
MongoDB - Update
-
MongoDB - Delete
- 12: NoSQL 2
-
Assignment

This assignment is worth 50% of your grade for this module. The final assignment submission deadline is Sunday 10th December.
On-Site Workshop: June 15

In this section, you will get started with SQL through MySQL Workbench.
01: Introduction

In this section, we will introduce a number of database concepts and begin working with SQL.
02: Conceptual Database Design

In this section we will look at Conceptual Database Design and how to draw Entity Relationship diagrams.
03: Logical Database Design

In this section we will look at the Relational Model and mapping an ER diagram to a set of relations.
04: Enhanced ER diagrams

In this section we will look at the Enhanced ER diagrams and transforming them.
05: Normalisation

In this section we will look at the rules for First, Second, and Third Normal Form.
06: Advanced Normalisation

In this section we will look at the rules for Boyce-Codd, Fourth, and Fifth Normal Form.
07: Physical Database Design

In this section we will look at Physical Database Design.
08: Security, Indexes and Triggers

This section examines topics that relate to Database Security, and introduces the concepts of indexes and triggers in the labs.
9: Database Concurrency

In this section, we will discuss database concurrency and transaction management. In the lab, we will create a backup of a MySQL database.
10: Backup and Recovery

In this section we will discuss database backup and recovery. In the labs, we will install MongoDB.
11: NoSQL 1

In this section, we introduce the concepts relating to NoSQL (non-relational) databases.
12: NoSQL 2

This section examines document-oriented modelling. In the lab, we continue exploring MongoDB's CRUD functionality.
Review

In this section, we will recap the database concepts covered in this module.