Data Management (Level 8)
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
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
Data Management (Level 8)
Learn from the best in your industry
Study your way, on your time
Programmes with purpose, aimed at your future
Here for you, every step of the way
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!