SQL and Relational DatabasesLaajuus (3 cr)
Code: TT00CB01
Credits
3 op
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
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.
Enrollment
02.07.2024 - 31.07.2024
Timing
01.08.2024 - 31.07.2025
Number of ECTS credits allocated
3 op
Virtual portion
3 op
Mode of delivery
Distance learning
Campus
Karaportti 2
Teaching languages
- Finnish
Degree programmes
- Information and Communication Technology
Teachers
- Janne Salonen
Groups
-
VIOPE_NonStop7VIOPE_NonStop7
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
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.
Timing
16.04.2024 - 31.12.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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Virve Prami
Teacher in charge
Janne Salonen
Groups
-
VIOPE_2025_MAKSULLINEN_JARJESTELMAOpen UAS 2025
-
VIOPE_2024_MAKSULLINEN_JARJESTELMAViope TiVi (NonStop), year 2024
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
01.01.2024 - 31.12.2027
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
- English
Seats
0 - 10000
Degree programmes
- Degree Programme in Information Technology
Teachers
- Mika Hyyryläinen
Groups
-
IT_path_180_ectsInformation Technology, Open path 180 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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
01.01.2024 - 31.07.2024
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
AMK_osaaja_TiviUAS Competential (Tivi)
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
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
- English
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, 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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Enrollment
02.07.2024 - 31.07.2024
Timing
01.01.2024 - 31.07.2024
Number of ECTS credits allocated
3 op
Virtual portion
3 op
Mode of delivery
Distance learning
Campus
Karaportti 2
Teaching languages
- Finnish
Degree programmes
- Information and Communication Technology
Teachers
- Janne Salonen
Groups
-
VIOPE_NonStop6VIOPE_NonStop6
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
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.
Enrollment
02.07.2024 - 31.07.2024
Timing
01.01.2024 - 31.07.2024
Number of ECTS credits allocated
3 op
Virtual portion
3 op
Mode of delivery
Distance learning
Campus
Karaportti 2
Teaching languages
- Finnish
Degree programmes
- Information and Communication Technology
Teachers
- Janne Salonen
Groups
-
Viope_nonstop_9Viope_nonstop_9
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
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.
Enrollment
02.07.2024 - 31.07.2024
Timing
01.01.2024 - 31.07.2024
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
Degree programmes
- Information and Communication Technology
Teachers
- Janne Salonen
Teacher in charge
Janne Salonen
Groups
-
Viope_nonstop_11Viope_nonstop_11
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
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.
Enrollment
02.07.2024 - 31.07.2024
Timing
01.01.2024 - 31.07.2024
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
Degree programmes
- Information and Communication Technology
Teachers
- Janne Salonen
Teacher in charge
Janne Salonen
Groups
-
Viope_nonstop_12Viope_nonstop_12
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
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.
Enrollment
02.07.2024 - 31.07.2024
Timing
01.01.2024 - 31.07.2024
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
Degree programmes
- Information and Communication Technology
Teachers
- Janne Salonen
Teacher in charge
Janne Salonen
Groups
-
Viope_nonstop_13Viope_nonstop_13
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
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.
Enrollment
02.07.2023 - 31.07.2023
Timing
01.08.2023 - 31.07.2024
Number of ECTS credits allocated
3 op
Virtual portion
3 op
Mode of delivery
Distance learning
Campus
Karaportti 2
Teaching languages
- Finnish
Degree programmes
- Information and Communication Technology
Teacher in charge
Janne Salonen
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
Evaluation scale
0-5
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.
Enrollment
02.12.2022 - 31.12.2022
Timing
01.01.2023 - 31.07.2024
Number of ECTS credits allocated
3 op
Virtual portion
3 op
Mode of delivery
Distance learning
Campus
Karaportti 2
Teaching languages
- Finnish
Degree programmes
- Information and Communication Technology
Teachers
- Janne Salonen
Teacher in charge
Janne Salonen
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
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.
Timing
27.02.2023 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop3VIOPE_NonStop3
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
27.02.2023 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop3VIOPE_NonStop3
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
27.02.2023 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop4VIOPE_NonStop4
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
27.02.2023 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop4VIOPE_NonStop4
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
27.02.2023 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop4VIOPE_NonStop4
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
27.02.2023 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop4VIOPE_NonStop4
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
27.02.2023 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop5VIOPE_NonStop5
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
27.02.2023 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop5VIOPE_NonStop5
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop3VIOPE_NonStop3
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.12.2022
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
- English
Seats
0 - 10000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop3VIOPE_NonStop3
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.12.2022
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
- English
Seats
0 - 1000
Degree programmes
- Degree Programme in Information Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop3VIOPE_NonStop3
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop3VIOPE_NonStop3
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop4VIOPE_NonStop4
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop4VIOPE_NonStop4
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.12.2022
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
- English
Seats
0 - 10000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop4VIOPE_NonStop4
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.12.2022
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
- English
Seats
0 - 1000
Degree programmes
- Degree Programme in Information Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop4VIOPE_NonStop4
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop4VIOPE_NonStop4
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop5VIOPE_NonStop5
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.12.2022
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
- English
Seats
0 - 10000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop5VIOPE_NonStop5
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.12.2022
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
- English
Seats
0 - 1000
Degree programmes
- Degree Programme in Information Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop5VIOPE_NonStop5
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop5VIOPE_NonStop5
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
02.11.2022 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop3VIOPE_NonStop3
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
02.11.2022 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop4VIOPE_NonStop4
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
02.11.2022 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop4VIOPE_NonStop4
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
02.11.2022 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop5VIOPE_NonStop5
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
01.08.2022 - 31.12.2023
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
- Virve Prami
Teacher in charge
Janne Salonen
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
01.08.2022 - 31.12.2023
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
- Virve Prami
Teacher in charge
Janne Salonen
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
01.08.2022 - 31.12.2023
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
- Virve Prami
Teacher in charge
Janne Salonen
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
01.08.2022 - 31.12.2023
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
- Virve Prami
Teacher in charge
Janne Salonen
Groups
-
VIOPE_NonStop7VIOPE_NonStop7
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
01.08.2022 - 31.12.2023
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
- Virve Prami
Teacher in charge
Janne Salonen
Groups
-
VIOPE_NonStop7VIOPE_NonStop7
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
01.08.2022 - 31.12.2023
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
- Virve Prami
Teacher in charge
Janne Salonen
Groups
-
VIOPE_NonStop7VIOPE_NonStop7
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
31.07.2022 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStop3VIOPE_NonStop3
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
28.02.2022 - 06.08.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
ATX22TVKOpe UAS: NonStop Spring 2022
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
01.01.2022 - 31.12.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE_NonStopViope (NonStop)
-
VIOPE_2022_MAKSULLINEN_JÄRJESTELMÄViope TiVi (NonStop), year
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
01.01.2022 - 31.12.2022
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
- English
Seats
0 - 10000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
AMK_OSAAJA_2022_TIVIUAS Competential 2022 (Tivi)
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
03.11.2021 - 27.02.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
ATX22TVKOpe UAS: NonStop Spring 2022
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
15.03.2021 - 31.12.2023
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
- English
Seats
0 - 500
Degree programmes
- Information and Communication Technology
Teacher in charge
Janne Salonen
Groups
-
CareerBoost_TXK_21Career Boost 21 (Tivi)
-
CareerBoost_TXK_22Career Boost 22 (TiVi)
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.
Timing
12.11.2020 - 31.07.2022
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
- English
Seats
0 - 5000
Degree programmes
- Information and Communication Technology
Teachers
- Mika Hyyryläinen
Groups
-
VIOPE2021Viope 2021
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
Riippuu opiskelijasta itsestään.
Materials
Löytyy kurssiympäristöstä.
Teaching methods
100% netin kautta itsenäisesti suoritettava kurssi.
Employer connections
N/A
Exam schedules
Tieto löytyy oppimisympäristöstä.
International connections
N/A
Completion alternatives
N/A
Student workload
Riippuu opiskelijasta itsestään.
Content scheduling
Riippuu opiskelijasta itsestään.
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.