suomeksi
in English
Tiedonhallinta (V0115), 4 op
Basic information
| Course name: | Tiedonhallinta Database Management |
| Course Winha code: | V0115 |
| Kurre acronym: | Tiedonhall |
| Credits: | 4 |
| Type and level of course: | Professional studies |
| Year of study, semester or study period: | 2.year |
| Implementation: | Autumn semester, 1.period, 2.period |
| Semester: | 0607 |
| Language of tuition: | Suomi |
| Teacher: | |
| Final assessment: | Grading scale (0-5) |
Descriptions
Prerequisites
Course contents (core content level)
· Relational data model: tables, keys, indexes, relations, referential integrity
· structural models for relational databases
· design methods of relational databases
· the principles of Standard Query Language (SQL)
· the use of SQL in creating, quering and maintaining relational databases
· management of events
· security
· use of SQL in programming
· interfaces from back end applications (e.g. API, DDE, CGI)
· data warehousing and data mining principles
· convergence from productional databases to data warehouses
Course contents (additional)
Core content level learning outcomes (knowledge and understanding)
The goal is to study the relation theory, the structure and design methods for maintainable relational databases, and Standard Query Language (SQL) as the language for database management. The network access to databases from operating systems and applications will also be covered in the course. Various examples of typical networked database applications will be presented and analysed.
After completing the course the student will
· understand the concepts and functionality of relational databases
· know the methods used in developing networked database applications
· be able to implement networked databases and manage them with SQL
· understand the transactions and their control in large distributed systems
· integrate relational databases with back end applications
· understand the concepts of data warehouses and data mining
Core content level learning outcomes (skills)
Recommended reading
Teaching and learning strategies
lectures 28 h
calculation H
laboratory 28 h
practice H
projects 20 h
exams 4 h
selfstudy 53 h
TOTAL 133 h