Data Systems and AnalysisLaajuus (5 cr)

Objectives

The student learns basic concepts, ideas and principles concerning database systems including big data systems. The student is able to install, configure and run a database system and to design and implement data content to it and handle it with SQL language. General big data system concepts are handled; the aim is that the student can install, configure and run a big data system and handle it’s data. Some of the most popular big data technologies are learned.

Content

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
- CRISP DM

Assessment criteria, satisfactory (1-2)

Student knows database system concepts and ideas and recognises them in real running systems. The student is able to do modest maintenance works for existing database systems and participate partly in the design of new database systems.

Assessment criteria, good (3-4)

Student understands database system concepts and ideas and can justify their existence in real running systems. The student is able to maintain existing database system structures and design of new database system parts.

Assessment criteria, excellent (5)

Student knows and understands in depth database system concepts and ideas and is familiar with their existence in real running systems. The student is able to create new database system structures and make new designs in all areas of the database systems.