SQL Basics (3 cr)

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.