SQL and Relational Databases (3 cr)
Code: TT00CB01-3076
General information
- Timing
-
01.08.2024 - 30.07.2025
Implementation is running.
- Number of ECTS credits allocated
- 3 cr
- Virtual portion
- 3 cr
- Mode of delivery
- Online
- Unit
- (2019-2024) School of ICT
- Campus
- Karaportti 2
- Teaching languages
- English
- Degree programmes
- Information and Communication Technology
- Teachers
- Janne Salonen
- Teacher in charge
- Janne Salonen
- Groups
-
Viope_nonstop_14Viope_nonstop_14
- Course
- TT00CB01
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.