Siirry suoraan sisältöön

SQL and Relation Databases (3 op)

Toteutuksen tunnus: TT00CB01-3007

Toteutuksen perustiedot


Ilmoittautumisaika

05.05.2019

Ajoitus

01.01.2020 - 31.12.2020

Opintopistemäärä

3 op

Virtuaaliosuus

3 op

Toteutustapa

Etäopetus

Yksikkö

ICT ja tuotantotalous

Toimipiste

Karaportti 2

Opetuskielet

  • Englanti

Paikat

0 - 3000

Koulutus

  • Tieto- ja viestintätekniikan tutkinto-ohjelma

Opettaja

  • Mika Hyyryläinen

Ryhmät

  • ATX20TV
    Avoin amk - NonStop vuosi 2020

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

Aika ja paikka

Riippuu opiskelijasta itsestään.

Oppimateriaalit

Löytyy kurssiympäristöstä.

Opetusmenetelmät

100% netin kautta itsenäisesti suoritettava kurssi.

Harjoittelu- ja työelämäyhteistyö

N/A

Tenttien ajankohdat ja uusintamahdollisuudet

N/A

Kansainvälisyys

N/A

Toteutuksen valinnaiset suoritustavat

N/A

Opiskelijan ajankäyttö ja kuormitus

Riippuu opiskelijasta itsestään.
p to Student her-/himself.

Sisällön jaksotus

Riippuu opiskelijasta itsestään.

Lisätietoja opiskelijoille

ENROLLING
Open UAS and CampusOnline Student: Please fill in eform

Metropolia's Degree Student: https://vw4.viope.com/login?org=metropolia
- Register to system -> Click the link “Enroll on the course”
- Choose any course of (NonStop)
- Fill the others fields

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.

Arviointimenetelmät ja arvioinnin perusteet

Pass, after Student have done 80% or more of the course.