Curricula

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.