Relational Databases (5 cr)
Code: R504D66-3001
General information
- Enrollment
-
14.03.2022 - 29.08.2022
Registration for the implementation has ended.
- Timing
-
05.09.2022 - 23.10.2022
Implementation has ended.
- Number of ECTS credits allocated
- 5 cr
- Local portion
- 2 cr
- Virtual portion
- 3 cr
- RDI portion
- 1 cr
- Mode of delivery
- Blended learning
- Unit
- Bachelor of Engineering, Information Technology
- Teaching languages
- English
- Seats
- 0 - 30
- Degree programmes
- Machine Learning and Data Engineering
- Teachers
- Aku Kesti
- Teacher in charge
- Aku Kesti
- Groups
-
R54D21SBachelor of Engineering, Machine Learning and Data Engineering (full time studies), 2021
- Course
- R504D66
Evaluation scale
H-5
Content scheduling
General about SQL Databases
Tables
Queries and Changing the data
Filtering
Aggregate functions
Dataset operation
Sorting and Grouping
Working with multiple tables
Database design and modeling
Other option, NOSQL
Objective
The student knows the principles of relational databases and is capable to design a relational database and apply it in practice to information management.
Content
- Concept analysis
- Relational Models
- Basics of SQL commands (SELECT, DML, DDL)
Location and time
Lessons and code labs are hold in the computer class rooms at Rantavitikka campus in the autumn 2022.
Materials
Materials in our learning environment, moodle. In addition you can use the literature to support your learning. For example:
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing
Author: Shields, Walter
The Art of SQL
Author:Faroult, Stephane
Teaching methods
Lectures, assignments and tutorials. Inn addition code labs which are meant for tutoring the exercises.
International connections
The study unit will be taught in English and makes it possible for international students to join
Student workload
There will be 11 teaching sessions. Each session will take from 3 to 4 hours. In addition the student must complete the exercises on his / her own time which will take approximately 40 hours. Studying and deepening theoretical knowledge will also take about 40 hours.
Assessment criteria, satisfactory (1)
The student knows the structure of a relational database.
The student can utilize simple SQL statements in database processing.
Assessment criteria, good (3)
The student outlines the principles of relational databases.
The student can complete a concept analysis, create a relational database model and utilize the most common SQL statements in data management.
Assessment criteria, excellent (5)
The student can perform concept analysis and create a context-based relational database model.
The student can use SQL commands in a versatile manner in database processing.