SQL and Relational Databases (3 cr)
Code: TT00CB01-3067
General information
Timing
16.04.2024 - 31.12.2025
Number of ECTS credits allocated
3 op
Virtual portion
3 op
Mode of delivery
Distance learning
Unit
School of ICT
Campus
Karaportti 2
Teaching languages
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Virve Prami
Teacher in charge
Janne Salonen
Groups
-
VIOPE_2025_MAKSULLINEN_JARJESTELMAOpen UAS 2025
-
VIOPE_2024_MAKSULLINEN_JARJESTELMAViope TiVi (NonStop), year 2024
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
Location and time
Up to Student her-/himself.
Materials
Online
Teaching methods
100% online (Self-Study) course.
Employer connections
N/A
Exam schedules
Can be find on study environment.
International connections
N/A
Completion alternatives
N/A
Student workload
Up to Student her-/himself.
Content scheduling
Up to Student her-/himself.
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.
Assessment methods and criteria
Pass, after Student have done 80% or more of the course.