Data Management and Databases - Study guide

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.

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.

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.

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.

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.

The course material is available in Moodle.

Pasila Campus

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

English

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

19.08.2024 - 13.12.2024

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

03.06.2024 - 16.08.2024

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.

ITE2PAICB1
CONTACT
ITE2PASOF1

Kari Silpiö

15 - 30

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.

* Haaga-Helia's policy: When the implementation type of the course is contact, online or blended it is required that the student is present during those teaching hours that are marked in the study schedule. If you are absent more than 25%, your grade will be lowered by one. If you are absent more than 50%, the course is failed.

ITBBA Business Information Technology

0.00 cr

H-5