Relational Databases (5cr)
Course unit code: HT00CF24
General information
- Credits
- 5 cr
- Teaching language
- Finnish
- Responsible person
- Jarkko Immonen
Objective
Purpose of the course
Almost all information systems need databases to process information content. For example, social media services store every messages and comments in databases. This course will introduce you to relational database technologies. You will learn how to design and create database and how to process the data stored.
Course competences
- Information System Competence: Is familiar with typical information systems and services and understands the importance of security in utilizing services.
- Application Development Competence: Knows the technologies used in application development and recognizes the significance of different technologies and their relationships.
- Software Engineering Competence: Is able to define, plan and/or implement software products.
- Operating in a workplace: Utilizes the opportunities offered by technology and digitalization in their work.
The learning objectives of the course
After completing the course, you understand the concepts and theories related to databases. You know the different application domains of relational databases. You are able to make data modeling and can create a database based on a data model. You know how to use SQL language to work with relational databases.
Content
The course covers, for example, the following topics:
- Concepts and background theories related to databases
- Database design and data modeling
- Implementing and using relational database
- SQL language
Assessment criteria, satisfactory (1)
Sufficient 1: You know the application domains and basic functions of relational database technologies. You know the basics of data modelling. You are able to create a database and perform queries.
Satisfactory 2: You know the application domains and basic functions of relational database technologies. You know the basics of data modelling. You are able to create a database and perform simple data processing operations.
Assessment criteria, good (3)
Good 3: You know the application domains and basic functions of relational database technologies. You understand the basics of conceptual modeling. You know how to implement a database based on the model. You know how to use the SQL language for maintenance and basic queries.
Very Good 4: You know the application domains and functions of relational database technologies. You are able to create a conceptual model of a narrow application area. You can implement a database based on the model. You know how to use the SQL language for maintenance and more complicated queries. You know the meaning of indexes and transactions.
Assessment criteria, excellent (5)
Excellent 5: You know the application domains and functions of relational database technologies. You are able to create a conceptual model of the application area can implement a suitable database for the application area. You master the SQL language and are able to apply it to generate the complex queries. You understand the importance of indexes and transactions and are able to utilize them in your work.