Skip to main content

Databases 1Laajuus (5 cr)

Code: TK00EC38

Credits

5 op

Teaching language

  • Finnish

Objective

You know how to design and implement relational databases.
You know how to design data models.
You can manage information content and run versatile queries on relational databases.

Content

How to design and implement appropriate relational databases?
How to design data models?
How is the relational database information queried and updated?

Enrollment

06.04.2023 - 21.04.2023

Timing

14.08.2023 - 17.12.2023

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

Department of Information Technology

Campus

Ecampus

Teaching languages
  • Finnish
Seats

20 - 50

Degree programmes
  • Degree Programme in Business Information Technology
Teachers
  • Heli Manninen
Teacher in charge

Timo Mynttinen

Groups
  • TKMI22SV
    Business Information Technology , online studies

Objective

You know how to design and implement relational databases.
You know how to design data models.
You can manage information content and run versatile queries on relational databases.

Content

How to design and implement appropriate relational databases?
How to design data models?
How is the relational database information queried and updated?

Opiskelumateriaali

Will be presented in learning environment.

Yksilölliset oppimisväylät

Online studies during course implementation. Previous higher education studies may replace the course and can be discussed at the beginning of the course implementation.

TKI ja työelämäyhteistyö

-

Opiskelijan työmäärä

135 h

Evaluation scale

1-5

Assessment methods and criteria

Exercises returned in learning environment.

Enrollment

07.11.2022 - 18.11.2022

Timing

09.01.2023 - 28.04.2023

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

Department of Information Technology

Campus

Ecampus

Teaching languages
  • Finnish
Seats

20 - 35

Degree programmes
  • Degree Programme in Business Information Technology
Teachers
  • Timo Mynttinen
Teacher in charge

Timo Mynttinen

Groups
  • TKMI22KV
    Business Information Technology, online studies

Objective

You know how to design and implement relational databases.
You know how to design data models.
You can manage information content and run versatile queries on relational databases.

Content

How to design and implement appropriate relational databases?
How to design data models?
How is the relational database information queried and updated?

Opiskelumateriaali

Slides published on the Learn platform, in addition to online material. Details are to be settled at the course kick off.

Yksilölliset oppimisväylät

The Learn platform has all the material - or you can find the necessary addresses there. Tasks to be returned must be solved within a certain schedule, but otherwise you can solve them on your own timetable. The date of the exam will be announced later.

TKI ja työelämäyhteistyö

Does not include, 0 points.

Opiskelijan työmäärä

The scope of the course is 5 credits and that means 135 hours of work for you. You use part of it to solve practice problems and part of it to prepare for the exam.

Evaluation scale

1-5

Assessment methods and criteria

The exercises to be returned are evaluated on a pass/fail scale. There is one exam at the end of the course. The details of the assessment will become clear at the beginning of the study period.

Enrollment

06.04.2022 - 22.04.2022

Timing

15.08.2022 - 18.12.2022

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

Department of Information Technology

Campus

Ecampus

Teaching languages
  • Finnish
Seats

20 - 30

Degree programmes
  • Degree Programme in Business Information Technology
Teachers
  • Timo Mynttinen
Groups
  • TKMI21SV
    Business Information Technology, online studies

Objective

You know how to design and implement relational databases.
You know how to design data models.
You can manage information content and run versatile queries on relational databases.

Content

How to design and implement appropriate relational databases?
How to design data models?
How is the relational database information queried and updated?

Opiskelumateriaali

Learn-alustalla julkaistut diat, tämän lisäksi nettimateriaali. Yksityiskohdat selviävät opintojakson alussa.

Yksilölliset oppimisväylät

Learn-alustalla on kaikki materiaali - tai sieltä löytyvät tarvittavat osoitteet. Palautettavat tehtävät tulee ratkaista tietyssä aikataulussa, mutta ne voi muuten ratkoa omaan aikatauluunsa. Tentin ajankohta ilmoitetaan myöhemmin.

TKI ja työelämäyhteistyö

Ei sisällä, 0 op.

Opiskelijan työmäärä

Opintojakson laajuus on 5 op ja se tarkoittaa sinulle 135h työskentelyä. Osan käytät harjoitustehtävien ratkomiseen ja osan tenttiin valmistautumiseen.

Evaluation scale

1-5

Assessment methods and criteria

Palautettavat harjoitustyöt arvioidaan skaalalla hyväksytty/hylätty. Opintojakson loppupäässä on yksi tentti. Arvioinnin yksityiskohdat selviävät opintojakson alussa.