Siirry suoraan sisältöön

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

  • ICTSUMMER
    ICT 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.