Skip to main content

DatabasesLaajuus (4 cr)

Code: TTC2020

Credits

4 op

Teaching language

  • Finnish
  • English

Responsible person

  • Antti Häkkinen
  • Ari Rantala
  • Jani Immonen
  • Jouni Huotari

Objective

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Assessment criteria, satisfactory (1)

Pass/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.

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.

Assessment criteria, good (3)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Assessment criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.04.2024 - 30.04.2024

Timing

30.08.2023 - 31.12.2024

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 - 20

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Antti Häkkinen
Groups
  • ZJA23STIDI
    Avoin amk, Digiosaaja, Verkko
  • ZJA23STINO
    Avoin amk, ICT,Nonstop, Verkko
  • ZJA24KTIDI
    Avoin amk, ICT Digiosaaja, Verkko
  • ZJATTV23SM
    Avoin amk, Tieto- ja viestintätekniikka, Monimuoto

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Summers studies/IT-institute students.
Online course

Learning materials and recommended literature

Course material page (material for course topics, exercises, course exercise guidance)

Teaching methods

Distance learning: Students can make the assignments at their own pace during the course (exercises and course exercise). Exam will be held at the end of the course (several available exam dates in each semester).

Exam dates and retake possibilities

The exam of the course is structured so that the student can choose the time of the exam, taking into account the time limitations of the non-stop implementation.

Student workload

Distance learning (exercises, course exercise, preparation for exam) for total of 108 hours

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Timing

09.04.2024 - 11.06.2024

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 Information and Communications Technology
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Juho Pekki
Groups
  • ZJA24KTITVO
    Avoin Amk, ICT, Valintaopintojakso, Tieto-ja Viestintätekniikka, Monimuoto

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Online course

Learning materials and recommended literature

Course material page (material for course topics, exercises, course exercise guidance), in addition recorded video lectures will be available

Teaching methods

Distance learning: Students can make the assignments at their own pace during the course. Exam will be held at the end of the course. This course implementation does not include lectures.

Student workload

Distance learning (exercises, preparation for exam) for total of 108 hours

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Timing

30.01.2024 - 22.03.2024

Number of ECTS credits allocated

4 op

Mode of delivery

Face-to-face

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • English
Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Antti Häkkinen
  • Juho Pekki
Groups
  • ZJA24KTIIVO
    Avoin Amk, ICT, Valintaopintojakso, Information and Communication Technology, Monimuoto

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Online course

Learning materials and recommended literature

Course material page (material for course topics, exercises, course exercise guidance), in addition recorded video lectures will be available

Teaching methods

Distance learning: Students can make the assignments at their own pace during the course. Exam will be held at the end of the course. This course implementation does not have lectures.

Student workload

Distance learning (exercises, preparation for exam) for total of 108 hours

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

20.11.2023 - 04.01.2024

Timing

08.01.2024 - 30.04.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 Information and Communications Technology
Teachers
  • Teemu Siikaniemi
Groups
  • TTV23S1
    Tieto- ja viestintätekniikka (AMK)

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Learning materials and recommended literature

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

Teaching methods

Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.

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)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

20.11.2023 - 04.01.2024

Timing

08.01.2024 - 30.04.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 Information and Communications Technology
Teachers
  • Teemu Siikaniemi
Groups
  • TTV23S2
    Tieto- ja viestintätekniikka (AMK)

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Learning materials and recommended literature

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

Teaching methods

Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.

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)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

20.11.2023 - 04.01.2024

Timing

08.01.2024 - 30.04.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

Lutakko Campus

Teaching languages
  • Finnish
Seats

20 - 35

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Ari Rantala
Groups
  • TTV23S3
    Tieto- ja viestintätekniikka (AMK)

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Learning materials and recommended literature

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

Teaching methods

Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.

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)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

20.11.2023 - 04.01.2024

Timing

08.01.2024 - 30.04.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

Lutakko Campus

Teaching languages
  • Finnish
Seats

20 - 35

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Ari Rantala
Groups
  • TTV23S5
    Tieto- ja viestintätekniikka (AMK)

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Learning materials and recommended literature

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

Teaching methods

Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.

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)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.04.2023 - 30.04.2023

Timing

01.05.2023 - 15.08.2023

Number of ECTS credits allocated

4 op

Virtual portion

4 op

Mode of delivery

Online learning

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • Finnish
Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Antti Häkkinen
Groups
  • ZJA23KTIDI
    Avoin amk, ICT Digiosaaja, Verkko

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Online course

Learning materials and recommended literature

Course material page (material for course topics, exercises, course exercise guidance)

Teaching methods

Distance learning: Students can make the assignments at their own pace during the course (exercises and course exercise). Exam will be held at the end of the course.

Student workload

Distance learning (exercises, course exercise, preparation for exam) for total of 108 hours

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Timing

11.04.2023 - 07.06.2023

Number of ECTS credits allocated

4 op

Mode of delivery

Face-to-face

Unit

School of Technology

Teaching languages
  • Finnish
Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Antti Häkkinen
Groups
  • ZJA23KTITVO
    Avoin Amk, ICT, Valintaopintojakso, Tieto-ja Viestintätekniikka, Monimuoto

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Online course

Learning materials and recommended literature

Course material page (material for course topics, exercises, course exercise guidance), in addition recorded video lectures will be available

Teaching methods

Distance learning: Students can make the assignments at their own pace during the course. Exam will be held at the end of the course. This course implementation does not include lectures.

Student workload

Distance learning (exercises, preparation for exam) for total of 108 hours

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Timing

06.02.2023 - 31.03.2023

Number of ECTS credits allocated

4 op

Virtual portion

4 op

Mode of delivery

Online learning

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • English
Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Antti Häkkinen
Groups
  • ZJA23KTIIVO
    Avoin Amk, ICT, Valintaopintojakso, Information and Communication Technology, Monimuoto

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Online course

Learning materials and recommended literature

Course material page (material for course topics, exercises, course exercise guidance), in addition recorded video lectures will be available

Teaching methods

Distance learning: Students can make the assignments at their own pace during the course. Exam will be held at the end of the course. This course implementation does not have lectures.

Student workload

Distance learning (exercises, preparation for exam) for total of 108 hours

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Timing

09.01.2023 - 28.02.2023

Number of ECTS credits allocated

4 op

Virtual portion

4 op

Mode of delivery

Online learning

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • Finnish
Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Ari Rantala
Groups
  • ZJA22STIDI
    Avoin amk, Digiosaaja, Verkko

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Learning materials and recommended literature

Opintojakson verkkosivut (luentomateriaali, videoluennot, harjoitustehtävät)

Teaching methods

Etäopiskelu (Videoluennot, omatoimiset harjoitukset, harjoitustyö, osaamistesti)

Student workload

Etäopiskelu 108 h (Videoluennot, omatoimiset harjoitukset ja harjoitustyö. Osaamistesti) Yhteensä 108 h

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.11.2022 - 05.01.2023

Timing

09.01.2023 - 28.04.2023

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 - 70

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Ari Rantala
Groups
  • ZJATTV22SM
    Avoin amk, Tieto- ja viestintätekniikka, Monimuoto

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Learning materials and recommended literature

Opintojakson verkkosivut (luentomateriaali, videoluennot, harjoitustehtävät)

Teaching methods

Etäopiskelu (Videoluennot, omatoimiset harjoitukset, harjoitustyö, Osaamistesti)

Student workload

Etäopiskelu 108 h (Videoluennot, omatoimiset harjoitukset ja harjoitustyö, osaamistesti) Yhteensä 108 h

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.11.2022 - 05.01.2023

Timing

09.01.2023 - 28.04.2023

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

Lutakko Campus

Teaching languages
  • Finnish
Seats

0 - 35

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Ari Rantala
Groups
  • TTV22S1
    Tieto- ja viestintätekniikka (AMK)

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Learning materials and recommended literature

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

Teaching methods

Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.

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)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.11.2022 - 05.01.2023

Timing

09.01.2023 - 28.04.2023

Number of ECTS credits allocated

4 op

Virtual portion

4 op

Mode of delivery

Online learning

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • Finnish
Seats

0 - 75

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Juho Pekki
Groups
  • TTV22SM
    Tieto- ja viestintätekniikka (AMK)
  • TTV22SM2
    Tieto- ja viestintätekniikka (AMK)

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Verkkototeutus (toteutuksessa ei ole kontaktiopetusta)

Learning materials and recommended literature

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

Teaching methods

Etäopiskelu (Videoluennot ja materiaalisivu, harjoitukset, harjoitustyö, 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

Etäopiskelu 108 h (Luennot ja materiaaliin tutustuminen, harjoitukset, harjoitustyö, tenttiin valmistautuminen, tentti)

Further information for students

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

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.11.2022 - 05.01.2023

Timing

09.01.2023 - 28.04.2023

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

Lutakko Campus

Teaching languages
  • Finnish
Seats

0 - 30

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Ari Rantala
Groups
  • ZJATTV22S2
    Avoin amk, Tieto- ja viestintätekniikka, Päivä
  • TTV22S2
    Tieto- ja viestintätekniikka (AMK)

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Avoin AMK polkuopiskelijat: 5 paikkaa

Learning materials and recommended literature

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

Teaching methods

Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.

Student workload

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

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.11.2022 - 05.01.2023

Timing

09.01.2023 - 28.04.2023

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

Lutakko Campus

Teaching languages
  • Finnish
Seats

0 - 35

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Ari Rantala
Groups
  • TTV22S3
    Tieto- ja viestintätekniikka (AMK)

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Learning materials and recommended literature

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

Teaching methods

Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.

Student workload

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

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.11.2022 - 05.01.2023

Timing

09.01.2023 - 28.04.2023

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

Lutakko Campus

Teaching languages
  • Finnish
Seats

0 - 30

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Ari Rantala
Groups
  • TTV22S5
    Tieto- ja viestintätekniikka (AMK)
  • ZJATTV22S5
    Avoin amk, Tieto- ja viestintätekniikka, Päivä

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Avoin AMK polkuopiskelijat: 5 paikkaa

Learning materials and recommended literature

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

Teaching methods

Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.

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)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.11.2022 - 05.01.2023

Timing

09.01.2023 - 28.04.2023

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

Lutakko Campus

Teaching languages
  • Finnish
Seats

0 - 35

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Ari Rantala
Groups
  • TTV22S4
    Tieto- ja viestintätekniikka (AMK)

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.

Learning materials and recommended literature

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

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)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Timing

30.08.2022 - 31.07.2023

Number of ECTS credits allocated

4 op

Virtual portion

4 op

Mode of delivery

Online learning

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • English
  • Finnish
Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Antti Häkkinen
Groups
  • ZJA22STINO1
    Avoin amk, Nonstop 1, Verkko
  • ZJA22STINO2
    Avoin amk, Nonstop 2, Verkko
  • ZJA23KTINO3
    Avoin amk, Nonstop 3, Verkko

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Online course

Learning materials and recommended literature

Course material page (material for course topics, exercises, course exercise guidance)

Teaching methods

Distance learning: Students can make the assignments at their own pace during the course (exercises and course exercise). Exam will be held at the end of the course (several available exam dates in each semester).

Exam dates and retake possibilities

The exam of the course is structured so that the student can choose the time of the exam, taking into account the time limitations of the non-stop implementation.

Student workload

Distance learning (exercises, course exercise, preparation for exam) for total of 108 hours

Further information for students

Avoin amk 48

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Timing

15.05.2022 - 31.08.2022

Number of ECTS credits allocated

4 op

Virtual portion

4 op

Mode of delivery

Online learning

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • Finnish
Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Jouni Huotari
  • Antti Häkkinen
Teacher in charge

Jouni Huotari

Groups
  • TTK22KOHJ
    Ohjelmistoalan osaaja
  • ZJA22KTIDI
    Avoin AMK, tekniikka, ICT, Digiosaaja
  • ZJA22KTI
    Avoin AMK, tekniikka, ICT

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Online course

Learning materials and recommended literature

Course material page (material for course topics, exercises, course exercise guidance)

Teaching methods

Distance learning: Students can make the assignments at their own pace during the course (exercises and course exercise). Exam will be held at the end of the course.

Student workload

Distance learning (exercises, course exercise, preparation for exam) for total of 108 hours

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Timing

02.02.2022 - 30.03.2022

Number of ECTS credits allocated

4 op

Virtual portion

4 op

Mode of delivery

Online learning

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • English
Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Antti Häkkinen
Groups
  • ZJA22KTIVEP
    Avon Amk, tekniikka, ICT, Valintaopintojakso, päivä, eng.

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Online course

Learning materials and recommended literature

Course material page (material for course topics, exercises, course exercise guidance), in addition recorded video lectures will be available

Teaching methods

Distance learning: Students can make the assignments at their own pace during the course (exercises and course exercise). Exam will be held at the end of the course.

Student workload

Distance learning (exercises, course exercise, preparation for exam) for total of 108 hours

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.11.2021 - 09.01.2022

Timing

10.01.2022 - 29.04.2022

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

Lutakko Campus

Teaching languages
  • Finnish
Seats

0 - 35

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Ari Rantala
Teacher in charge

Ari Rantala

Groups
  • TTV21S1
    Tieto- ja viestintätekniikka (AMK)

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Lutakon kampus
10.1.-29.4.2022

Learning materials and recommended literature

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

Teaching methods

Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.

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)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.11.2021 - 09.01.2022

Timing

10.01.2022 - 29.04.2022

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

Lutakko Campus

Teaching languages
  • Finnish
Seats

0 - 35

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Ari Rantala
Teacher in charge

Ari Rantala

Groups
  • ZJA21STIPPTV
    Avoin amk, tekniikka, Tieto-ja viestintätekniikka, päivä
  • TTV21S2
    Tieto- ja viestintätekniikka (AMK)

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Lutakon kampus
10.1.-29.4.2022

Learning materials and recommended literature

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

Teaching methods

Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.

Student workload

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

Further information for students

Avoin AMK polkuopiskelijat: 5 paikkaa

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.11.2021 - 09.01.2022

Timing

10.01.2022 - 29.04.2022

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

Lutakko Campus

Teaching languages
  • Finnish
Seats

0 - 35

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Ari Rantala
Teacher in charge

Ari Rantala

Groups
  • TTV21S3
    Tieto- ja viestintätekniikka (AMK)

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Lutakon kampus
10.1.-29.4.2022

Learning materials and recommended literature

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

Teaching methods

Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.

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)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.11.2021 - 09.01.2022

Timing

10.01.2022 - 29.04.2022

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

Lutakko Campus

Teaching languages
  • Finnish
Seats

0 - 35

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Ari Rantala
Teacher in charge

Ari Rantala

Groups
  • TTV21S5
    Tieto- ja viestintätekniikka (AMK)
  • ZJA21STIPPTV
    Avoin amk, tekniikka, Tieto-ja viestintätekniikka, päivä

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Lutakon kampus
10.1.-29.4.2022

Learning materials and recommended literature

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

Teaching methods

Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.

Student workload

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

Further information for students

Avoin AMK polkuopiskelijat: 5 paikkaa

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Enrollment

01.11.2021 - 09.01.2022

Timing

10.01.2022 - 29.04.2022

Number of ECTS credits allocated

4 op

Virtual portion

4 op

Mode of delivery

Online learning

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • Finnish
Seats

0 - 87

Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Antti Häkkinen
Teacher in charge

Ari Rantala

Groups
  • TTV21SM
    Tieto- ja viestintätekniikka (AMK)
  • ZJA21STPMTV
    Avoin amk, tekniikka, Tieto- ja viestintätekniikka, verkko

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Verkkototeutus (toteutuksessa ei ole kontaktiopetusta)

Learning materials and recommended literature

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

Teaching methods

Etäopiskelu (Videoluennot ja materiaalisivu, harjoitukset, harjoitustyö, tenttiin valmistautuminen, tentti)

Student workload

Etäopiskelu 108 h (Videoluentoihin ja materiaaliin tutustuminen, harjoitukset, harjoitustyö, tenttiin valmistautuminen, tentti)

Further information for students

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

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.

Timing

01.01.2022 - 31.07.2022

Number of ECTS credits allocated

4 op

Virtual portion

4 op

Mode of delivery

Online learning

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages
  • Finnish
Degree programmes
  • Bachelor's Degree Programme in Information and Communications Technology
  • Bachelor's Degree Programme in Information and Communications Technology
Teachers
  • Antti Häkkinen
Groups
  • ZJA21STIDI
    Avoin AMK, tekniikka, ICT, Digiosaaja

Objectives

Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).

EUR-ACE Competences:
Knowledge and Understanding
Engineering practice

Learning outcomes:
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.

Content

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

Time and location

Online course

Learning materials and recommended literature

Course material page (material for course topics, exercises, course exercise guidance)

Teaching methods

Distance learning: Students can make the assignments at their own pace during the course (exercises and course exercise). Exam will be held at the end of the course.

Student workload

Distance learning (exercises, course exercise, preparation for exam) for total of 108 hours

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

Pass/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.

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.

Evaluation criteria, good (3-4)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

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.

Evaluation criteria, excellent (5)

Excellent 5: You are able to design and implement an out of the ordinary database where 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.