Subject description
The subject presents advanced topics in the modern relational database technology and it introduces the new non-relational (NoSQL) database technologies. The relational database technology component of the subject includes database normalization, introduction to indexing in relational database systems, programming of relational database server with stored procedures, functions, and triggers, concurrency … For more content click the Read More button below.
Enrolment rules
Pre-Requisite
Delivery
To view information specific to your campus, click on Select availability in the top right of screen and choose from the campus, delivery mode and session options.
Learning outcomes
On successful completion of this subject, students will be able to:
1.
Adapt a theory of relational database normalization to prove the correctness of relational database designs
2.
Design and create stored procedures, stored functions and database triggers in advanced SQL and in PL/SQL, apply indexing to improve performance of relational database applications
3.
Design and create effective database transaction based on the principles of transaction processing and theory of concurrency in database systems
4.
Summarise the principles of distributed database systems, design and create distributed relational databases
5.
Summarise the principles of modern non-relational (NoSQL) database technologies, design and create key-value and document oriented database systems
6.
Design and implement modern non-relational (NoSQL) database systems, apply indexing to improve performance of database applications, use replication and sharding to design and to implement more reliable and more efficient database applications
Work integrated learning
Embedded WIL:This subject contains elements of "Embedded WIL". Students in this subject will experience activities that relate to or simulate professional practice as part of their learning.
Textbook information
No prescribed textbooks for this subject.