Hogeschool West-Vlaanderen
Howest Brugge
Spoorwegstraat 4 - 8200 Brugge
Tel: 050 682666
studentadmin@howest.be - Website: www.howest.be
Databases Fundamentals17887/2013/2627/1/23
Study guide

Databases Fundamentals

17887/2013/2627/1/23
Academic year 2026-27
Is found in:
  • Bachelor of Cybersecurity, programme stage 1
This is a single course unit.
Study load: 3 credits
Total study time: 75,00 hours
Re-sit exam: is possible.
It is not possible to enrol in this course unit under
  • exam contract (to obtain a credit).
  • exam contract (to obtain a degree).
Teaching staff: Theben Tervile Corneel, Vlummens Frédéric
Language course: No
Languages: English

Omschrijving Volgtijdelijkheid (VT) (EN)

There are no prerequisites for this course.

Omschrijving Doelstellingen (EN)

LR3:

03.1.5 Generalizes and clarifies the cybersecurity of databases

LR4:

04.1.2 Defines identification, authentication, authorization

04.1.4 Articulates and characterizes the basics of database usage and management

04.2.1 Configures and implements identification, authentication, authorization

04.2.3 Retrieves data from a database, or uses it within an AI context

LR5:

05.1.1 Explains the principles, structures, languages and environments relevant in software development incl secure coding recommendations

Omschrijving Inhoud (EN)

Introduction

Concepts: database, database system, relational database system, SQL

SQL in a nutshell

Consulting data

 Discussion of the SELECT statement
- Simple SELECT statements: SELECT, FROM, WHERE and ORDER BY clause
- Joining tables: inner join and outer join
- Using scalar functions and aggregate functions
- Grouping of data: the GROUP BY and HAVING clause
- Subqueries: uncorrelated and correlated subqueries

Creating, updating and deleting data

Discussion of the SQL statements INSERT, UPDATE and DELETE

Working with views

Creating and using views

Implementation of the data model

Discussion of the SQL statements CREATE, ALTER and DROP

SQL Server and JSON

Converting SQL data to JSON data and vice versa

Database security

Security at the server, database and object level

Other information structures

JSON, NoSQL

Omschrijving Studiematerialen (lijst) (EN)

Lecturer's courseMandatory
PresentationMandatory
WebsitesMandatory
Mandatory
  • Publisher: Microsoft

Omschrijving Eindcompetenties (lijst) (EN)

PBACS003: Across the full range of software, firmware and hardware technologies, evaluates and improves the cybersecurity of (sub)systems by detecting, analysing and dealing with existing attack vectors and vulnerabilities, this by deploying existing defensive and offensive security software, including developing proprietary scripts, penetration testing, digital footprint reduction and participating in red teaming exercises.
CodeDescription
PBACS003Across the full range of software, firmware and hardware technologies, evaluates and improves the cybersecurity of (sub)systems by detecting, analysing and dealing with existing attack vectors and vulnerabilities, this by deploying existing defensive and offensive security software, including developing proprietary scripts, penetration testing, digital footprint reduction and participating in red teaming exercises.
PBACS004: Selects and configures the optimal techniques, including identification, authentication and authorization and applies these within mainstream environments including physical and industrial environments for each phase of the cyber security process.
CodeDescription
PBACS004Selects and configures the optimal techniques, including identification, authentication and authorization and applies these within mainstream environments including physical and industrial environments for each phase of the cyber security process.
PBACS005: Contributes to structuring and optimising a secure development life cycle in which each phase is adequately protected by an appropriate combination of technical and organizational controls, tailored to specific requirements within relevant domains
CodeDescription
PBACS005Contributes to structuring and optimising a secure development life cycle in which each phase is adequately protected by an appropriate combination of technical and organizational controls, tailored to specific requirements within relevant domains

Omschrijving Onderwijsvorm (EN)

  • Lecture
  • Exercise class
  • Independent work

Omschrijving Evaluatie (lijst) (EN)

Evaluation(s) for first exam chance
MomentForm%Remark
exam period 1 (1st sem) (regular exam schedule)exam: specific method or combination of methods100,00
Evaluation(s) for re-sit exam
MomentForm%Remark
exam period 3 (august/september) (regular exam schedule)exam: specific method or combination of methods100,00