Skip to content
A New Name. Same Commitment to Excellence. → Learn More about the Rebrand
💡Get 10% Off Further Education Courses! Use Code CARE10 before 30th September. → Apply Now
💡Get 10% Off Classroom & Live Online Diplomas! Use Code DIPLOMA10 before 30th September..
💡Get 10% Off On-Demand Professional Diplomas! Use Code DEMAND10 before 30th September..

Data Management (Level 8)

Duration i year
Stage Award
NFQ Level Level 8
ECTS Credit 10

This module aims to focus on the need of tools and technologies require for managing and storing Research, Big data, and business problems at level 8. Data is key to any organization, so this module examines the relevance of data management as a corporate asset, as well as the data management components required for addressing business problems in terms of data capturing, storing, sharing, validation, and accessibility.

This module introduced students to the use of database management systems (DBMS), entity relationship diagrams (ERDs) for database designs and the administrative processes that manage the data lifecycle. Students will also learn, what is database architecture and modelling, how to create relational databases, SQL and NoSQL data models queries to extract information to satisfy business reporting requests as well as data manipulation and stored data distribution using both formats. How to take leverage from cloud data stores for longer time data perseverance without having redundancy and scalability issues in terms of resources and availability.

The objective of this module is to provide the learner with knowledge of:

  • Understanding of data as enterprise asset
  • An overview of the Data planning, Data management, Data modelling mechanisms
  • The theoretical and practical differences between traditional, relational, and non-relational database
  • Understanding of Structure and unstructured data; data pre-processing challenges
  • Developing knowledge of Advance SQL and Modern databases i.e., NoSql, Graph Database
  • Awareness about data security and privacy including cloud data management
  • Applying these techniques and principles in typical real world scenarios by using latest tools
Data Management (Level 8)

Indicative Syllabus

Data Base Management System and Data Modelling Overview

  • Importance of Data (including data as enterprise asset and use of Big Data); Data Planning, and Data management; Types of Databases; Centralized vs Distributed DB.
  • The Relational Data Model; DBMS architectures; Data Integration and sharing concepts; Data Independence; Transaction and concurrency controls in DBMS

Relational Database Management System (RDBMS) and Structured Query Language (SQL)

  • Data Manipulation SQL Commands: DB Definition in SQL – CREATE, DROP, CHECK, ALTER; Aggregate Functions; JOINS, SQL Subqueries; Stored Procedures; Packages; Pivoting data: CASE & PIVOT syntax; Cursors: Implicit and Explicit; Trigger; Hierarchical Queries
  • Materialized View.
  • Transactions: Commit, Rollback, Error Handling and different level of isolations and possible anomalies
  • Query Optimization: Indexes; Explain Plans; Profiling; Full Text Searching
  • Data Modelling: Normal Forms, 1 through 3; Primary & Foreign Keys; Table Constraints; Link/Corollary Tables

Post-Relational and NoSQL Databases

  • Limits of SQL and motivation to NoSQL Database Models; Types of NoSQL systems / data models: MapReduce framework; Development of Non-Relational Technologies
  • Creating and Querying NoSQL Models; Key-Value, Column-Family and Document Stores; XML Databases and Graphic Databases

Distributed Databases

  • Master-Slave and Peer-to-Peer Replication; Distributed File Systems; Data Fragmentation DDBMS Sharding

Data Security and Privacy

  • Dynamic Data Masking and Encryption
  • Data Anonymization and Tokenization Techniques

Cloud Computing

  • Overview of Cloud Data Management (benefit, challenges, and use cases)
  • Cloud Platforms over Data Centres
  • Cloud Infrastructure, Services, and their security demands

Module Details

  1. Concepts of Data Modelling and Data Management i.e. relational and non-relational
  2. Using advance SQL Data Definition, manipulation commands implement, optimize and query relational databases
  3. SQL’s limitations and reason for NoSQL Database Models, Creating and Querying NoSQL Models
  4. Data Security and Privacy concepts to maintain data integrity and accessibility
  5. Difference between various data distribution methodologies
  6. Role of data warehousing and cloud computing in data management
  7. The Importance of Data Management in Scientific Research

The Data Management module is assessed by 100% continuous assessment. The use of continuous assessment is based on developing the learner’s ability to investigate, evaluate theories and concepts and apply them to a given scenario.

Mapping of Assessments to Module Learning Outcomes

MLO 1 MLO 2 MLO 3 MLO 4 MLO 5 MLO 6
Continuous Assessment X X X X X X

Where the marks of the assessment do not reach the pass mark the learner will be required to repeat the element of assessment that they failed. Reassessment materials will be published on Moodle after the Examination Board Meeting and will be aligned to the MIMLOs and learners will be capped at 40% unless there are personal mitigating circumstances.

Data Management (Level 8)

Expert Faculty

Learn from the best in your industry

Flexible Learning Options

Study your way, on your time

Career Focused Programmes

Programmes with purpose, aimed at your future

Student Support Services

Here for you, every step of the way

Get in touch

Get in touch

If you have any questions specific to this course, you can speak directly with one of our course lecturers. Please get in touch, we’re happy to help!

Data Management (Level 8)