About Course
Course Structure
Financial Matters
About Course
Course Objectives
Participants will learn:- How to import data from various sources such as flat files, excel files, json.
- Use SQL to navigate and extract data stored in structured database
- Understand the various types of data types: nominal, ordinal, continuous, text, date etc.
- Perform preliminary data analysis on a data set to produce a data summary.
- Understand how to deal with badly formatted data
- Process data to prepare data for further analysis
Course Description
This course introduces the various techniques to import data, clean data and process data for analysis. The course will cover simple statistical analysis that can be performed on the processed data.The course covers the following:
- Importing Data from various sources such as CSV, JSON, Excel files
- SQL language to manipulate data stored in a structured database
- Cleaning Data to ensure proper formatting, dealing with missing values, assigning proper data types to fields etc.
- Processing Data which includes transforming data into different structure formats, encoding data, normalisation of data values etc.
Course Structure
TPG course reference No.
TGS-2021006218
Data Wrangling (Synchronous e-learning)
Financial matters
Course fees payable (incl. GST & excl. supplementary fee)
| Description | Data Wrangling (Synchronous e-learning) | Total course fee |
|---|---|---|
| Full Course fee | $2,398.00 | $2,398.00 |
| Enhanced Training Support for SMEs for Singapore Citizen | $279.40 | $279.40 |
| Enhanced Training Support for SMEs - SPR & LTVP+ | $279.40 | $279.40 |
| SkillsFuture Mid-Career Enhanced Subsidy for Singapore Citizen aged 40 and above | $279.40 | $279.40 |
| SkillsFuture Baseline Funding for Singapore Citizen Aged Below 40 | $719.40 | $719.40 |
| SkillsFuture Baseline Funding for SPR/LTVP+ | $719.40 | $719.40 |
GST rate
The course fees payable above are inclusive of 9% GST rate.
Payment option
The payment needs to be made upon the application is submitted.
Allowed payment by
The course fee allows to be paid by:
Post-Secondary Education Account (Adhoc withdrawal form);
SkillsFuture Credits (SFC);
Credit card (e-payment);
Debit card (e-payment);
PayNow (e-payment).
Post-Secondary Education Account (Adhoc withdrawal form);
SkillsFuture Credits (SFC);
Credit card (e-payment);
Debit card (e-payment);
PayNow (e-payment).
Refund and withdrawal policy
- Please note that a 100% refund will be available if the withdrawal request is submitted more than or equal to 14 days before the course start date.
- Please note that a 50% refund will be available if the withdrawal request is submitted less than 14 days before the course start date.
- Please note that no refund will be available if the withdrawal request is submitted on or after the course start date.