Data Management and Databases - SOF001AS2AE - Opinto-opas

Data Management and Databases, 5 cr - SOF001AS2AE

Upcoming implementations

Data Management and Databases SOF001AS2AE-3007 19.08.2024-13.12.2024 5 op (ITE2PAICB1, ...) +-
Teaching methods and instruction

Contact classes and weekly coursework.

Teams group for questions and instruction.

Prerequisite
The prerequisite is that you have passed the course Introduction to Software Development (SOF001IT1AE) or another equivalent course, or you can demonstrate equivalent skills and knowledge prior commencing the course.

Learning material and recommended literature

The course material is available in Moodle.

Campus

Pasila Campus

Exam dates and re-exam possibilities

Mid-term exam and final exam.
The exam dates are available in Moodle.
There are two re-exams in spring 2025.

Teaching language

English

Internationality

The course is in English. Usually, there are participants from different nationalities.

Timing

19.08.2024 - 13.12.2024

Learning assignments

There are individual weekly assignments and a comprehensive group work case assignment. These are available in Moodle.

Content scheduling

Weekly contact classes.
Mid-term exam after the first period and final exam at the end of the semester.

*** IMPORTANT ***
You will be required to confirm your course participation by completing a given set of exercises before the second course week's class.
Groups
- ITE2PAICB1
- CONTACT
- ITE2PASOF1
Alternative learning methods

If your starting-level is strong enough, then you can complete a fair share of the course independently. That is, if you can keep up with the course / coursework on your own, then you are not required to join all contact classes.

Teachers

Kari Silpiö

Seats

15 - 30

Further information

Mid-term exam and final exam.
The coursework might raise/lower the course grade by one.

*** IMPORTANT ***
The required minimum amount of coursework should be completed before the final exam.

Degree Programme

ITBBA Business Information Technology

R&D proportion

0.00 cr

Virtual proportion

0.00 cr

Evaluation scale

H-5
Data Management and Databases SOF001AS2AE-3008 19.08.2024-13.12.2024 5 op (ITE2PAICB1, ...) +-
Campus

Pasila Campus

Teaching language

English

Timing

19.08.2024 - 13.12.2024
Groups
- ITE2PAICB1
- CONTACT
- ITE2PASOF1
Teachers

Kari Silpiö, Jukka Remes

Seats

15 - 30

Degree Programme

ITBBA Business Information Technology

R&D proportion

0.00 cr

Virtual proportion

0.00 cr

Evaluation scale

H-5
Data Management and Databases SOF001AS2AE-3009 13.01.2025-16.05.2025 5 op (ITE2PAICB1, ...) +-
Campus

Pasila Campus

Teaching language

English

Timing

13.01.2025 - 16.05.2025
Groups
- ITE2PAICB1
- CONTACT
- ITE2PASOF1
Teachers

Kalle Ilves

Seats

15 - 30

Degree Programme

ITBBA Business Information Technology

R&D proportion

0.00 cr

Virtual proportion

0.00 cr

Evaluation scale

H-5
Data Management and Databases SOF001AS2AE-3006 13.01.2025-16.05.2025 5 op (ITE2PAICB1, ...) +-
Campus

Pasila Campus

Teaching language

English

Timing

13.01.2025 - 16.05.2025
Groups
- ITE2PAICB1
- CONTACT
- ITE2PASOF1
Teachers

Kari Silpiö

Seats

15 - 30

Degree Programme

ITBBA Business Information Technology

R&D proportion

0.00 cr

Virtual proportion

0.00 cr

Evaluation scale

H-5
Show all (4) Hide

Current implementations

Data Management and Databases SOF001AS2AE-3005 15.01.2024-17.05.2024 5 op (ITE2PAICB1, ...) +-
Campus

Pasila Campus

Teaching language

English

Timing

15.01.2024 - 17.05.2024

Enrollment

02.01.2024 - 12.01.2024
Groups
- ITE2PAICB1
- CONTACT
- ITE2PASOF1
Teachers

Kari Silpiö, Jukka Remes

Seats

15 - 30

Degree Programme

ITBBA Business Information Technology

R&D proportion

0.00 cr

Virtual proportion

0.00 cr

Evaluation scale

H-5
Data Management and Databases SOF001AS2AE-3002 15.01.2024-17.05.2024 5 op (ITE2PAICB1, ...) +-
Teaching methods and instruction

Contact classes and weekly coursework.

Teams group for questions and instruction.

Prerequisite
The prerequisite is that you have passed the course Introduction to Software Development (SOF001IT1AE) or another equivalent course, or you can demonstrate equivalent skills and knowledge prior commencing the course.

Learning material and recommended literature

The course material is available in Moodle.

Campus

Pasila Campus

Exam dates and re-exam possibilities

Mid-term exam and final exam.
The exam dates are available in Moodle.
There are two re-exams in autumn 2024.

Teaching language

English

Internationality

The course is in English. Usually, there are participants from different nationalities.

Timing

15.01.2024 - 17.05.2024

Learning assignments

There are individual weekly assignments and a comprehensive group work case assignment. These are available in Moodle.

Enrollment

02.01.2024 - 12.01.2024

Content scheduling

Weekly contact classes.
Mid-term exam after the first period and final exam at the end of the semester.

*** IMPORTANT ***
You will be required to confirm your course participation by completing a given set of exercises before the second course week's class.
Groups
- ITE2PAICB1
- CONTACT
- ITE2PASOF1
Alternative learning methods

If your starting-level is strong enough, then you can complete a fair share of the course independently. That is, if you can keep up with the course / coursework on your own, then you are not required to join all contact classes.

Teachers

Kari Silpiö

Seats

15 - 30

Further information

Mid-term exam and final exam.
The coursework might raise/lower the course grade by one.

*** IMPORTANT ***
The required minimum amount of coursework should be completed before the final exam.

Degree Programme

ITBBA Business Information Technology

R&D proportion

0.00 cr

Virtual proportion

0.00 cr

Evaluation scale

H-5

Past implementations

Data Management and Databases SOF001AS2AE-3003 21.08.2023-15.12.2023 5 op (ITE2PAICB1, ...) +-
Teaching methods and instruction

Contact classes and weekly coursework.

Teams group for questions and instruction.

Prerequisite
The prerequisite is that you have passed the course Introduction to Software Development (SOF001IT1AE) or another equivalent course, or you can demonstrate equivalent skills and knowledge prior commencing the course.

Learning material and recommended literature

The course material is available in Moodle.

Campus

Pasila Campus

Exam dates and re-exam possibilities

Mid-term exam and final exam.
The exam dates are available in Moodle.
There are two re-exams in spring 2024.

Teaching language

English

Internationality

The course is in English. Usually, there are participants from different nationalities.

Timing

21.08.2023 - 15.12.2023

Learning assignments

There are individual weekly assignments and a comprehensive group work case assignment. These are available in Moodle.

Enrollment

12.06.2023 - 18.08.2023

Content scheduling

Weekly contact classes.
Mid-term exam after the first period and final exam at the end of the semester.

*** IMPORTANT ***
You will be required to confirm your course participation by completing a given set of exercises before the second course week's class.
Groups
- ITE2PAICB1
- CONTACT
- ITE2PASOF1
Alternative learning methods

If your starting-level is strong enough, then you can complete a fair share of the course independently. That is, if you can keep up with the course / coursework on your own, then you are not required to join all contact classes.

Teachers

Kari Silpiö

Seats

15 - 30

Further information

Mid-term exam and final exam.
The coursework might raise/lower the course grade by one.

*** IMPORTANT ***
The required minimum amount of coursework should be completed before the final exam.

Degree Programme

ITBBA Business Information Technology

R&D proportion

0.00 cr

Virtual proportion

0.00 cr

Evaluation scale

H-5
Data Management and Databases SOF001AS2AE-3004 21.08.2023-15.12.2023 5 op (ITE2PAICB1, ...) +-
Campus

Pasila Campus

Teaching language

English

Timing

21.08.2023 - 15.12.2023

Enrollment

12.06.2023 - 18.08.2023
Groups
- ITE2PAICB1
- CONTACT
- ITE2PASOF1
Teachers

Kari Silpiö, Kalle Ilves

Seats

15 - 30

Degree Programme

ITBBA Business Information Technology

R&D proportion

0.00 cr

Virtual proportion

0.00 cr

Evaluation scale

H-5
Data Management and Databases SOF001AS2AE-3001 16.01.2023-19.05.2023 5 op (ITE2PAICB1, ...) +-
Teaching methods and instruction

Contact classes and weekly coursework.

Teams group for questions and instruction.

Prerequisite
The prerequisite is that you have passed the course Introduction to Software Development (SOF001IT1AE) or another equivalent course, or you can demonstrate equivalent skills and knowledge prior commencing the course.

Learning material and recommended literature

The course material is available in Moodle.

Campus

Pasila Campus

Exam dates and re-exam possibilities

Mid-term exam and final exam.
The exam dates are available in Moodle.
There are two re-exams in autumn 2023.

Teaching language

English

Internationality

The course is in English. Usually, there are participants from different nationalities.

Timing

16.01.2023 - 19.05.2023

Learning assignments

There are individual weekly assignments and a comprehensive group work case assignment. These are available in Moodle.

Enrollment

02.01.2023 - 13.01.2023

Content scheduling

Weekly contact classes.
Mid-term exam after the first period and final exam at the end of the semester.

*** IMPORTANT ***
You will be required to confirm your course participation by completing a given set of exercises before the second course week's class.
Groups
- ITE2PAICB1
- CONTACT
- ITE2PASOF1
Alternative learning methods

If your starting-level is strong enough, then you can complete a fair share of the course independently. That is, if you can keep up with the course / coursework on your own, then you are not required to join all contact classes.

Teachers

Kari Silpiö

Seats

15 - 30

Further information

Mid-term exam and final exam.
The coursework might raise/lower the course grade by one.

*** IMPORTANT ***
The required minimum amount of coursework should be completed before the final exam.

Degree Programme

ITBBA Business Information Technology

R&D proportion

0.00 cr

Virtual proportion

0.00 cr

Evaluation scale

H-5
Show all (3) Hide

Upon successful completion of this course, the student should be able to
* explain the basic concepts and terminology of data management and databases
* explain the principles, structure, and terminology of the relational database
* explain the DBMS services and their importance and value in software development
* explain what database transaction is and why it has a crucial role in reliable software systems
* explain the database design methodology
* use data-oriented ER diagrams and database diagrams written in UML
* create a small and simple database in SQL Server and MariaDB
* write intermediate-level SQL queries to retrieve and manipulate the database's data.

Passed courses are assessed on a scale of 1 to 5.

Basic concepts and terminology of data management and databases
Principles, structure, and terminology of the relational database
DBMS services and their importance and value in software development
Database transactions
Database design methodology
Data-oriented ER diagrams and database diagrams written in UML
Creating create a small and simple database in SQL Server and MariaDB
Writing intermediate-level SQL queries to retrieve and manipulate the database's data.

a. Contact lessons, assignments, case assignment, and independent studies OR
b. Self-study, assignments, case assignment, and written examinations

Assessment
* Weekly hands-on lab assignments, a comprehensive group work case assignment, activity in the group, learning diary, and two written exams

If you already have achieved the required learning objectives of this course, then you can show your competence with a portfolio and a demonstration exam. Please contact the teacher of the course if you need any advice on this matter. Recognition of prior learning should be applied for prior commencing the course.
See also: Further information regarding the recognition of prior learning

Connolly, T. & Begg, C. Database Systems. Addison Wesley Longman, London. 3rd edition or later.

SQL Zoo online SQL tutorial and W3Schools online SQL tutorial

Course handouts

In this course, you learn the basics that will make it possible for you to design and implement a small relational database and write intermediate-level database queries to retrieve and manipulate the database's data. The weekly cooperative database lab sessions and hands-on exercises in the SQL Server environment will give you practical experience and help you to learn the course content in a motivating way.

This course is a part of the Software Development study profile.

The prerequisite is that you have passed the course Introduction to Software Development (SOF001IT1AE), or you can demonstrate equivalent skills and knowledge prior commencing the course.

The course Introduction to ICT Infrastructure and Cloud Services (ICI001IT1AE) is recommended to be completed before taking the Data Management and Databases course.

The student
* shows passable activity and punctuality on the course
* has passable understanding of the course contents, core concepts and terminology
* has passable knowledge and skills in writing database queries in SQL
* has passable knowledge and skills in using data-oriented diagrams
* has some difficulties in using the course materials to support own learning.

The student
* shows good activity and punctuality on the course
* has good understanding of the course contents, core concepts and terminology
* has good knowledge and skills in writing database queries in SQL
* has good knowledge and skills in using data-oriented diagrams
* has sufficient knowledge and skills in creating a small and simple database
* can use the course materials in an effective way to support own learning.

The student
* shows excellent activity and punctuality on the course
* has excellent understanding of the course contents, core concepts and terminology
* has excellent knowledge and skills in writing database queries in SQL
* has excellent knowledge and skills in using data-oriented diagrams
* has good knowledge and skills in creating a small and simple database
* uses the course materials and independently found sources fluently to support own learning.