SQL and Relation Databases (3 cr)
Code: TT00CB01-3007
General information
Enrollment
05.05.2019
Timing
01.01.2020 - 31.12.2020
Number of ECTS credits allocated
3 op
Virtual portion
3 op
Mode of delivery
Distance learning
Unit
ICT ja tuotantotalous
Campus
Karaportti 2
Teaching languages
- English
Seats
0 - 3000
Degree programmes
- Tieto- ja viestintätekniikan tutkinto-ohjelma
Teachers
- Mika Hyyryläinen
Groups
-
ATX20TVAvoin amk - NonStop vuosi 2020
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
N/A
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 and CampusOnline Student: Please fill in eform
Metropolia's Degree Student: 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
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.