Data Systems (5op)

Osaamistavoitteet (Opintojakso)

The student learns basic concepts, ideas and principles concerning database systems including big data systems. The student can install, configure and run a relational database system and to design and implement data content to it and handle it with SQL language. The student can install, configure and run a NoSQL database system and to design and implement data content to it and handle it with queries. The student knows required concepts to be able to exploit big data systems.

Sisältö (Opintojakso)

Course content is:
- General ideas of a database system,
- Data modelling and design techniques,
- Relational model, data handling with SQL language,
- Database programming,
- NoSQL databases
- General ideas of a big data system

Arviointikriteerit, tyydyttävä (1-2) (Opintojakso)

The student knows basics idea of a database system. The student can use a data modelling and design technique. The student can implement a simple relational database model and can implement simple data handling with SQL language. The student can implement a solution with database programming with guidance. The student knows some principles and can use a NoSQL database as data storage/source with guidance.

Arviointikriteerit, hyvä (3-4) (Opintojakso)

The student knows the general ideas of a database system. The student can use some data modelling and design techniques. The student can implement a relational database model and can implement basic data handling with SQL language. The student can implement a solution with database programming. The student knows the principles and can use a NoSQL database as data storage/source. The student is aware of the general ideas of a big data system.

Arviointikriteerit, kiitettävä (5) (Opintojakso)

The student knows comprehensively the general ideas of a database system. The student can exploit data modelling and design techniques. The student can implement a complex relational database model and can implement required data handling with SQL language. The student can implement different solutions with database programming. The student knows well the principles and can exploit NoSQL databases as data storage/source. The student knows the general ideas of a big data system.

Tenttien ja uusintatenttien ajankohdat

No exam.

Arviointimenetelmät ja arvioinnin perusteet

Assignment and presentation scores and the related activity.

Arviointiasteikko

0-5

Opiskelumuodot ja opetusmenetelmät

Contact teaching
Assignments (the primary learning method)
Group work and presentation

Oppimateriaalit

Moodle course with links to additional material.

Opiskelijan ajankäyttö ja kuormitus

See the period timetable. See the Moodle course for instructions when and how to attend the contact teaching hours.