SQL Basics (3 cr)
Code: TT00AB74-3026
General information
Timing
01.01.2024 - 31.07.2025
Number of ECTS credits allocated
3 op
Virtual portion
3 op
Mode of delivery
Distance learning
Unit
School of ICT
Campus
Karaportti 2
Teaching languages
- Finnish
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
- Virve Prami
Teacher in charge
Janne Salonen
Groups
-
VIOPE_2024_MAKSULLINEN_JARJESTELMAViope TiVi (NonStop), year 2024
Objective
After the course, the student has a basic understanding of SQL language. The course will be blended distance learning.
Content
- Structured Query Language (SQL) introduction
- Queries: SELECT and WHERE
- Tools to create a query
- Organizing results
- INSERT, UPDATE & DELETE
- Scalar functions
- GROUP BY
- AS
- Tables, querys on multiple tables
- CREATE, ALTER ja DROP
Location and time
Because course is 100% online (Self-Study) course, study place and timetable is up to Student her-/himself.
Materials
Can be find on study environment.
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.
Evaluation scale
Hyväksytty/Hylätty
Assessment criteria, satisfactory (1)
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)
syntax:
- the student understands SQL syntax and is able to write relatively complex 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)
syntax:
- the student understands SQL syntax and is able to write relatively complex 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
When you have done 80% of tasks, please send email to viopesupport@metropolia.fi.
Further information
The course will be blended distance learning.