Business and technology qualifications, Levels 3-6, in Brussels. Explore qualifications
Portal login

Advanced Database Management Systems

IT603

Course CodeIT603
ECTS

Course Description

The aim of this unit is to develop learners’ knowledge and skills of advanced database systems and how these systems are managed within a business or corporate environment. Learners will be able to make informed choices between vendor and open source platforms for database management systems, and design and develop a relational DBMS for a client using an open source platform.

Course Objectives

The aim of this unit is to develop learners’ knowledge and skills of advanced database systems and how these systems are managed within a business or corporate environment. Learners will be able to make informed choices between vendor and open source platforms for database management systems, and design and develop a relational DBMS for a client using an open source platform.

Key Topics

  1. LO1: Understand different types of database management systems.
  2. LO2: Be able to apply data analysis and database design techniques.
  3. LO3: Be able to develop a secured and functional database to meet client and system requirements.

Course Outline

WeekTopics
1Relational Theory and Normalisation
2Database Modelling Languages
3Database Engine Architecture and Platform Selection
4Logical Modelling and Normalisation Practice
5Physical Database Design and Build
6Advanced Querying and Data Extraction
7Database Access Control and Granular Security
MidtermMidterm evaluation
9Database Threat Landscape and Risk Evaluation
10Database Functional and Performance Testing
11Database Administration and Enterprise Resilience
12Applying Advanced Database Management Systems in practice: case studies
13Assignment workshop: research, planning and referencing
14Assignment workshop: drafting, feedback and improvement
15Review and coursework completion
FinalFinal assessment and submission

Learning Outcomes

  1. LO1 Understand different types of database management systems.
  2. 1.1 Assess how relational database models and normalisation provide reliable and efficient databases.
  3. 1.2 Critically compare a range of Database Modelling languages.
  4. 1.3 Critically evaluate different database management systems available in relation to open source and vendor-specific platforms.
  5. LO2 Be able to apply data analysis and database design techniques.
  6. 2.1 Apply data modelling techniques to refine logical data requirements and normalize.
  7. 2.2 Use a standard unified modelling language (UML) notation to document logical data requirements.
  8. LO3 Be able to develop a secured and functional database to meet client and system requirements.
  9. 3.1 Design and build a database structure.
  10. 3.2 Extract data from tables.
  11. 3.3 Apply table and field-level security to the database.
  12. 3.4 Test the system for functionality and performance
  13. 3.5 Evaluate security risks to the database.
Back to programme
Scroll