SQL and Relational Databases (3 op)
Toteutuksen tunnus: TT00CB01-3074
Toteutuksen perustiedot
- Ilmoittautumisaika
-
02.07.2024 - 31.07.2024
Ilmoittautuminen toteutukselle on päättynyt.
- Ajoitus
-
01.01.2024 - 31.07.2024
Toteutus on päättynyt.
- Opintopistemäärä
- 3 op
- Lähiosuus
- 0 op
- Virtuaaliosuus
- 3 op
- Toteutustapa
- Etäopetus
- Yksikkö
- (2019-2024) ICT ja tuotantotalous
- Toimipiste
- Karaportti 2
- Opetuskielet
- suomi
- Koulutus
- Tieto- ja viestintätekniikan tutkinto-ohjelma
- Opettajat
- Janne Salonen
- Vastuuopettaja
- Janne Salonen
- Ryhmät
-
Viope_nonstop_12Viope_nonstop_12
- Opintojakso
- TT00CB01
Tavoitteet
After the course, a student has ability to understand and maintain SQL and relational databases
Sisältö
- Introduciton to relational databases, basics of relational model, introduction to SQL, planning and creating a database, tools
Arviointiasteikko
Hyväksytty/Hylätty
Arviointikriteerit, tyydyttävä (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;
Arviointikriteerit, hyvä (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.
Arviointikriteerit, kiitettävä (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.