Introduction to SQL and Relational DatabasesLaajuus (2 ECTS)

Objective

This course introduces students to basics of relational databases and SQL language.

Content

Course theory is divided into 17 chapters of which 11 includes programming exercises. Theory begins with basics of relational model and database design. Contents of these chapters are deepened in chapters 9 and 10, and 16 which demonstrates database normalisation. Chapters 4-8 teach how SQL language is used to implement database structure, insert data into database or update data in database and make basic queries. The latter part of the course offers more advanced techniques to use SQL queries and introduces students to use of views in relational databases.

Assessment criteria, approved/failed

All programming assignments have to be solved so that the checking system of Viope accepts them to be correct.
All multiple choice quizzes must be answered.
Online feedback questionnaire must be answered and returned.

Further information

Online course