VAMK

Change language: Suomi

Front Page > Archived Education > Business Information Technology (T-TK) > 2005 > Year 2 > Database Administration (TTS2102)

Database Administration

Structure Type: Study unit
Code: TTS2102
Type: Optional obligatory / Professional Studies
Curriculum: T-TK 2005
Level: Bachelor of Business Administration
Year of Study: 2 (2006-2007)
Credits: 5 cr
Responsible Teacher: Tuomaala, Raija
Language of Instruction: Finnish

Courses During the Academic Year 2006-2007

Impl.Study TimeTeacher(s)LanguageEnrolment
12006-10-30 – 2006-12-22Juhani KarppinenFinnish2006-10-09 – 2006-11-05

Learning Outcomes

The student understands the principles of different database structures and is able to evaluate their usability. He can implement the designed database according to given requirements and masters any necessary maintenance routines.

Student's Workload

Total work load of the course: 135 h
- of which scheduled studies: 65 h
- of which autonomous studies: 70 h
The assesment of student's own learning 1 h is included in contact lessons.

Prerequisites / Recommended Optional Courses

Basics of Databases, Client/server Databases

Contents

Advanced SQL
Database design procedure.
XML and JSON.
Data Warehousing.
Clarification of routines in database maintenance and usage.

Regional Impact

Companies that develop software in this area use largely the database management system that is teached in this course.

Internationality

The course teaches programming skills that support companies to develope business software globally.

Recommended or Required Reading and Other Learning Resources/Tools

Web pages indicated by the lecturer and other current material available on the Internet.
Hovi, Huotari, Lahdenmäki (2005): Tietokantojen suunnittelu & indeksointi, ISBN 9789518462623
Hovi, Hervonen, Koistinen (2009): Tietovarastot ja Business Intelligence, ISBN 9789510347928

Mode of Delivery / Planned Learning Activities and Teaching Methods

Progressive exercises.

Assessment Criteria

5=The student can use advanced, multifunctional SQL. She or he knows and can use different methods of datawarehousing.
3=The student can use multifunctional SQL. She or he knows different methods of datawarehousing.
1=The student can use multifunctional SQL. She or he knows the essential terminology of datawarehousing.

Assessment Methods

Numerical assessment (0-5).
At the beginning of the course the evaluation method will be agreed on together with the student group. Evaluation is made either by taking exams or by completing assignments or both.


Back