F29YK - Database Systems

Course leader(s):

Aims

Students will learn how to create and interact with database systems and through understanding relational data theory use SQL, concurrency control and recovery techniques in databases. They will apply database theory to various realistic problems.

Syllabus

1. Explore the basic concepts of database systems (including characteristics and structure of database systems, data models, etc.) (1.1 Database Systems Xidian CS265003)

2. Understand the underpinnings of relational database systems and how to create them. (2.1 Database Systems Xidian CS265003)

3. Develop fluency with SQL, including concurrency control and recovery techniques in databases (3.1 Database Systems Xidian CS265003)

4. Apply databases in realistic scenarios (4.1 Database Systems Xidian CS265003)

Learning outcomes

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

Create and interact with database systems
Understand relational data theory
Use SQL, concurrency control and recovery techniques in databases
Apply databases

Further details

Curriculum explorer: Click here

SCQF Level: 9

Credits: 15