This subject introduces you to the various techniques of data wrangling with a strong focus on hands-on experience in programming using Structured Query Language (SQL) and a computer language. It will cover the basic concepts in relational database design including Entity Relationship (ER) modelling and SQL as a tool for … For more content click the Read more button below.
This subject introduces you to the various techniques of data wrangling with a strong focus on hands-on experience in programming using Structured Query Language (SQL) and a computer language. It will cover the basic concepts in relational database design including Entity Relationship (ER) modelling and SQL as a tool for basic data wrangling. You will also learn various types of data sources and common data formats. The subject equips you with skills in data wrangling, including data import and export, basic data integration, assessment and transformation. Upon completion, you will be able to perform a variety of data wrangling tasks using SQL and a programming language for different kinds of data types.
Capstones provide students with a way of integrating and applying knowledge and skills gained throughout their course.
No
Academic progress review - Schedule A subject
No
Subject instances
To view instance specific details which include - Assessments, Class requirements and Subject instance coordinators - please select your preferred instance via the drop-down menu at the top right-hand side of this page.
Learning resources
Recommended - Book - Data Wrangling with R (Use R!)
Title:Data Wrangling with R (Use R!)
Resource requirement:Recommended
Author/editor:Boehmke, B.
Year:2016
Publisher:Springer International Publishing
ISBN:9783319455983
Recommended - Book - The Essentials of Data Science
Title:The Essentials of Data Science
Resource requirement:Recommended
Author/editor:Williams, G.
Year:2017
Publisher:CRC Press
Recommended - Book - Microsoft SQL Server 2016: A Beginner's Guide
Title:Microsoft SQL Server 2016: A Beginner's Guide
Resource requirement:Recommended
Author/editor:Petkovic, D.
Year:2016
Publisher:McGraw-Hill Education
ISBN:9781259641794
Career ready
Work based learning (placement):No
Graduate capabilities
COMMUNICATION - Communicating and Influencing
COMMUNICATION - Digital Capability
DISCIPLINE KNOWLEDGE AND SKILLS
INQUIRY AND ANALYSIS - Critical Thinking and Problem Solving
INQUIRY AND ANALYSIS - Research and Evidence-Based Inquiry
Subject intended learning outcomes
On successful completion you will be able to:
1.
Design, formulate and compose database schema and query structures for analytics initiatives
2.
Compare and contrast various data formats and motivations for data wrangling.
3.
Construct SQL and computer programs to wrangle data.
4.
Formulate data and data wrangling requirements based on the technical challenges of an analytics task
