Fundamentals of Data Science

Aim

To provide learners with a basic understanding of how data is modelled, stored, manipulated and analysed using databases and visualisation techniques.

Course content

Data visualisation techniques such as bar charts, pie charts, scatter diagrams, gauges and bubble charts created within a variety of software tools, Conceptual and logical data modelling techniques that capture the data requirements of simple systems, Normalisation of tables, Introduction to Structured query Language (SQL) such as Data Definition language (DDL) and Data manipulation language (DML) statements to create simple databases and to manipulate and extract data

Learning objectives

1. Describe and explain data using a variety of visualisation techniques and software tools
2. Analyse the data requirements of simple systems and model those requirements using conceptual and logical data modelling techniques
3. Create a simple database that includes tables, columns, primary keys, foreign keys and simple queries