Study Guide

Objective

The student knows the principles of relational databases and is capable to design a relational database and apply it in practice to information management.

Content

- Concept analysis
- Relational Models
- Basics of SQL commands (SELECT, DML, DDL)

Location and time

Lessons and code labs are hold in the computer class rooms at Rantavitikka campus in the autumn 2022.

Materials

Materials in our learning environment, moodle. In addition you can use the literature to support your learning. For example:

SQL QuickStart Guide: The Simplified Beginner's Guide to Managing
Author: Shields, Walter

The Art of SQL
Author:Faroult, Stephane

Teaching methods

Lectures, assignments and tutorials. Inn addition code labs which are meant for tutoring the exercises.

International connections

The study unit will be taught in English and makes it possible for international students to join

Content scheduling

General about SQL Databases
Tables
Queries and Changing the data
Filtering
Aggregate functions
Dataset operation
Sorting and Grouping
Working with multiple tables
Database design and modeling
Other option, NOSQL

Evaluation scale

H-5

Assessment criteria, satisfactory (1)

The student knows the structure of a relational database.

The student can utilize simple SQL statements in database processing.

Assessment criteria, good (3)

The student outlines the principles of relational databases.

The student can complete a concept analysis, create a relational database model and utilize the most common SQL statements in data management.

Assessment criteria, excellent (5)

The student can perform concept analysis and create a context-based relational database model.

The student can use SQL commands in a versatile manner in database processing.