Week 01 Lecture
Lecturer
Course Goals
Learning/Teaching
Pre-requisites
Ex1: SQL
(revision)
Ex2: Unix File I/O
(revision)
Prac Work
Assignments
Quizzes
Exam
Assessment Summary
Relational Database Revision
Relational DBMS Functionality
Data Definition
Data Modification
Query Evaluator
DBMS Architecture
Database Engine Operations
Relational Algebra
Ex3: Relational Algebra
Describing Relational Algebra Operations
Relational Algebra Operations
PostgreSQL
PostgreSQL
PostgreSQL Online
User View of PostgreSQL
PostgreSQL Functionality
Installing PostgreSQL
PostgreSQL Configuration
Using PostgreSQL for Assignments
PostgreSQL Architecture
PostgreSQL Source Code
Catalogs
Database Objects
Representing Databases
Representing Tables
Ex4: PostgreSQL Data Files
Produced: 29 Feb 2016