SQL ja relaatiotietokannat (3 cr)
Code: TT00VI04-3002
General information
Enrollment
02.05.2019 - 18.08.2019
Timing
19.08.2019 - 23.08.2019
Number of ECTS credits allocated
3 op
Mode of delivery
Contact teaching
Unit
ICT ja tuotantotalous
Campus
Leiritie 1
Teaching languages
- English
Seats
0 - 24
Degree programmes
- Degree Programme in Information Technology
- Tieto- ja viestintätekniikan tutkinto-ohjelma
Teachers
- Frank Brandse
- Antti Piironen
Groups
-
ICTSUMMERICT Summer School
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
0-5
Assessment criteria, satisfactory (1)
paradigm:
- 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.