• Assignment
  • Assignment

• On-Site Workshop: June 15
  • Installation
  • SQL Introduction

• 01: Introduction
  • Introduction to databases
    Module Overview
    Introduction to Databases
  • Select statements
    SQL
    SQL 1
  • 01: Introduction

• 02: Conceptual Database Design
  • Conceptual database design
    Entities, Entity Types, and Attributes
    Relationships and Relationship Types
    Conceptual Database Design 1
    Exercises
    Conceptual Database Design 2
  • Aggregate queries
    SQL
    SQL 2
  • 02: Conceptual Design

• 03: Logical Database Design
  • Logical database design
    Relational Model
    Logical Database Design 1
    Worked Example
    Exercises
    Logical Database Design 2
  • Join queries
    SQL
    SQL 3
  • 03: Logical Design

• 04: Enhanced ER diagrams
  • Enhanced ER Modelling
    Advanced ER Modelling
    Enhanced Entity-Relationship Modelling
    Worked Example
  • Multi-table and Outer Joins
    SQL
    SQL 4
  • 04: Enhanced ER Diagrams

• 05: Normalisation
  • Normalisation
    Normalisation
    The Process of Normalisation
    First Normal Form
    Second Normal Form
    Third Normal Form
    Exercises
  • Data Manipulation
    SQL
    Lab-01 SQL 5
  • 05: Normalisation 1

• 06: Advanced Normalisation
  • Normalisation example
    Normalisation (unnormalised to 3NF)
  • Normalisation beyond 3NF
    Boyce Codd Normal Form
    Fourth Normal Form
    Fifth Normal Form
  • Data Definition
    SQL
    Lab-01 SQL 6
  • 06: Normalisation 2

• 07: Physical Database Design
  • Conceptual and Logical recap
    Conceptual and Logical Database Design Recap
  • Physical database design
    Physical Database Design for Relational Databases
    Monitoring and Tuning the Operational System
  • Subqueries and views
    SQL
    Lab-01 SQL 7
  • 07: Physical Database Design

• 08: Security, Indexes and Triggers
  • Database Security
    Database Security
  • Indexes, Triggers, User and Privileges
    Indexes and Triggers
    Users and Privileges
    Lab-01 SQL 8
  • 08: Security, Indexes and Triggers

• 9: Database Concurrency
  • Transaction Management
    Transaction Management
  • MySQL Backup and Recovery
    Backup and Restore
  • 09: Database Concurrency

• 10: Backup and Recovery
  • Backup and Recovery
    Backup and Recovery
  • Installing MongoDB
    MongoDB installation
    Install MongoDB
  • 10: Backup and Recovery

• 11: NoSQL 1
  • NoSQL Databases
    NoSQL Databases
  • MongoDB - Create
    Create in MongoDB
    Create
  • MongoDB - Read
    Read in MongoDB
    Read (find)
  • 11: NoSQL 1

• 12: NoSQL 2
  • Document-oriented modelling
    Document-Oriented Modelling
  • MongoDB - Update
    Update in Mongo DB
    Update
  • MongoDB - Delete
    Delete in MongoDB
    Delete
  • 12: NoSQL 2

• Review
  • Recap
  • Sample paper
  • Recap