Study Guide

Objectives

The course objectives of the course are provide skills to design databases (tables), to be able to install and use database management systems, be familiar with the SQL standards, and be able to use advanced features of SQL language.

After completing the course, the student
• Is able to design large databases.
• Is able to install and configure database systems.
• Is able to use advanced features of the SQL language.
• Is familiar with SQL standards.

Content

• Database system installation
• Database design and normalization
• Consistency requirements, foreign keys, constraints, etc.
• SQL commands and their advanced features (e.g. transactions)
• SQL standards

Prerequisites

Introduction to Programming
Databases

Assessment criteria, satisfactory (1-2)

The student is familiar with SQL standards, is able to install and manage database management systems (DBMS), is able to design simple database designs, and use some advanced features of SQL commands.

Assessment criteria, good (3-4)

The student is able to apply SQL standards in database designs (e.g. knowledge about non-standard data types), able to install and configure database management systems (DBMS), design moderately complex database solutions, and use moderately advanced features of SQL commands.

Assessment criteria, excellent (5)

The student demonstrates a deep understanding of SQL standards by designing cross platform database solutions that are independent of the database management systems (DBMS). The student is able to migrate database solutions from one system to another. The student demonstrates excellent skills in using advanced features of SQL commands.