-
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
-
08: Security, Indexes and Triggers
Database Security
Database Security

In this lecture we will examine issues that relate to Database Security.
Indexes, Triggers, User and Privileges
Indexes and Triggers

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

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

In this lab, we will look at creating Indexes, Triggers, and Users. We will also look at granting access to users.