Study Guide

Learning outcomes

Student is able to
- form queries using SQL
- apply the basic principles of normalization
- maintain databases
- describe the principles of database transactions
- explain the importance of information security in data storage
- describe alternative data storage types

Implementation and methods of teaching

Lectures and excercises. The course is graded based on an assignment.

Timing and attendance

Weekly lectures, attendance recommended.

Learning material and recommended literature

The materials on Moodle and WWW, also any introductory book on SQL recommended. The Moodle page also includes optional exercises regarding SQL.

Alternative completion methods

Negotiable.

Exam retakes

Negotiable.

Learning environment

Moodle and group work. The assignment requires the use of XAMPP or similar environment.

Student time use and work load

5 credit course.

Contents

Learning outcomes of the course
Student is able to
- form queries using SQL
- apply the basic principles of normalization
- maintain databases
- describe the principles of database transactions
- explain the importance of information security in data storage
- describe alternative data storage types

Additional information for students: previous knowledge etc.

Basic understanding of programming

Assessment criteria

Based on course assignment

Assessment scale

1-5

Failed (0)

Unable to form basic queries or understand how queries are used in software

Assessment criteria: level 1 (assessment scale 1–5)

Has rudimentary understanding of queries.

Assessment criteria: level 3 (assessment scale 1–5)

Can design databases in a normalized manner

Assessment criteria: level 5 (assessment scale 1–5)

Can form complex queries.