Databases and SQLLaajuus (5 cr)
Code: 5G00HF75
Credits
5 op
Objectives
The student is familiar with the design and implementation of relational databases.
The student understands the role of databases as a technical data repository and learns to retrieve data from a database
The student is able to export data from a database, which can be further processed using, for example, data analytics or artificial intelligence methods.
The student learns the SQL query language, which is used to process data in relational databases. The student is able to add, read, update and delete data in databases.
Content
Design and implementation of relational databases and the SQL language. Relational database management system, its operation and data processing using it.
Assessment criteria, satisfactory (1-2)
The student is able to design and implement a relational database and perform SQL queries on the database.
Assessment criteria, good (3-4)
The student is able to design and implement a relational database and perform SQL queries on the database. The student is able to take data snapshots from the database.
Assessment criteria, excellent (5)
The student is able to design and implement a relational database and perform a variety of SQL queries on the database. The student is able to take data snapshots from the database based on SQL queries.