Skip to main content

Basics of DatabasesLaajuus (4 cr)

Code: TSAT0520

Credits

4 op

Teaching language

  • Finnish

Responsible person

  • Antti Häkkinen

Objective

Student gets familiar with databases to the extent necessary from the point of view of electrical and automation technology. By this course, the student has a basic understanding of databases.

EUR-ACE KNOWLEDGE AND UNDERSTANDING
Student is familiar with the basic structures and terminology of databases.

EUR-ACE APPLYING TECHNOLOGY INTO PRACTICE
Student is able to retrieve, edit and append the information stored in the database using database queries.

Content

Basic queries to databases
Application of the database
Understanding the concept model

Qualifications

-

Assessment criteria, satisfactory (1)

Sufficient (1): Student recognizes the basics and terminology, but has shortcomings in understanding the key issues.

Satisfactory (2): Student knows the basics and terminology, but has shortcomings in the application of key issues.

Assessment criteria, good (3)

Good (3): Student is familiar with basic database queries and working with them. Student is able to apply the theory learnt from databases to practice and understand the concept model.

Very good (4): Student knows the key subjects and is able to apply them in different implementations.

Assessment criteria, excellent (5)

Excellent (5): Student masters key subjects and is able to apply them creatively and innovatively.

Enrollment

01.11.2024 - 09.01.2025

Timing

01.01.2025 - 18.05.2025

Number of ECTS credits allocated

4 op

Mode of delivery

Face-to-face

Unit

School of Technology

Campus

Main Campus

Teaching languages
  • Finnish
Degree programmes
  • Bachelor's Degree Programme in Electrical and Automation Engineering
Teachers
  • Juho Pekki
Groups
  • TSA24KMS
    Insinööri (AMK), sähkö- ja automaatiotekniikka,monimuototeutus
  • TSA24KMA
    Insinööri (AMK), sähkö- ja automaatiotekniikka,monimuototeutus

Objectives

Student gets familiar with databases to the extent necessary from the point of view of electrical and automation technology. By this course, the student has a basic understanding of databases.

EUR-ACE KNOWLEDGE AND UNDERSTANDING
Student is familiar with the basic structures and terminology of databases.

EUR-ACE APPLYING TECHNOLOGY INTO PRACTICE
Student is able to retrieve, edit and append the information stored in the database using database queries.

Content

Basic queries to databases
Application of the database
Understanding the concept model

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Sufficient (1): Student recognizes the basics and terminology, but has shortcomings in understanding the key issues.

Satisfactory (2): Student knows the basics and terminology, but has shortcomings in the application of key issues.

Evaluation criteria, good (3-4)

Good (3): Student is familiar with basic database queries and working with them. Student is able to apply the theory learnt from databases to practice and understand the concept model.

Very good (4): Student knows the key subjects and is able to apply them in different implementations.

Evaluation criteria, excellent (5)

Excellent (5): Student masters key subjects and is able to apply them creatively and innovatively.

Prerequisites

-

Enrollment

01.08.2024 - 22.08.2024

Timing

26.08.2024 - 08.12.2024

Number of ECTS credits allocated

4 op

Mode of delivery

Face-to-face

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • Finnish
Seats

20 - 35

Degree programmes
  • Bachelor's Degree Programme in Electrical and Automation Engineering
Teachers
  • Antti Häkkinen
Groups
  • TSA23SA
    Insinööri (AMK), sähkö- ja automaatiotekniikka, päivätoteutus

Objectives

Student gets familiar with databases to the extent necessary from the point of view of electrical and automation technology. By this course, the student has a basic understanding of databases.

EUR-ACE KNOWLEDGE AND UNDERSTANDING
Student is familiar with the basic structures and terminology of databases.

EUR-ACE APPLYING TECHNOLOGY INTO PRACTICE
Student is able to retrieve, edit and append the information stored in the database using database queries.

Content

Basic queries to databases
Application of the database
Understanding the concept model

Learning materials and recommended literature

Materials in the e-learning environment.

Teaching methods

- weekly lectures in campus
- independent study
- distance learning
- small group learning
- exercises

Exam dates and retake possibilities

The possible date and method of the exam will be announced in the course opening.

Alternative completion methods

The admission procedures are described in the degree rule and the study guide. The teacher of the course will give you more information on possible specific course practices.

Student workload

One credit (1 Cr) corresponds to an average of 27 hours of work.

- lectures 30 h
- exercises 50 h
- preparing for the exam 28 h
Total 108 h

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Sufficient (1): Student recognizes the basics and terminology, but has shortcomings in understanding the key issues.

Satisfactory (2): Student knows the basics and terminology, but has shortcomings in the application of key issues.

Evaluation criteria, good (3-4)

Good (3): Student is familiar with basic database queries and working with them. Student is able to apply the theory learnt from databases to practice and understand the concept model.

Very good (4): Student knows the key subjects and is able to apply them in different implementations.

Evaluation criteria, excellent (5)

Excellent (5): Student masters key subjects and is able to apply them creatively and innovatively.

Prerequisites

-

Enrollment

01.08.2024 - 19.08.2024

Timing

26.08.2024 - 08.12.2024

Number of ECTS credits allocated

4 op

Mode of delivery

Face-to-face

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • English
Seats

20 - 35

Degree programmes
  • Bachelor's Degree Programme in Electrical and Automation Engineering
Teachers
  • Antti Häkkinen
Groups
  • TAR23S1
    Bachelor's Degree Programme in Automation and Robotics

Objectives

Student gets familiar with databases to the extent necessary from the point of view of electrical and automation technology. By this course, the student has a basic understanding of databases.

EUR-ACE KNOWLEDGE AND UNDERSTANDING
Student is familiar with the basic structures and terminology of databases.

EUR-ACE APPLYING TECHNOLOGY INTO PRACTICE
Student is able to retrieve, edit and append the information stored in the database using database queries.

Content

Basic queries to databases
Application of the database
Understanding the concept model

Learning materials and recommended literature

Materials in the e-learning environment.

Teaching methods

- weekly lectures in campus
- independent study
- distance learning
- small group learning
- exercises

Exam dates and retake possibilities

The possible date and method of the exam will be announced in the course opening.

Alternative completion methods

The admission procedures are described in the degree rule and the study guide. The teacher of the course will give you more information on possible specific course practices.

Student workload

One credit (1 Cr) corresponds to an average of 27 hours of work.

- lectures 30 h
- exercises 50 h
- preparing for the exam 28 h
Total 108 h

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Sufficient (1): Student recognizes the basics and terminology, but has shortcomings in understanding the key issues.

Satisfactory (2): Student knows the basics and terminology, but has shortcomings in the application of key issues.

Evaluation criteria, good (3-4)

Good (3): Student is familiar with basic database queries and working with them. Student is able to apply the theory learnt from databases to practice and understand the concept model.

Very good (4): Student knows the key subjects and is able to apply them in different implementations.

Evaluation criteria, excellent (5)

Excellent (5): Student masters key subjects and is able to apply them creatively and innovatively.

Prerequisites

-

Enrollment

01.08.2024 - 22.08.2024

Timing

26.08.2024 - 08.12.2024

Number of ECTS credits allocated

4 op

Mode of delivery

Face-to-face

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • Finnish
Seats

20 - 35

Degree programmes
  • Bachelor's Degree Programme in Electrical and Automation Engineering
Teachers
  • Antti Häkkinen
Groups
  • TSA23SS
    Insinööri (AMK), sähkö- ja automaatiotekniikka, päivätoteutus

Objectives

Student gets familiar with databases to the extent necessary from the point of view of electrical and automation technology. By this course, the student has a basic understanding of databases.

EUR-ACE KNOWLEDGE AND UNDERSTANDING
Student is familiar with the basic structures and terminology of databases.

EUR-ACE APPLYING TECHNOLOGY INTO PRACTICE
Student is able to retrieve, edit and append the information stored in the database using database queries.

Content

Basic queries to databases
Application of the database
Understanding the concept model

Learning materials and recommended literature

Materials in the e-learning environment.

Teaching methods

- weekly lectures in campus
- independent study
- distance learning
- small group learning
- exercises

Exam dates and retake possibilities

The possible date and method of the exam will be announced in the course opening.

Alternative completion methods

The admission procedures are described in the degree rule and the study guide. The teacher of the course will give you more information on possible specific course practices.

Student workload

One credit (1 Cr) corresponds to an average of 27 hours of work.

- lectures 30 h
- exercises 50 h
- preparing for the exam 28 h
Total 108 h

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Sufficient (1): Student recognizes the basics and terminology, but has shortcomings in understanding the key issues.

Satisfactory (2): Student knows the basics and terminology, but has shortcomings in the application of key issues.

Evaluation criteria, good (3-4)

Good (3): Student is familiar with basic database queries and working with them. Student is able to apply the theory learnt from databases to practice and understand the concept model.

Very good (4): Student knows the key subjects and is able to apply them in different implementations.

Evaluation criteria, excellent (5)

Excellent (5): Student masters key subjects and is able to apply them creatively and innovatively.

Prerequisites

-

Enrollment

20.11.2023 - 04.01.2024

Timing

08.01.2024 - 19.05.2024

Number of ECTS credits allocated

4 op

Virtual portion

2 op

Mode of delivery

50 % Face-to-face, 50 % Online learning

Unit

School of Technology

Campus

Main Campus

Teaching languages
  • Finnish
Degree programmes
  • Bachelor's Degree Programme in Electrical and Automation Engineering
Teachers
  • Ari Rantala
Groups
  • TSA23KMS
    Insinööri (AMK), sähkö- ja automaatiotekniikka,monimuototeutus
  • TSA23KMA
    Insinööri (AMK), sähkö- ja automaatiotekniikka,monimuototeutus

Objectives

Student gets familiar with databases to the extent necessary from the point of view of electrical and automation technology. By this course, the student has a basic understanding of databases.

EUR-ACE KNOWLEDGE AND UNDERSTANDING
Student is familiar with the basic structures and terminology of databases.

EUR-ACE APPLYING TECHNOLOGY INTO PRACTICE
Student is able to retrieve, edit and append the information stored in the database using database queries.

Content

Basic queries to databases
Application of the database
Understanding the concept model

Learning materials and recommended literature

Opintojakson verkkosivut (verkkomateriaali, videomateriaali, harjoitustehtävät)

Teaching methods

Luennot 24 h harjoitukset 56 h itsenäinen työskentely 28 h Yhteensä 108 h

Student workload

Luennot 24 h harjoitukset 56 h itsenäinen työskentely 28 h Yhteensä 108 h

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Sufficient (1): Student recognizes the basics and terminology, but has shortcomings in understanding the key issues.

Satisfactory (2): Student knows the basics and terminology, but has shortcomings in the application of key issues.

Evaluation criteria, good (3-4)

Good (3): Student is familiar with basic database queries and working with them. Student is able to apply the theory learnt from databases to practice and understand the concept model.

Very good (4): Student knows the key subjects and is able to apply them in different implementations.

Evaluation criteria, excellent (5)

Excellent (5): Student masters key subjects and is able to apply them creatively and innovatively.

Prerequisites

-

Enrollment

01.08.2023 - 24.08.2023

Timing

01.08.2023 - 19.12.2023

Number of ECTS credits allocated

4 op

Mode of delivery

Face-to-face

Unit

School of Technology

Campus

Main Campus

Teaching languages
  • Finnish
Degree programmes
  • Bachelor's Degree Programme in Electrical and Automation Engineering
Teachers
  • Antti Häkkinen
Groups
  • TSA22SS
    Sähkö- ja automaatiotekniikka (AMK)
  • TSA22SA
    Sähkö- ja automaatiotekniikka (AMK)

Objectives

Student gets familiar with databases to the extent necessary from the point of view of electrical and automation technology. By this course, the student has a basic understanding of databases.

EUR-ACE KNOWLEDGE AND UNDERSTANDING
Student is familiar with the basic structures and terminology of databases.

EUR-ACE APPLYING TECHNOLOGY INTO PRACTICE
Student is able to retrieve, edit and append the information stored in the database using database queries.

Content

Basic queries to databases
Application of the database
Understanding the concept model

Learning materials and recommended literature

Materials in the e-learning environment.

Teaching methods

- weekly lectures in campus
- independent study
- distance learning
- small group learning
- exercises

Exam dates and retake possibilities

The possible date and method of the exam will be announced in the course opening.

Alternative completion methods

The admission procedures are described in the degree rule and the study guide. The teacher of the course will give you more information on possible specific course practices.

Student workload

One credit (1 Cr) corresponds to an average of 27 hours of work.

- lectures 30 h
- exercises 50 h
- preparing for the exam 28 h
Total 108 h

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Sufficient (1): Student recognizes the basics and terminology, but has shortcomings in understanding the key issues.

Satisfactory (2): Student knows the basics and terminology, but has shortcomings in the application of key issues.

Evaluation criteria, good (3-4)

Good (3): Student is familiar with basic database queries and working with them. Student is able to apply the theory learnt from databases to practice and understand the concept model.

Very good (4): Student knows the key subjects and is able to apply them in different implementations.

Evaluation criteria, excellent (5)

Excellent (5): Student masters key subjects and is able to apply them creatively and innovatively.

Prerequisites

-

Enrollment

01.08.2023 - 24.08.2023

Timing

01.08.2023 - 31.12.2023

Number of ECTS credits allocated

4 op

Mode of delivery

Face-to-face

Unit

School of Technology

Campus

Main Campus

Teaching languages
  • English
Degree programmes
  • Bachelor's Degree Programme in Electrical and Automation Engineering
Teachers
  • Antti Häkkinen
Groups
  • TAR22S1
    Bachelor's Degree Programme in Automation and Robotics

Objectives

Student gets familiar with databases to the extent necessary from the point of view of electrical and automation technology. By this course, the student has a basic understanding of databases.

EUR-ACE KNOWLEDGE AND UNDERSTANDING
Student is familiar with the basic structures and terminology of databases.

EUR-ACE APPLYING TECHNOLOGY INTO PRACTICE
Student is able to retrieve, edit and append the information stored in the database using database queries.

Content

Basic queries to databases
Application of the database
Understanding the concept model

Learning materials and recommended literature

Materials in the e-learning environment.

Teaching methods

- lectures
- independent study
- distance learning
- small group learning
- exercises

Exam dates and retake possibilities

The possible date and method of the exam will be announced in the course opening.

Alternative completion methods

The admission procedures are described in the degree rule and the study guide. The teacher of the course will give you more information on possible specific course practices.

Student workload

One credit (1 Cr) corresponds to an average of 27 hours of work.

- lectures 30 h
- exercises 50 h
- preparing for the exam 28 h
Total 108 h

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Sufficient (1): Student recognizes the basics and terminology, but has shortcomings in understanding the key issues.

Satisfactory (2): Student knows the basics and terminology, but has shortcomings in the application of key issues.

Evaluation criteria, good (3-4)

Good (3): Student is familiar with basic database queries and working with them. Student is able to apply the theory learnt from databases to practice and understand the concept model.

Very good (4): Student knows the key subjects and is able to apply them in different implementations.

Evaluation criteria, excellent (5)

Excellent (5): Student masters key subjects and is able to apply them creatively and innovatively.

Prerequisites

-

Enrollment

01.11.2022 - 05.01.2023

Timing

01.01.2023 - 21.05.2023

Number of ECTS credits allocated

4 op

Virtual portion

4 op

Mode of delivery

Online learning

Unit

School of Technology

Teaching languages
  • Finnish
Degree programmes
  • Bachelor's Degree Programme in Electrical and Automation Engineering
Teachers
  • Juho Pekki
Groups
  • TSA22KMA
    Sähkö- ja automaatiotekniikka (AMK)
  • TSA22KMS
    Sähkö- ja automaatiotekniikka (AMK)

Objectives

Student gets familiar with databases to the extent necessary from the point of view of electrical and automation technology. By this course, the student has a basic understanding of databases.

EUR-ACE KNOWLEDGE AND UNDERSTANDING
Student is familiar with the basic structures and terminology of databases.

EUR-ACE APPLYING TECHNOLOGY INTO PRACTICE
Student is able to retrieve, edit and append the information stored in the database using database queries.

Content

Basic queries to databases
Application of the database
Understanding the concept model

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Sufficient (1): Student recognizes the basics and terminology, but has shortcomings in understanding the key issues.

Satisfactory (2): Student knows the basics and terminology, but has shortcomings in the application of key issues.

Evaluation criteria, good (3-4)

Good (3): Student is familiar with basic database queries and working with them. Student is able to apply the theory learnt from databases to practice and understand the concept model.

Very good (4): Student knows the key subjects and is able to apply them in different implementations.

Evaluation criteria, excellent (5)

Excellent (5): Student masters key subjects and is able to apply them creatively and innovatively.

Prerequisites

-

Enrollment

01.08.2022 - 25.08.2022

Timing

29.08.2022 - 31.12.2022

Number of ECTS credits allocated

4 op

Mode of delivery

Face-to-face

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • Finnish
Seats

0 - 30

Degree programmes
  • Bachelor's Degree Programme in Electrical and Automation Engineering
Teachers
  • Juho Pekki
Groups
  • TSA21SA
    Sähkö- ja automaatiotekniikka (AMK)

Objectives

Student gets familiar with databases to the extent necessary from the point of view of electrical and automation technology. By this course, the student has a basic understanding of databases.

EUR-ACE KNOWLEDGE AND UNDERSTANDING
Student is familiar with the basic structures and terminology of databases.

EUR-ACE APPLYING TECHNOLOGY INTO PRACTICE
Student is able to retrieve, edit and append the information stored in the database using database queries.

Content

Basic queries to databases
Application of the database
Understanding the concept model

Learning materials and recommended literature

Opintojakson verkkosivut (luentomateriaali, harjoitukset ja kotitehtävät)

Teaching methods

Kontaktiopetus (Luennot ja materiaalisivu, harjoitukset, tenttiin valmistautuminen, tentti)

Exam dates and retake possibilities

Tentin ajankohta ja toteutustapa ilmoitetaan opintojakson ensimmäisellä kerralla.

Alternative completion methods

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

Student workload

Opiskelu 108 h (Luennot ja materiaaliin tutustuminen, harjoitukset, tenttiin valmistautuminen, tentti)

Further information for students

Opintojakson arviointi tehdään palautettujen harjoitustehtävien, sekä tentin perusteella.

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Sufficient (1): Student recognizes the basics and terminology, but has shortcomings in understanding the key issues.

Satisfactory (2): Student knows the basics and terminology, but has shortcomings in the application of key issues.

Evaluation criteria, good (3-4)

Good (3): Student is familiar with basic database queries and working with them. Student is able to apply the theory learnt from databases to practice and understand the concept model.

Very good (4): Student knows the key subjects and is able to apply them in different implementations.

Evaluation criteria, excellent (5)

Excellent (5): Student masters key subjects and is able to apply them creatively and innovatively.

Prerequisites

-

Enrollment

01.08.2022 - 25.08.2022

Timing

29.08.2022 - 31.12.2022

Number of ECTS credits allocated

4 op

Mode of delivery

Face-to-face

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • Finnish
Seats

0 - 30

Degree programmes
  • Bachelor's Degree Programme in Electrical and Automation Engineering
Teachers
  • Juho Pekki
Groups
  • TSA21SB
    Sähkö- ja automaatiotekniikka (AMK)

Objectives

Student gets familiar with databases to the extent necessary from the point of view of electrical and automation technology. By this course, the student has a basic understanding of databases.

EUR-ACE KNOWLEDGE AND UNDERSTANDING
Student is familiar with the basic structures and terminology of databases.

EUR-ACE APPLYING TECHNOLOGY INTO PRACTICE
Student is able to retrieve, edit and append the information stored in the database using database queries.

Content

Basic queries to databases
Application of the database
Understanding the concept model

Learning materials and recommended literature

Opintojakson verkkosivut (luentomateriaali, harjoitukset ja kotitehtävät)

Teaching methods

Kontaktiopetus (Luennot ja materiaalisivu, harjoitukset, tenttiin valmistautuminen, tentti)

Exam dates and retake possibilities

Tentin ajankohta ja toteutustapa ilmoitetaan opintojakson ensimmäisellä kerralla.

Alternative completion methods

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

Student workload

Opiskelu 108 h (Luennot ja materiaaliin tutustuminen, harjoitukset, tenttiin valmistautuminen, tentti)

Further information for students

Opintojakson arviointi tehdään palautettujen harjoitustehtävien, sekä tentin perusteella.

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Sufficient (1): Student recognizes the basics and terminology, but has shortcomings in understanding the key issues.

Satisfactory (2): Student knows the basics and terminology, but has shortcomings in the application of key issues.

Evaluation criteria, good (3-4)

Good (3): Student is familiar with basic database queries and working with them. Student is able to apply the theory learnt from databases to practice and understand the concept model.

Very good (4): Student knows the key subjects and is able to apply them in different implementations.

Evaluation criteria, excellent (5)

Excellent (5): Student masters key subjects and is able to apply them creatively and innovatively.

Prerequisites

-

Enrollment

01.11.2021 - 09.01.2022

Timing

01.01.2022 - 15.05.2022

Number of ECTS credits allocated

4 op

Virtual portion

4 op

Mode of delivery

Online learning

Unit

School of Technology

Teaching languages
  • Finnish
Seats

0 - 35

Degree programmes
  • Bachelor's Degree Programme in Electrical and Automation Engineering
Teachers
  • Juho Pekki
Groups
  • TSA21KM
    Sähkö- ja automaatiotekniikka (AMK)

Objectives

Student gets familiar with databases to the extent necessary from the point of view of electrical and automation technology. By this course, the student has a basic understanding of databases.

EUR-ACE KNOWLEDGE AND UNDERSTANDING
Student is familiar with the basic structures and terminology of databases.

EUR-ACE APPLYING TECHNOLOGY INTO PRACTICE
Student is able to retrieve, edit and append the information stored in the database using database queries.

Content

Basic queries to databases
Application of the database
Understanding the concept model

Learning materials and recommended literature

Opintojakson verkkosivut (luentomateriaali, harjoitukset ja kotitehtävät)

Teaching methods

Etäopiskelu (Luentovideot ja materiaalisivu, harjoitukset, tenttiin valmistautuminen, tentti)

Exam dates and retake possibilities

Tentin ajankohta ja toteutustapa ilmoitetaan opintojakson ensimmäisellä kerralla.

Alternative completion methods

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

Student workload

Opiskelu 108 h (Luentovideot ja materiaaliin tutustuminen, harjoitukset, tenttiin valmistautuminen, tentti)

Further information for students

Opintojakson arviointi tehdään palautettujen harjoitustehtävien, sekä tentin perusteella.

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Sufficient (1): Student recognizes the basics and terminology, but has shortcomings in understanding the key issues.

Satisfactory (2): Student knows the basics and terminology, but has shortcomings in the application of key issues.

Evaluation criteria, good (3-4)

Good (3): Student is familiar with basic database queries and working with them. Student is able to apply the theory learnt from databases to practice and understand the concept model.

Very good (4): Student knows the key subjects and is able to apply them in different implementations.

Evaluation criteria, excellent (5)

Excellent (5): Student masters key subjects and is able to apply them creatively and innovatively.

Prerequisites

-