Database Management Systems
About This Course
ICT330 Database Management Systems introduces students to relational databases, data modelling and the theory of relations as applied to the representation of models of data. The aim of this course is to equip students with an understanding of database systems concepts and in particular, using and then designing both read-only and updateable relational databases. The data sublanguage SQL, covered in practical lab sessions using a database management system such as Oracle Database system, includes both SQL Data Definition Language (DDL) for the implementation of the physical database from the Logical Data Model and Data Manipulation Language (DML) for data manipulation and query. The implementation of database objects such as views, triggers and stored procedures using SQL procedural extensions to fulfill business requirements are also explored in practical lab sessions. The system administration of multi-user database systems will also be covered to address issues such as concurrency, database backup, recovery and security.
What You'll Learn
2 Normal forms<br>
3 Entity Relational (ER) model<br>
4 Mapping ER model to relational database<br>
5 SQL Data Definition Language (DDL)<br>
6 SQL Data Manipulation Language (Insert, Delete, Update, Query)<br>
7 Views, SQL procedural extensions for triggers and stored procedures<br>
8 ACID properties (including race condition, deadlock, serialisable transactions, 2PL)<br>
9 Overview of database system architecture<br>
10 Database recovery and security<br>
11 Big Data and NoSQL<br>
12 XML and databases
Entry Requirements
Diploma or an equivalent qualification from a recognised institution