This lecture introduces database concepts and terminology (link to video on title slide)

In this lecture we will introduce the SQL Select statement (link to video on title slide)

In this lecture you will learn about Entities, Entity Types, and Attributes

In this lecture you will learn about Relationships and Relationship Types

In this lecture you will learn about steps involved in Conceptual Database Design

In your own time draw an ER diagram for the scenarios

In this lecture we will look at the remainder of steps in Conceptual Database Design

In this lecture we will introduce SQL Aggregate Functions

In this lecture you will learn about the Relational Model

In this lecture you will learn about mapping ER diagrams to a set of relations.

Here we will step through transforming an ER diagram into a set ot relations

In your own time transform the ER diagrams into a set of relations

In this lecture we will look at the remainder of steps in Logical Database Design

In this lecture we will introduce the SQL JOIN statement

In this lecture you will learn about how to model and transform Weak Entity Types, Recursive Relationships, and Multivalued Attributes into a set of relations

In this lecture you will learn about how Semantic concepts are incorporated into the original ER model and called the Enhanced Entity-Relationship (EER) model.

Here we construct an Enhanced Entity Relationship (EER) Diagram for a given scenario and convert the EER diagram into a set of relations.

In this lecture we will look at the SQL JOIN statement for 3 or more tables and the Outer Join

In this lecture we will introduce what Normalisation is.

In this lecture we will look at the Process of Normalisation.

In this lecture we will look at First Normal Form.

In this lecture we will look at Second Normal Form.

In this lecture we will look at Third Normal Form.

In your own time complete the questions on Normalisation.

In this lecture we will look at Data Manipulation statements.

In this lecture we will look at converting an unnormalised relation into a set of 3NF tables.

In this lecture we will look at Boyce Codd Normal Form.

In this lecture we will look at Fourth Normal Form.

In this lecture we will look at Fifth Normal Form.

In this lecture we will look at Data Definition (Create, Alter, and Drop) statements.

In this lecture we will review the work done over the past few weeks.

In this lecture we describe a physical database design methodology for relational databases.

In this lecture we look at denormalisation, monitoring and tuning the operational system, and system efficiency.

In this lecture we will look at creating and manipulating Sub Queries and Views.

In this lecture we will examine issues that relate to Database Security.

This lecture introduces the concepts of indexes and triggers, and the related SQL syntax.

This lecture explains how we can create new users in our MySQL databases, and control those users' privileges.

In this lecture, we will discuss concepts that relate to concurrent database users and transaction management.

In this lecture, we will examine concepts that relate to database backup and recovery.

This lecture introduces MongoDB, the NoSQL database that we will use in forthcoming labs.

This lecture discusses concepts that relate to NoSQL (non-relational) databases.

In this lecture, we examine the operations used to create documents and collections in MongoDB.

This lecture examines the syntax of the find() operation used to read data in MongoDB.

These slides introduce the concept of document-oriented modelling.

In this lecture, we examine the syntax used for updates in MongoDB.

This lecture examines the delete operations in MongoDB.

This lecture reviews the database concepts covered in this module, in preparation for the final exam.

This sample exam paper reflects the content covered in the final exam.