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 Time | Teacher(s) | Language | Enrolment |
|---|---|---|---|---|
| 1 | 2006-10-30 – 2006-12-22 | Juhani Karppinen | Finnish | 2006-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.