Skip to main content

Databases (3 cr)

Code: TT00CD81-3006

General information


Enrollment
18.11.2024 - 09.01.2025
Registration for the implementation has ended.
Timing
13.01.2025 - 30.04.2025
Implementation is running.
Number of ECTS credits allocated
3 cr
Local portion
0 cr
Virtual portion
3 cr
Mode of delivery
Online learning
Unit
School of Technology
Campus
Lutakko Campus
Teaching languages
Finnish
Seats
0 - 35
Degree programmes
Bachelor's Degree Programme in Information and Communications Technology
Teachers
Ari Rantala
Groups
TTV24SM
Tieto- ja viestintätekniikka (AMK)
ZJATTV24SM
Avoin amk, Tieto- ja viestintätekniikka, Monimuoto
Course
TT00CD81

Realization has 5 reservations. Total duration of reservations is 10 h 30 min.

Time Topic Location
Sat 25.01.2025 time 11:15 - 12:45
(1 h 30 min)
Tietokannat TT00CD81-3006
Verkko
Mon 17.02.2025 time 17:45 - 19:15
(1 h 30 min)
Tietokannat TT00CD81-3006
Verkko
Sat 22.03.2025 time 11:15 - 12:45
(1 h 30 min)
Tietokannat TT00CD81-3006
Verkko
Sat 26.04.2025 time 09:00 - 12:00
(3 h 0 min)
Tietokannat TT00CD81-3006
Verkko: OSAAMISTESTI opintojakson Teams-kanavalla
Sat 03.05.2025 time 09:00 - 12:00
(3 h 0 min)
Tietokannat TT00CD81-3006
Verkko: OSAAMISTESTIN UUSINTA opintojakson Teams-kanavalla
Changes to reservations may be possible.

Evaluation scale

0-5

Objective

You know the basic concepts of databases, you understand the generic structure of database system and its operational principle, you can read and create a database description based on the assignment, and you know the basics of SQL.

EUR-ACE Knowledge and Understanding
You know the basic structures and concepts of databases.

EUR-ACE Engineering practice
You know how to search for, modify and supplement information stored in the database using database queries.

Content

In this course you will learn the basic concepts of databases and understand the structure and principles of a database system. You will master the basics of the SQL language and be able to read and write database descriptions as required. You will learn how to retrieve, edit and complete information stored in a database using database queries. This course will give you a strong foundation in database management and use in practical applications.

Basic concepts related to databases
Database design with conceptual analysis
Basics of SQL including database queries and database management

Location and time

Etäopiskelu

Materials

Opintojakson verkkosivut (luentomateriaali, videoluennot, harjoitukset)

Teaching methods

Etäopiskelu (Videoluennot, omatoimiset harjoitukset, koe)

Exam schedules

Kokeen ajankohta ja toteutustapa ilmoitetaan opintojakson ensimmäisellä kerralla

Completion alternatives

Hyväksilukemisen menettelytavat kuvataan tutkintosäännössä ja opinto-oppaassa. Opintojakson opettaja antaa lisätietoa mahdollisista opintojakson erityiskäytänteistä.

Student workload

Etäopiskelu 81 h (Videoluennot, omatoimiset harjoitukset) Yhteensä 81 h

Assessment criteria, satisfactory (1)

Sufficient (1): You are able to design and implement a simple database by creating a connection between at least two tables using basic and reference keys and make simple queries with SQL. You have only completed a part of the course exercises.

Satisfactory (2): You are able to design and implement a database and make basic queries with SQL. The assignment documentation contains at the very least a database description. You have completed the most focal exercises of the course.

Assessment criteria, good (3)

Good (3): The database completed as assignment has been designed and implemented almost flawlessly and the student's command of SQL is versatile. You have completed the most part of the exercises in the course.

Very good (4): You are able to design and implement a database where the choices have been justified. You have a comprehensive understanding of SQL basic commands. The documentation of the assignment is thorough and the given presentation has been fluent. You have completed almost all course exercises.

Assessment criteria, excellent (5)

Excellent (5): You are able to design and implement database in which the content of the course has been widely applied. The choices have been justified and the metadata saved. You are able to use SQL in demanding data retrieval tasks. The database documentation is extensive and understandable as well as well composed and fluently presented. You are able to critically assess your competence in your solutions.

Further information

Arviointi tapahtuu palautettujen harjoitustehtävien ja kokeen mukaan.

Go back to top of page