The aim of the module is to: Equip the student with the skills and know-how to carry out common database administration tasks and to introduce the students to data analysis techniques.
Database Administration
Creation of Users, Profiles, Privileges in oracle. Backup and Recovery best practices and Security in Oracle.
Data Preparation and Analysis
Working raw data( importing data from different sources but only one source at a time), cleaning the data (using mean, median, mode, Standard Deviation, number imputation and graphing for outliers), analysis of the data (Descriptive,Exploratory, Inferential) using pythons built in librarys e.g. MathPlotlib, numy, pandas.
Visualisation of Data
Overview of google analytics, visualization of data sets using Power BI or similar.
Governance of Data
Examining the theory of governance of data e.g. privacy by design or default, Personal and sensitive data, subject access rights.
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Formal Examination | 40 |
| Other Assessment(s) | 60 |