Databases and Open Interfaces
Rakennetyyppi: | Opintojakso |
---|---|
Koodi: | IITB8004 |
OPS: | IT 2022 |
Taso: | Insinööri (AMK) |
Opiskeluvuosi: | 3 (2024-2025) |
Lukukausi: | Syksy |
Laajuus: | 5 op |
Vastuuopettaja: | Kankaanpää, Timo |
Opetuskieli: | Englanti |
Suoritus ennakkoon? Katso toteutukset lukuvuonna 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. The student also knows how to build a modern microservice back end based on RESful or GraphQL architecture.
Opiskelijan työmäärä
135 h, which includes 50 h of scheduled contact studies at VAMK.
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ö
SQL, query, insert and update data. Normalizing the database. Use of DBMS and the most important tools (e.g. MySQL, SQLite, SQLite Studio, SQL Server, Oracle), SQL (create, insert, drop, update, 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. Student will create a microservice backend either using RESTful or GraphQL libraries.
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.