Skip to main content

Basics of Databases (4 cr)

Code: TSAT0520-3009

General information


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
  • 30.08.2023 11:30 - 13:00, Basics of Databases TSAT0520-3009
  • 06.09.2023 11:30 - 13:00, Basics of Databases TSAT0520-3009
  • 13.09.2023 11:30 - 13:00, Basics of Databases TSAT0520-3009
  • 20.09.2023 11:30 - 13:00, Basics of Databases TSAT0520-3009
  • 27.09.2023 11:30 - 13:00, Basics of Databases TSAT0520-3009
  • 04.10.2023 11:30 - 13:00, Basics of Databases TSAT0520-3009
  • 11.10.2023 11:30 - 13:00, Basics of Databases TSAT0520-3009
  • 25.10.2023 11:30 - 13:00, Basics of Databases TSAT0520-3009
  • 01.11.2023 11:30 - 13:00, Basics of Databases TSAT0520-3009
  • 08.11.2023 11:30 - 13:00, Basics of Databases TSAT0520-3009
  • 22.11.2023 11:30 - 13:00, Basics of Databases TSAT0520-3009

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

-