suomeksi
in English
Tietokantajärjestelmien hallinta ja ylläpito (L0039), 3 op
Basic information
| Course name: | Tietokantajärjestelmien hallinta ja ylläpito Management and Maintenance of a Database System |
| Course Winha code: | L0039 |
| Kurre acronym: | Tietokantajärj. |
| Credits: | 3 |
| Type and level of course: | Professional studies |
| Year of study, semester or study period: | 2.year |
| Implementation: | Spring semester, 4.period |
| Semester: | 0708 |
| Language of tuition: | Suomi |
| Teacher: | Aarne Klemetti |
| Final assessment: | Grading scale (0-5) |
Descriptions
Prerequisites
Introduction to Computing, Application Development, Data Management
Basic knowledge in programming, application development and database management are compulsory prerequisites.
Course contents (core content level)
- Installation of database management system
- Database management system documentation
- The Creation and application of database management system files
- Administration of users, groups, and roles
- Definition of user rights
- Import and export of data between different systems
- Data backup and restoration
- Automation: sequences, triggers, and stored procedures: their creation, exploitation, and administration
- Optimization of processes: queries, indexing, table and file structures
- The principles of distribution and scalability in database management
Course contents (additional)
- Installation, administration, and maintenance of a commercial database management system (Oracle)
- Special properties and concerns in installation and maintenance of a database system placed by the operating system and the database management system
- The definition and implementation of a database management system
- Requirements for maintenance
Core content level learning outcomes (knowledge and understanding)
After completing the course the student knows the basics of implementation of a database management system and is capable of participating in the design processes of databases and managing them successfully.
Core content level learning outcomes (skills)
After completing the course the student knows how database management systems are implemented in practice. The student is capable of participating in the selection of architectures and process automation design and can define the routines adopted in maintenance and optimization.
Recommended reading
The documentation of the installed database management system
Learning log recorded during the installation and maintenance process
Web material
Teaching and learning strategies
Laboratory exercises 22 h
Lab sessions 28 h
Student individual workload 30 h
Total 80 h
Teaching methods and student workload
Ohjattu laboratoriotyö
Self-study
Laboratory assignments
Assessment weighting and grading
Assessment of the compulsory exercise assignments and individual presentation.
Related competences of the degree programme
Theoretical basis and mathematical and science skills
Information acquisition skills and adaptation of new knowledge