Database lies at the heart of modern information systems for organisations of various kinds and sizes. A well-designed database of good performance is always vital for effective information processing. Correct understanding of the key concepts of databases, knowledge on how databases work, proficiency in SQL and ability to specify, design, implement and validate databases are essential for IT professionals and graduates of computing. This module aims at teaching basic concepts and principles of relational (SQL) database systems. The module covers methodologies, tools and techniques for designing an optimal and well-structured database schema, and query descriptions using SQL. The module further discusses issues relating to database performance, security and its practical use. The module eventually draws relevance of conventional SQL databases to modern NoSQL databases and big data platforms. Through the teaching sessions, students will gain fundamental knowledge towards databases. At the same time, by undertaking a group project, the students will also develop practical skills in designing a database from the point of conception to the point of delivery. The combined approach of teaching theory and the practical project will enable students to obtain a good understanding of this important branch of computing technology.
- Lecturer: Hongbo Du