Introductory description

The main aims of the module are to familiarise students with spreadsheets, relational databases, SQL and tools designed to work with big data.

Module web page

Module aims

Outline syllabus

This is an indicative module outline only to give an indication of the sort of topics that may be covered. Actual sessions held may differ.

Spreadsheets and interaction with the user
Relational databases
SQL queries
Big data technologies

Learning outcomes

By the end of the module, students should be able to:

• Understand basic SQL queries
• Demonstrate an aptitude for working with certain big data technologies
• Demonstrate an aptitude to working with data presented in various formats including spreadsheets and relational databases.
• Design and write basic SQL statements
• Extract, manipulate, join and store data in relational databases

Indicative reading list

Introduction to SQL: Mastering the Relational Database Language. Addison Wesley; 4 edition (26 Sept. 2006)
Jeffrey Aven. Data Analytics with Spark Using Python (Addison-Wesley Data & Analytics)Paperback 6 Jun 2018

Subject specific skills

Demonstrate understanding of how to work with data presented in various formats including spreadsheets and relational databases.
Design functional and well-structured spreadsheets

Transferable skills

Written communication

Oral communication

Problem solving

Team work