Relational databases & SQL (5 cr)

Objectives (course unit)

You understand the basics of relational databases You know the basic commands of SQL databases You can use multiple tables in a single database You can use more varied techniques in your database queries You understand the basics of database design You know what data integrity means and how to apply with databases You can use databases efficiently and understand how to improve said trait

Content (course unit)

Introduction SQL Basics Multible tables More techniques Designing databases Data integrity Efficiency

Exam schedules

The exam is in Itslearning.

Assessment methods and criteria

The grade is dependent on the amount of exercises done. In addition at the end of the course is an exam, graded pass/fail. The exam does not affect the grade, but must be passed to get the course grade.

Assessment scale

0-5

Teaching methods

The course is done online

Learning materials

Course information and exam in Itslearning, material in https://centria.github.io/databases/

Student workload

Kurssi on 5 opintopistettä, eli vastaa noin 135 tuntia opiskelijan työtä.

Further information

To attend the course, you need to install some software on your computer. Instructions in the course material.