Data Systems
About This Course
This course introduces the essential role of data systems in data science, focusing on how structured data supports analytics and decision making. Learners will gain practical skills in designing relational data models and applying relational algebra to organise and query data effectively. The course emphasises hands-on experience with Structured Query Language (SQL) for data extraction and manipulation, enabling learners to work confidently with real world datasets. Additionally, learners will explore how transactions are managed in data systems, ensuring data integrity and consistency. By the end of the course, learners will be equipped to design, query, and manage robust data systems for data driven solutions.
What You'll Learn
1. Explain the importance of data systems in data science.
2. design the relational data model and algebra.
3. Apply the structured query language (SQL) for data science.
4. Explain how transactions in data systems are managed.
Entry Requirements
No pre-requisites are needed to enroll in the individual courses; however, learners without qualifications or work experience in relevant engineering or the related fields may find the course contents challenging. Prior knowledge in STEM field will be an advantage.