Module Overview
Advanced Databases
Part-time / Level 9 / Online / 5 ECTS
The module aims to cover a range of Advanced Database topics. The module assumes that the students will have studied databases at an undergraduate level and will build upon those skills to look at how databases are used in IT architectures in commercial organisations. The module will have a industry focus looking at techniques, databases, tools and areas of application regularly used in industry.
The module will be 100% continuous assessment and this allows the module to evolve as new database and data management techniques come available. The module will be divided into 4 core areas.
- Core Database Features
- Internals of a Database
- Implementation of Complex Database Architectures
- Latest Developments in Databases
-
- Traditional Database architectures
Understanding of role of the three schema architecture Detailed understanding of database internals and how they relate to the three schema architecture Database design, consisting of the ER diagram, domains, business logic, etc The Thick Database Paradigm Relational and NoSQL Databases, features, applications and when to use-
- Internals of a Database
Expansion of the Thick Database Paradigm and its implications Database Security Database Encryption, Masking, Redaction, etc SQL Query Optimization
Database Optimization features Advanced performance features of databases
- Implementation of Complex Database Architectures
Database Replication, real-time and near-real-time Distributed Database architecutres Distributed data management Database Sharding
- Latest Developments in Databases
The evolving SQL language Advanced SQL for analytics and data processing Advanced data and database architectures
- Recent developments in Hadoop and distributed data/database management
Review of latest products and features. Comparison of newly released produced to more traditional approaches Evaluation of new tools, databases, and data processing techniques
- Data management and Governance
Managing data in an ever increasing data management environment.
The module is designed to be delivered within a blended learning model, employing mixed modes (online and face to face) of learning, teaching and assessment.
TU059 will be delivered primarily in a face-to-face mode while TU060 will be delivered in a blended mode.
Combination of lectures, lab work and flipped classroom
Module Content & Assessment
| Assessment Breakdown | % |
|---|---|
| Other Assessment (s) | 100.00% |
Contact school.cs@tudublin.ie for further information.
Start date: January 2025
EU students: €230
Non-EU students: Contact international.city@tudublin.ie for more details.