1.2: Databases

Code
L.26832
Amount of hours required
140
Language
nl-NL
Quartile of execution
2

Every application, no matter how small, uses data. This data is often stored in a database. The most used databases are (still) relational databases. That is why relational databases are now an essential component when building applications or generating management reports. Some well-known examples of relational database management systems (RDBMS) are MySQL and PostgreSQL.
In this module we will explain how to design and use a database. Topics covered in this module:
How to run a query in a database (SQL)
How to make changes to a database (SQL DDL/DML)
How to design a database using Entity-Relationship Diagrams
Database management

Competences

HBO ICT 6.1 OP/ANA/1
HBO ICT 8.1 OP/ONT/1
HBO ICT 11.1 SW/ANA/1
HBO ICT 13.1 SW/ONT/1
HBO ICT 14.1 SW/REA/1

Learning goals

You can design a relational database model using an entity-relationship diagram (ERD) for a given case study.
You can convert an ERD to a database using a database administration tool.
You can use DML to request and adjust data in a relational database.
You can explain concepts such as ERD, constraints, index, consistency, redundancy, surrogate, primary and foreign keys, etc.
You can manage users and user access rights for a database.
You can link and interpret data in a given context.

Tests

Code	Name
WC	Werkcollege
T.52241	1.2: Databases