Databases and SQLLaajuus (5 cr)

Objective

You understand the operating principles and purposes of relational databases.
You are able to search, filter, and parse data in a relational database using the SQL language.
You recognise the uses and possibilities of the SQL language.

Content

What are the operating principles of relational databases?
How do you make a connection to a relational database?
How can the SQL language be used to search for and modify the data needed for analysis?

Evaluation

Students can

a. use professional vocabulary systematically
c. identify interrelated tasks
e. use the key models, methods, software and techniques of the data analytics