F28DD - Database Management Systems

Course leader(s):

Aims

• To provide a comprehensive introduction to database management systems

• To familiarise students with relational algebra and the theory, principles and applications of relational databases

• To gain competence in SQL to develop database applications, such as OLAP and OLTP applications

• To provide an understanding of non-relational alternatives, such as NoSQL databases

• To enable students to design real-world databases, embedded in and contextualised for their host companies

Syllabus

1. Introduction to database management systems

2. The relational database model, Entity relational modelling; Database normalisation

3. SQL programming

4. Query planning and optimisation

5. NoSQL database models

6. MongoDB programming

7. Transactional and analytics queries

8. In-memory, embedded and real-time databases

Learning outcomes

By the end of the course, students should be able to do the following:

explain key DBMS concepts as well as the principles, models and features of the different types of DBMs currently used in the industry.

apply the DB relational theory as well as the database normalization and optimization techniques that are used to efficiently implement DB applications.

write advanced SQL code and queries.

write intermediate NoSQL code with one of the NoSQL DB models used in industry

select, evaluate and implement the most suitable DBMS given a problem requiring a database solution.