Databases
| Structure Type: | Course |
|---|
| Code: | KL25AB77000 |
|---|
| Type: | Compulsory |
|---|
| Level: | Bachelor |
|---|
| Credits: | 3.0 points |
|---|
| Responsible Teacher: | Lahti, Markku |
|---|
| Language of Instruction: | Finnish |
|---|
Course Implementations, Planned Year of Study and Semester
| Curriculum | Semester | Credits | Start of Semester | End of Semester |
| AUTE-2016SAUT |
2 autumn |
3.0 |
2017-08-01 |
2017-12-31 |
Learning Outcomes
The aim of the course is to familiarize the student with the basics of data warehouse. The student understands the relational database and document-base NoSql-database and learns the stages of the information analysis. Students will have command of SQL language.
Student's Workload
80 h, of which scheduled studies 40 h and autonomous studies 40 h
Prerequisites / Recommended Optional Courses
No previous studies are required.
Contents
The course comprises the following:
- Data warehouseing
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship)-modelling
- Main features of SQL (Structured Query Language)
Recommended or Required Reading
Material:
Hovi, Huotari, Lahdenmäki. Tietokantojen suunnittelu ja indeksointi, Docendo
Connolly Thomas - Begg Carolyn: Database Systems, Addison
Mode of Delivery / Planned Learning Activities and Teaching Methods
Lectures and exercises
Assessment Criteria
- Excellent (5): The student is able to apply the principles of database design in his/her exercises, and dominates the SQL language
- Good (3-4): The student masters well the principles of database design and basic of SQL language
- Satisfactory (1-2) The student knows the basics
Assessment Methods
Class exercises and an examination
Back