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.
Timing
30.08.2024 - 31.07.2025
Number of ECTS credits allocated
4 op
Virtual portion
4 op
Mode of delivery
Distance learning
Unit
School of Technology
Campus
Lutakko Campus
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
-
ZJA23STIDIAvoin amk, Digiosaaja, Verkko
-
ZJA23STINOAvoin amk, ICT,Nonstop, Verkko
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.
Location and time
Online course
Materials
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 schedules
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
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
20.11.2023 - 04.01.2024
Timing
08.01.2024 - 30.04.2024
Number of ECTS credits allocated
4 op
Mode of delivery
Contact teaching
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
-
TTV23S1Tieto- ja viestintätekniikka (AMK)
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.
Materials
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
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
20.11.2023 - 04.01.2024
Timing
08.01.2024 - 30.04.2024
Number of ECTS credits allocated
4 op
Mode of delivery
Contact teaching
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
-
TTV23S2Tieto- ja viestintätekniikka (AMK)
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.
Materials
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
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
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 % Contact teaching, 50 % Distance 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
-
TTV23S3Tieto- ja viestintätekniikka (AMK)
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.
Materials
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
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
20.11.2023 - 24.08.2023
Timing
08.01.2024 - 30.04.2024
Number of ECTS credits allocated
4 op
Virtual portion
2 op
Mode of delivery
50 % Contact teaching, 50 % Distance 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
-
TTV23S5Tieto- ja viestintätekniikka (AMK)
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.
Materials
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
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.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
Distance 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
-
ZJA23KTIDIAvoin amk, ICT Digiosaaja, Verkko
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.
Location and time
Online course
Materials
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
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.
Timing
11.04.2023 - 07.06.2023
Number of ECTS credits allocated
4 op
Mode of delivery
Contact teaching
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
-
ZJA23KTITVOAvoin Amk, ICT, Valintaopintojakso, Tieto-ja Viestintätekniikka, Monimuoto
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.
Location and time
Online course
Materials
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
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.
Timing
06.02.2023 - 31.03.2023
Number of ECTS credits allocated
4 op
Virtual portion
4 op
Mode of delivery
Distance 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
-
ZJA23KTIIVOAvoin Amk, ICT, Valintaopintojakso, Information and Communication Technology, Monimuoto
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.
Location and time
Online course
Materials
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
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.
Timing
09.01.2023 - 28.02.2023
Number of ECTS credits allocated
4 op
Virtual portion
4 op
Mode of delivery
Distance 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
-
ZJA22STIDIAvoin amk, Digiosaaja, Verkko
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.
Materials
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
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.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
Distance 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
-
ZJATTV22SMAvoin amk, Tieto- ja viestintätekniikka, Monimuoto
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.
Materials
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
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.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 % Contact teaching, 50 % Distance 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
-
TTV22S1Tieto- ja viestintätekniikka (AMK)
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.
Materials
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
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.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
Distance 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
-
TTV22SMTieto- ja viestintätekniikka (AMK)
-
TTV22SM2Tieto- ja viestintätekniikka (AMK)
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.
Location and time
Verkkototeutus (toteutuksessa ei ole kontaktiopetusta)
Materials
Opintojakson verkkosivut (luentomateriaali, harjoitukset ja kotitehtävät)
Teaching methods
Etäopiskelu (Videoluennot ja materiaalisivu, harjoitukset, harjoitustyö, tenttiin valmistautuminen, tentti)
Exam schedules
Tentin ajankohta ja toteutustapa ilmoitetaan opintojakson ensimmäisellä kerralla.
Completion alternatives
Hyväksilukemisen menettelytavat kuvataan tutkintosäännössä ja opinto-oppaassa. Opintojakson opettaja antaa lisätietoa mahdollisista opintojakson erityiskäytänteistä.
Student workload
Etäopiskelu 108 h (Luennot ja materiaaliin tutustuminen, harjoitukset, harjoitustyö, tenttiin valmistautuminen, tentti)
Further information
Opintojakson arviointi tehdään palautettujen harjoitustehtävien, harjoitustyön sekä tentin perusteella.
Evaluation scale
0-5
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.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 % Contact teaching, 50 % Distance 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
-
ZJATTV22S2Avoin amk, Tieto- ja viestintätekniikka, Päivä
-
TTV22S2Tieto- ja viestintätekniikka (AMK)
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.
Location and time
Avoin AMK polkuopiskelijat: 5 paikkaa
Materials
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
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.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 % Contact teaching, 50 % Distance 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
-
TTV22S3Tieto- ja viestintätekniikka (AMK)
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.
Materials
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
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.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 % Contact teaching, 50 % Distance 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
-
TTV22S5Tieto- ja viestintätekniikka (AMK)
-
ZJATTV22S5Avoin amk, Tieto- ja viestintätekniikka, Päivä
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.
Location and time
Avoin AMK polkuopiskelijat: 5 paikkaa
Materials
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
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.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 % Contact teaching, 50 % Distance 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
-
TTV22S4Tieto- ja viestintätekniikka (AMK)
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.
Location and time
Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.
Materials
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
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.
Timing
30.08.2022 - 31.07.2023
Number of ECTS credits allocated
4 op
Virtual portion
4 op
Mode of delivery
Distance 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
-
ZJA22STINO1Avoin amk, Nonstop 1, Verkko
-
ZJA22STINO2Avoin amk, Nonstop 2, Verkko
-
ZJA23KTINO3Avoin amk, Nonstop 3, Verkko
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.
Location and time
Online course
Materials
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 schedules
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
Avoin amk 48
Evaluation scale
0-5
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.
Timing
15.05.2022 - 31.08.2022
Number of ECTS credits allocated
4 op
Virtual portion
4 op
Mode of delivery
Distance 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
-
TTK22KOHJOhjelmistoalan osaaja
-
ZJA22KTIDIAvoin AMK, tekniikka, ICT, Digiosaaja
-
ZJA22KTIAvoin AMK, tekniikka, ICT
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.
Location and time
Online course
Materials
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
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.
Timing
02.02.2022 - 30.03.2022
Number of ECTS credits allocated
4 op
Virtual portion
4 op
Mode of delivery
Distance 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
-
ZJA22KTIVEPAvon Amk, tekniikka, ICT, Valintaopintojakso, päivä, eng.
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.
Location and time
Online course
Materials
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
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.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 % Contact teaching, 50 % Distance 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
-
TTV21S1Tieto- ja viestintätekniikka (AMK)
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.
Location and time
Lutakon kampus
10.1.-29.4.2022
Materials
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
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.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 % Contact teaching, 50 % Distance 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
-
ZJA21STIPPTVAvoin amk, tekniikka, Tieto-ja viestintätekniikka, päivä
-
TTV21S2Tieto- ja viestintätekniikka (AMK)
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.
Location and time
Lutakon kampus
10.1.-29.4.2022
Materials
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
Avoin AMK polkuopiskelijat: 5 paikkaa
Evaluation scale
0-5
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.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 % Contact teaching, 50 % Distance 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
-
TTV21S3Tieto- ja viestintätekniikka (AMK)
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.
Location and time
Lutakon kampus
10.1.-29.4.2022
Materials
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
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.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 % Contact teaching, 50 % Distance 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
-
TTV21S5Tieto- ja viestintätekniikka (AMK)
-
ZJA21STIPPTVAvoin amk, tekniikka, Tieto-ja viestintätekniikka, päivä
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.
Location and time
Lutakon kampus
10.1.-29.4.2022
Materials
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
Avoin AMK polkuopiskelijat: 5 paikkaa
Evaluation scale
0-5
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.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
Distance 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
-
TTV21SMTieto- ja viestintätekniikka (AMK)
-
ZJA21STPMTVAvoin amk, tekniikka, Tieto- ja viestintätekniikka, verkko
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.
Location and time
Verkkototeutus (toteutuksessa ei ole kontaktiopetusta)
Materials
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
Opintojakson arviointi tehdään palautettujen harjoitustehtävien, harjoitustyön sekä tentin perusteella.
Evaluation scale
0-5
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.
Timing
01.01.2022 - 31.07.2022
Number of ECTS credits allocated
4 op
Virtual portion
4 op
Mode of delivery
Distance 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
-
ZJA21STIDIAvoin AMK, tekniikka, ICT, Digiosaaja
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.
Location and time
Online course
Materials
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
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.