VAMK

Vaihda kieltä: English

Etusivu > Opintohaku > Databases and Open Interfaces (IITB8004)

Databases and Open Interfaces

Rakennetyyppi: Opintojakso
Koodi: IITB8004
Tyyppi: Pakollinen / Perusopinnot
OPS: IT 2016 / 2017 / 2018 / 2019 / 2020 / 2021
Taso: Insinööri (AMK)
Opiskeluvuosi: 2 (2017-2018 / 2018-2019 / 2019-2020 / 2020-2021 / 2021-2022 / 2022-2023)
Laajuus: 5 op
Vastuuopettaja: Kankaanpää, Timo
Opetuskieli: Englanti

Toteutukset

Tot.Ryhmä(t)OpiskeluaikaOpettaja(t)KieliIlmoittautuminen
1I-IT-2N23.10.2017 – 23.2.2018Timo KankaanpääEnglanti22.8.2017 – 18.9.2017
2I-IT-2N7.1.2019 – 27.4.2019Anna-Kaisa Saari, Timo KankaanpääEnglanti10.12.2018 – 14.1.2019
3I-IT-2N21.10.2019 – 21.2.2020Timo KankaanpääEnglanti19.8.2019 – 9.9.2019
3001IT2019-2, IT2019-2A, IT2019-2B, IT2019-2C, IT2019-2D19.10.2020 – 28.2.2021Timo KankaanpääEnglanti17.8.2020 – 11.9.2020
3002IT2020-2, IT2020-2A, IT2020-2B, IT2020-2C, IT2020-2D25.10.2021 – 27.2.2022Timo KankaanpääEnglanti1.8.2021 – 6.9.2021
3003IT2021-2, IT2021-2A, IT2021-2B, VY-2-ICAT, VY-2-TJT24.10.2022 – 25.2.2023 Englanti1.8.2022 – 6.9.2022

Alla oleva kuvaus koskee lukuvuotta: 2022-2023

Osaamistavoitteet

After the course, the student understands the principle of the relation data base, she is able to design and implement an effective relation data base and she knows how to use the SQL inquiry language in a versatile way. The student knows the programming interfaces of SQL, she understands the principles of XML and she is able to utilize XML.

Opiskelijan työmäärä

135 h, which includes 70 h of scheduled contact studies at VAMK and 48 h at UVA.
The assessment of student’s own learning 1 h is included in contact lessons.

Edeltävät opinnot / Suositellut valinnaiset opinnot

Introduction to Programming, Object Oriented Programming.

Sisältö

Relation algebra, functional relationships, normalizing, a data base software and the most important tools (e.g. MySQL, SQLite, SQLite Studio, SQL Server, Oracle), SQL (create, insert, drop, undate, select, join, union, subinquires, indexes, transactions, limits, triggers, views) and the interfaces of SQL (ORM, CRUD). Further, the basics of XML and the techiques realeted with its use (XSD, Xpath, XSLT) and the basics of the NoSQL data bases.

Opiskelumateriaali

The web site of the course.

Opetusmuoto / Opetusmenetelmät

Lectures, exercises.

Arviointikriteerit

Grade 5: The student understands most of the discussed concepts, she can choose and apply them in a critical manner while designing, developing and building a practical application.
Grade 3: The student understands a significant amount of the discussed concepts, she can apply them while designing, developing and building a practical application.
Grade 1: The student understands the basic concepts discussed on the course and with guidance, she can use them while designing and building a practical application.

Arviointimenetelmät

Continuous assessment, the grade results in from homework assignments, project works and the examination.


Takaisin