Information Management and Databases (5 cr)

Learning outcomes

The student is able to
- design and implement databases
- manage and use databases
- use query languages to search and modify data in a database

Materials

- Luennot
- Harjoitukset
- Oma kannettava tietokone

Teaching methods

Contact sessions are based on guided workshops with the following format:
- Teacher's lecture to present the session's topics
- Hands-on exercises

Evaluation scale

H-5

Further information

During this course students will learn in a practical approach key concepts and methods related to information management and databases. Databases are important components in most of today's information systems and applications. The concepts, tools, and methods covered during this course are an essential knowledge base for anyone willing to have a career in the ICT field.
At the beginning of the course, students will be introduced to key concepts and get an overview of the subject. Later, students will get acquainted with relational databases and how to use the SQL query language to search and manipulate data from a database. NoSQL databases are also discussed during the course.

A virtual learning environment (Viope) is used to offer students the possibility to practice SQL in a flexible manner.

Contact sessions are mostly practice-based workshops guided by the teachers.