CYB107 – Secure Database Design

Databases are an integral part of cybersecurity system design and control deployment in organisational networks. This unit introduces students to the fundamentals of databases, relational database management systems and concepts of database design, including entity-relationship models, normalisation, and an introduction to the Structured Query Language (SQL).      

Students are provided database design and implementation training in the context of cybersecurity. The training modules cover the design of SQL injection attack resilient databases and how to protect database management systems from cyber threats. The fundamentals of database security auditing and testing are also covered.

Learning outcomes:

• Identify and describe databases, file systems and data types
• Explain fundamentals of relational databases, normalisation and data reference models
• Design and formulate relational database management systems including entity-relationship modelling for cybersecurity case studies
• Apply concepts of structured query language (SQL) to design, implement and manage database systems
• Demonstrate ability to securely retrieve data through query design and information analysis