Opinto-opas

Osaamistavoitteet

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ö

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)

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)

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)

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.