Introduction to Databases (self-access learning course)

Main themes and learning objectives »
581328
5
Software Systems
Basic studies
Kurssilla tutustutaan tiedon esitysmuotoihin ja tiedon hakuun suurista tietomääristä. Erityisenä painopisteenä ovat relaatiotietokannat, joiden kohdalla perehdytään toisaalta teoreettiseen perustaan ja toisaalta tietokannan käytännön käsittelyyn SQL-kielen avulla. Kurssilla opitaan myös perustiedot relaatiotietokantojen suunnittelusta.
Year Semester Date Period Language In charge
2010 autumn 07.09-15.10. 1-1 Finnish

Lectures

Time Room Lecturer Date
Tue 12-14 CK112 Harri Laine 07.09.2010-07.09.2010

Exercise groups

Group: 1
Time Room Instructor Date Observe
Tue 12-14 B119 Satu Eloranta 13.09.2010—24.09.2010
Tue 12-14 B221 Satu Eloranta 27.09.2010—08.10.2010
Tue 12-14 B119 Satu Eloranta 12.10.2010—12.10.2010
Group: 2
Time Room Instructor Date Observe
Wed 10-12 B119 Satu Eloranta 13.09.2010—24.09.2010
Wed 10-12 B221 Satu Eloranta 27.09.2010—08.10.2010
Wed 10-12 B119 Satu Eloranta 13.10.2010—13.10.2010

Kurssi toteutetaan itseopiskelukurssina ja luentoja on vain yksi aloitusluento.

General

This course is an introduction to database concepts, data modeling, design and  use of databases. It is a self-study course with only one lecture session (in Finnish). There are scheduled exercises and a small project work that is planed to be done as a group work (it may also be carried out as an indivuidual project).  The students that have registered for an exercise group are dividen into smaller groups of  4-6 students for the project work. Project groups that use English as their working language are arranged when needed. Exercise group sessions are used mainly for the project work.  The use of a database may be  exercised in an automated training environment. The solutions for  the exercise tasks will be published after the dedline of each group of tasks 

As a prerequisite the students should manage the basic concepts of  the mathematical set theory and the basics of programming.

Completing the course

Credits may be obtained from

  • Course exam (or renewal exam): at most 45 points, at least 22 points required to pass the course.
  • SQL exercises, at most 9 points
  • Project work at most 6 points.

 

Literature and material

  • The E-learning material and the exercise facilities are collected in the Moodle learning environment on  https://moodle.helsinki.fi/course/view.php?id=1805
    • To login the environment you should use your main user account  and password.  The password needed for course registration is  tikapes10.
  • Potential text books (chapters and pages listed in e-learning material)
    • Ramakrishnan r. & Gehrke J.: Database Management Systems, 3rd. ed, McGraw-Hill, 2003.
    • R. Elmasri & S. B. Navathe: Fundamentals of Database Systems, 5th ed., Addison-Wesley, 2007. (myös vanhempi 4. painos vuodelta 2003 käy)