Advanced Relational Database Systems (ARDS)

Description

This advanced course delves into the intricacies of relational database systems, tackling a broad spectrum of topics from sophisticated query optimization techniques to the internal workings of database management systems (DBMS). It emphasizes practical skills in designing and implementing scalable, efficient, and secure database solutions, as well as theoretical knowledge on the principles underlying database systems. Students will grasp the architecture and operation of distributed database systems, including big data integration, evaluate the applicability and limitations of NoSQL and NewSQL databases in various scenarios discussing their use cases, strengths, and how they complement traditional relational database systems to lastly implement effective strategies for data warehousing, business intelligence, and database security. Students will learn through a variety of formats including interactive videos, practice quizzes, presentations, assignments, discussion forums and handing in a final project, which will cover the technical and practical aspects of designing and deploying at least one relational database management system (e.g., MySQL, PostgreSQL, Oracle), highlighting the gained knowledge required to tackle the challenges of modern database systems and prepare for future advancements in the field.