Databases (3 cr)

Objectives (course unit)

After completing the course, the student
- Knows the basic structures and concepts of databases
- Can design and create simple databases
- Can fetch data from a database
- Can add/modify data in a database

Content (course unit)

The structure of relational databases
Tables, columns, data types
Create statements of databases and tables
Search and join operations
Insert, update and delete statements

Assessment criteria, satisfactory (1-2) (course unit)

The student knows the basic concepts of databases.
The student can write simple select statements and combine data from multiple tables.
The student can insert data into a database.

Assessment criteria, good (3-4) (course unit)

The student can write select statements using logical operations and arrange result data by various criteria.
The student can use several functions in select statements.
The student can create and alter the structure of the database schema.

Assessment criteria, excellent (5) (course unit)

The student can create databases and tables based on the UML class diagram.
The student can update/delete tables/columns.

Location and time

Announced on the Moodle page of the course

Exam schedules

Announced on the Moodle page of the course

Assessment methods and criteria

Kurssiarvosana määräytyy viikkoharjoitusten pistemäärän ja harjoitustyön perusteella. Tarkemmat tiedot kurssin Moodle-sivulta.

Assessment scale

0-5

Teaching methods

Contact teaching, weekly exercises, coaching

Learning materials

Jay A. Kreibisch, Using SQLite (O'Reilly, 2010)
Elmasri - Navathe, Fundamentals of Database Systems, 7th Ed (Pearson, 2016) or older edition

Student workload

Course workload corresponds to approx. 81 hours of student work

Content scheduling

2st period 2023

Completion alternatives

Recognition of previous corresponding studies or work experience

Practical training and working life cooperation

-

International connections

-

Further information

-