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. tansactions)
• SQL standards

Prerequisites

Introduction to Programming
Databases

Assessment criteria, satisfactory (1-2)

The student is familiar with SQL standards, can install database system software, design simple database solutions, and use some advanced SQL command features.

Assessment criteria, good (3-4)

The student is able to apply SQL standards (e.g., use standard-compliant data types), install and configure database system software, design versatile database solutions, and utilize advanced SQL command features more comprehensively than average.

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.