Profile
Note: This course is offered as a module in the (SCTP) Junior Data Engineer programme. We do not offer this module on its own. Please scroll down to proceed to the main SCTP site for more information and to register interest.Â
This course curriculum prepares entry level professionals to handle the data management activities such as collecting the data from internal and external data sources (big data), building the data structure to store the data captured, and loading the data into the data systems (such as data lake) as well as have a good understanding in different types of database systems such as traditional relational databases and modern big data management platforms, and the data transformation techniques. There are behavioural skills and mindsets elements integrated into both the technical and practice sessions.
What You'll Learn
Participants will learn the Python and SQL programming language. They will then apply these skills to explore and analyse data. Learner are expected to be able to apply basic SQL skills to perform more complex SQL queries and prepare datasets. They will also learn the basics of the PostgreSQL database management system. They will also learn functions to manipulate data within the system.
Minimum Entry Requirement
Pass screening which includes a basic technical test and interview