SQL and Relational Databases (3 ECTS)

Objective

After the course, a student has ability to understand and maintain SQL and relational databases

Content

- Introduciton to relational databases, basics of relational model, introduction to SQL, planning and creating a database, tools

Location and time

Up to Student her-/himself.

Materials

Online

Teaching methods

100% online (Self-Study) course.

Employer connections

N/A

Exam schedules

Can be find on study environment.

International connections

N/A

Completion alternatives

N/A

Student workload

Up to Student her-/himself.

Content scheduling

Up to Student her-/himself.

Further information

ENROLLING

Open UAS Student via https://hakija.oma.metropolia.fi/
CampusOnline Students via eform which can be find via https://campusonline.fi

Metropolia's Degree Student
- Go to https://vw4.viope.com/login?org=metropolia
- Register to system -> Click the link “Enroll on the course”
- Choose any course of (NonStop).
- Fill the others fields

If you have problems with enrolling into this course or questions about it, please contact to viopesupport@metropolia.fi

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, satisfactory (1)

aradigm:
- the student understands what relation applied to databases is, understands normalization and is able to do the normalization with the instructor's help;
syntax:
- the student understands SQL syntax and is able to write simple SQL syntax with the instructor's help;
queries and result arrangement:
- the student understands what SQL queries and result arrangements are and is able to write and use them with the instructor's help;
database modification:
- the student understands what INSERT, UPDATE & DELETE are and is able to write and use them with the instructor's help;

Assessment criteria, good (3)

paradigm:
- the student understands what relation applied to databases is, understands normalization and is able to do the normalization;
- the student shows independent solutions.
syntax:
- the student understands SQL syntax and is able to write simple SQL syntax;
- the student shows independent solutions.
queries and result arrangement:
- the student understands what SQL queries and result arrangements are and is able to write and use them;
- the student shows independent solutions.
database modification:
- the student understands what INSERT, UPDATE & DELETE are and is able to write and use them;
- the student shows independent solutions.

Assessment criteria, excellent (5)

paradigm:
- the student understands what relation applied to databases is, understands normalization and is able to do the normalization;
- the student shows independent solutions and critical evaluation.
syntax:
- the student understands SQL syntax and is able to write simple SQL syntax;
- the student shows independent solutions and critical evaluation.
queries and result arrangement:
- the student understands what SQL queries and result arrangements are and is able to write and use them;
- the student shows independent solutions and critical evaluation.
database modification:
the student understands what INSERT, UPDATE & DELETE are and is able to write and use them;
- the student shows independent solutions and critical evaluation.

Assessment methods and criteria

Pass, after Student have done 80% or more of the course.