-
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
As your continuous assessment for this module, you are required to design and develop a database using MySQL.
Installation
In this lab, you will install MySQL and log in to MySQL Workbench.
SQL Introduction
In this lab we will become familiar with using MySQL Workbench.
SQL 1
In this lab we will learn about the basics of SQL and learn about the SELECT statement
SQL 2
In this lab we will learn about Aggregate Functions.
SQL 3
In this lab, we will use the Select statement to retrieve data from two tables.
SQL 4
In this lab, we will use the Select statement statement to look at multi table and outer Joins.
Lab-01 SQL 5
In this lab, we will look at Data Manipulation.
Lab-01 SQL 6
In this lab, we will look at Data Definition.
Lab-01 SQL 7
In this lab, we will look at Sub Queries and Views.
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.
Backup and Restore
In this lab, we will look at database backup and recovery in MySQL Workbench.
Install MongoDB
In this lab, we will install and test MongoDB, a non-relational database.
Create
This lab introduces the CREATE functions in MongoDB.
Read (find)
In this lab, we will explore the find() statement in MongoDB, including a range of operators used to filter query results.
Update
This lab examines the methods used for updating documents in MongoDB.
Delete
In this lab, we examine the MongoDB methods using for deleting documents from a collection.