SCTP Data Fundamentals, Database Management (SQL), Data Wrangling and Cleaning (OpenRefine, Trifacta Wrangler)
Training Provider: SINGAPORE INSTITUTE OF TECHNOLOGY
Course Reference: TGS-2025053168
S$653
Original: S$2,175
Save S$1,523
About This Course
This foundational course provides a comprehensive introduction to the essential concepts and tools used in data analytics. Students will gain a solid understanding of data fundamentals, learn to work with relational databases using Structured Query Language (SQL), and master the art of data wrangling and cleaning using popular tools like OpenRefine and Trifacta Wrangler.
What You'll Learn
The course objectives are to equip learners with knowlege and skills in:
- Defining data, information, and knowledge, and their relationships.
- Understanding the different types of data (structured, unstructured, semi-structured).
- Exploring data quality issues and their impact on analysis.
- Learning the basics of relational databases and their components (tables, columns, rows, keys).
- Learning Structured Query Language (SQL) syntax for querying, manipulating, and managing data in databases.
- Understanding database normalisation and its importance.
- Learning Data Wrangling and Cleaning
- Learning to use OpenRefine and Trifacta Wrangler for data cleaning, transformation, and enrichment.
- Defining data, information, and knowledge, and their relationships.
- Understanding the different types of data (structured, unstructured, semi-structured).
- Exploring data quality issues and their impact on analysis.
- Learning the basics of relational databases and their components (tables, columns, rows, keys).
- Learning Structured Query Language (SQL) syntax for querying, manipulating, and managing data in databases.
- Understanding database normalisation and its importance.
- Learning Data Wrangling and Cleaning
- Learning to use OpenRefine and Trifacta Wrangler for data cleaning, transformation, and enrichment.
Entry Requirements
Anyone who has intermediate level of knowledge in the use of computer applications and has some Science, Technology, Engineering, and Mathematics (STEM) background in work experience or education.
Course Details
Back to All Courses
Note: To apply for this course, visit the SkillsFuture website or contact the training provider directly.
More Courses from SINGAPORE INSTITUTE OF TECHNOLOGY
This course is designed to equip you with the essential skills to excel in the rapidly evolving digi...
This curriculum is designed for individuals with little to no prior experience in data analytics. It...
This course provides a comprehensive understanding of the core concepts and practices in digital pro...