Skip to main content

SQL and Relational Databases (3 cr)

Code: TT00CB01-3073

General information


Enrollment
02.07.2024 - 31.07.2024
Registration for the implementation has ended.
Timing
01.01.2024 - 31.07.2024
Implementation has ended.
Number of ECTS credits allocated
3 cr
Local portion
0 cr
Virtual portion
3 cr
Mode of delivery
Online
Unit
(2019-2024) School of ICT
Campus
Karaportti 2
Teaching languages
Finnish
Degree programmes
Information and Communication Technology
Teachers
Janne Salonen
Teacher in charge
Janne Salonen
Groups
Viope_nonstop_11
Viope_nonstop_11
Course
TT00CB01
No reservations found for implementation TT00CB01-3073!

Objective

After the course, a student has ability to understand and maintain SQL and relational databases

Content

- Introduciton to relational databases, basics of relational model, introduction to SQL, planning and creating a database, tools

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, satisfactory (1)

aradigm:
- the student understands what relation applied to databases is, understands normalization and is able to do the normalization with the instructor's help;
syntax:
- the student understands SQL syntax and is able to write simple SQL syntax with the instructor's help;
queries and result arrangement:
- the student understands what SQL queries and result arrangements are and is able to write and use them with the instructor's help;
database modification:
- the student understands what INSERT, UPDATE & DELETE are and is able to write and use them with the instructor's help;

Assessment criteria, good (3)

paradigm:
- the student understands what relation applied to databases is, understands normalization and is able to do the normalization;
- the student shows independent solutions.
syntax:
- the student understands SQL syntax and is able to write simple SQL syntax;
- the student shows independent solutions.
queries and result arrangement:
- the student understands what SQL queries and result arrangements are and is able to write and use them;
- the student shows independent solutions.
database modification:
- the student understands what INSERT, UPDATE & DELETE are and is able to write and use them;
- the student shows independent solutions.

Assessment criteria, excellent (5)

paradigm:
- the student understands what relation applied to databases is, understands normalization and is able to do the normalization;
- the student shows independent solutions and critical evaluation.
syntax:
- the student understands SQL syntax and is able to write simple SQL syntax;
- the student shows independent solutions and critical evaluation.
queries and result arrangement:
- the student understands what SQL queries and result arrangements are and is able to write and use them;
- the student shows independent solutions and critical evaluation.
database modification:
the student understands what INSERT, UPDATE & DELETE are and is able to write and use them;
- the student shows independent solutions and critical evaluation.

Go back to top of page