Advanced Database Systems
Description
This course takes a step-by-step investigation of modern analytical databases. It starts with hardware-aware storage, then moves through execution flow, indexing, cost-based optimisation, and emerging analytic tasks. The course offers lectures and guided labs to let students practise ideas such as columnar layout, vector processing, joins, estimators, and approximate answers right away. It provides an in-depth exploration of modern database systems and data management techniques with a special focus on their application in data science and artificial intelligence. Students will gain practical experience designing, implementing, and optimizing analytical pipelines, preparing them to tackle real-world data analysis challenges.
Requisites
Prerequisites: IS112 Pre-req (CS201/IS115) Pre-req
Co-requisites: None
Anti-requisites: None
Attributes
Department: SCIS
Course Level: Undergraduate
Tracks: CS: Software Systems Track IS/T4BS: Product Development Track
Areas: IS Depth Electives IT Solution Development Electives
Learning Outcomes
Graduate Learning Outcomes
Disciplinary knowledge, Critical thinking & problem solving, Collaboration and leadership
Competencies
Systems Design, Algorithm Analysis, Data Analytics