Data Systems (5cr)

Objectives (course unit)

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.

Content (course unit)

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

Assessment criteria, satisfactory (1-2) (course unit)

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.

Assessment criteria, good (3-4) (course unit)

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.

Assessment criteria, excellent (5) (course unit)

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.

Exam schedules

No exam.

Assessment methods and criteria

Assignment and presentation scores and the related activity.

Assessment scale

0-5

Teaching methods

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

Learning materials

Moodle course with links to additional material.

Student workload

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