Course structure
Welcome to the Relational Databases and SQL course!
If you just want to learn
To attend the course, you do not have to be a student in Centria University of Applied science. All the material and exercises are available online. If you want to get ECTS credits for the course, you have to register to Centria Open University.
Registering to Open University course
You can register to the course from HERE.
Course structure
The list below does not include everything, but exists to give a guideline for students, what to expect each week. This list may extend as the course goes on.
| Part | Goal |
|---|---|
| 1 | Introduction |
| 2 | SQL Basics |
| 3 | Multible tables |
| 4 | More techniques |
| 5 | Designing databases |
| 6 | Data integrity |
| 7 | Efficiency |
Read next about the exercises and exam.
Prerequisites
You do not need to install anything on your computer. However, some parts of the material use SQLite in the examples. It is voluntary to download and install, and can be found from here: SQLite Download page
You need to have a MOOC.fi account for submitting the exercises. You can read the instructions from here: https://www.mooc.fi/en/installation/vscode/#mooc.fi-create-account. If you have one already, use your existing one.
Errors in the material?
Did you find an error? A typo perhaps? Please make a pull request at GitHub and help us make the material better!