Course overview
The course will equip students with the knowledge and skills required to implement and work with structured data in relational database systems. Through theoretical exploration and practical application, students will learn to capture data accurately, write queries to extract information, and the basics of managing data security. The topics covered will provide students with a solid foundation for real-world data management in business.
- Introduction to Relational Databases
- Database Design and Modelling
- Data Definition Language (DDL) and Data Manipulation Language (DML)
- Queries
- Data Manipulation Language (Part 1)
- Data Manipulation Language (Part 2)
- Views and Common Table Expressions
- Stored Procedures
- Indexes
- Control Data Language
Course learning outcomes
- Explain how data is stored and retrieved from a relational database and the advantages of using the relational model
- Design a relational database given a set of data and usage requirements
- Design and implement database queries to retrieve specified data from a relational database
- Explain how a query interacts with data within a relational database system and the impact design can have on management, retrieval and efficiency
- Demonstrate approaches to securing data access within a database
- Select for efficiency between alternative query options
Degree list
The following degrees include this course