Skip to main content

DatabasesLaajuus (4 cr)

Code: KL00CQ20

Objective

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student knows the SQL programming language and can make queries and other operations to database, also from other programs. Student knows the basics of NoSQL databases.

Content

- Concepts of databases and database management systems
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship) modelling
- SQL (Structured Query Language)
- Basics of NoSQL databases

Assessment criteria, satisfactory (1)

The student understands the concept of database. Student knows how database is designed and how information is modeled. Student knows the basics of SQL programming language and can make queries and other operations to database.

Assessment criteria, good (3)

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student knows the SQL programming language and can make queries and other operations to database. Student knows the basics of NoSQL databases.

Assessment criteria, excellent (5)

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student masters the SQL programming language and can make queries and other operations to database, also from other programs. Student can develop applications, which use NoSQL databases.

Enrollment

22.04.2024 - 04.09.2024

Timing

26.08.2024 - 13.10.2024

Credits

4 op

Teaching languages
  • Finnish
Degree programmes
  • Bachelor of Engineering, Information Technology
Teachers
  • Jarkko Loima
Student groups
  • TITE23
    Bachelor of Engineering, Information Technology

Objective

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student knows the SQL programming language and can make queries and other operations to database, also from other programs. Student knows the basics of NoSQL databases.

Content

- Concepts of databases and database management systems
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship) modelling
- SQL (Structured Query Language)
- Basics of NoSQL databases

Evaluation scale

1-5

Assessment criteria, satisfactory (1)

The student understands the concept of database. Student knows how database is designed and how information is modeled. Student knows the basics of SQL programming language and can make queries and other operations to database.

Assessment criteria, good (3)

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student knows the SQL programming language and can make queries and other operations to database. Student knows the basics of NoSQL databases.

Assessment criteria, excellent (5)

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student masters the SQL programming language and can make queries and other operations to database, also from other programs. Student can develop applications, which use NoSQL databases.

Enrollment

17.04.2023 - 06.09.2023

Timing

28.08.2023 - 15.10.2023

Credits

4 op

Teaching languages
  • Finnish
Degree programmes
  • Bachelor of Engineering, Information Technology
Teachers
  • Marko Hietamäki
Student groups
  • TITE22

Objective

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student knows the SQL programming language and can make queries and other operations to database, also from other programs. Student knows the basics of NoSQL databases.

Content

- Concepts of databases and database management systems
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship) modelling
- SQL (Structured Query Language)
- Basics of NoSQL databases

Evaluation scale

1-5

Assessment criteria, satisfactory (1)

The student understands the concept of database. Student knows how database is designed and how information is modeled. Student knows the basics of SQL programming language and can make queries and other operations to database.

Assessment criteria, good (3)

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student knows the SQL programming language and can make queries and other operations to database. Student knows the basics of NoSQL databases.

Assessment criteria, excellent (5)

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student masters the SQL programming language and can make queries and other operations to database, also from other programs. Student can develop applications, which use NoSQL databases.

Enrollment

16.02.2023 - 02.04.2023

Timing

06.03.2023 - 14.05.2023

Credits

4 op

Teaching languages
  • Finnish
Degree programmes
  • Bachelor of Engineering, Information Technology
Teachers
  • Matti Panula
Student groups
  • OHSU23
    Software Engineering

Objective

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student knows the SQL programming language and can make queries and other operations to database, also from other programs. Student knows the basics of NoSQL databases.

Content

- Concepts of databases and database management systems
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship) modelling
- SQL (Structured Query Language)
- Basics of NoSQL databases

Evaluation scale

1-5

Assessment criteria, satisfactory (1)

The student understands the concept of database. Student knows how database is designed and how information is modeled. Student knows the basics of SQL programming language and can make queries and other operations to database.

Assessment criteria, good (3)

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student knows the SQL programming language and can make queries and other operations to database. Student knows the basics of NoSQL databases.

Assessment criteria, excellent (5)

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student masters the SQL programming language and can make queries and other operations to database, also from other programs. Student can develop applications, which use NoSQL databases.

Enrollment

24.02.2022 - 20.03.2022

Timing

07.03.2022 - 01.05.2022

Credits

4 op

Teaching languages
  • Finnish
Degree programmes
  • Bachelor of Engineering, Information Technology
Teachers
  • Marko Hietamäki
Student groups
  • TITE21

Objective

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student knows the SQL programming language and can make queries and other operations to database, also from other programs. Student knows the basics of NoSQL databases.

Content

- Concepts of databases and database management systems
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship) modelling
- SQL (Structured Query Language)
- Basics of NoSQL databases

Evaluation scale

1-5

Assessment criteria, satisfactory (1)

The student understands the concept of database. Student knows how database is designed and how information is modeled. Student knows the basics of SQL programming language and can make queries and other operations to database.

Assessment criteria, good (3)

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student knows the SQL programming language and can make queries and other operations to database. Student knows the basics of NoSQL databases.

Assessment criteria, excellent (5)

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student masters the SQL programming language and can make queries and other operations to database, also from other programs. Student can develop applications, which use NoSQL databases.