•     SQL and Relational Databases TT00CB01-3008 28.10.2020-28.02.2021  3 credits  (VIOPE_NonStop) +-
    Learning outcomes of the course
    After the course, a student has ability to understand and maintain SQL and relational databases
    Course contents
    - Introduciton to relational databases, basics of relational model, introduction to SQL, planning and creating a database, tools
    Assessment criteria
    Satisfactory
    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;
    Good
    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.
    Excellent
    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.
    Name of lecturer(s)

    Mika Hyyryläinen

    Mode of delivery

    Distance learning

    Recommended or required reading

    Online

    Planned learning activities and teaching methods

    100% online (Self-Study) course.

    Assessment methods and criteria

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

    Language of instruction

    English

    Timing

    28.10.2020 - 28.02.2021

    Group(s)
    • VIOPE_NonStop
    Seats

    0 - 5000

    Unit, in charge

    School of ICT

    Teacher(s)

    Mika Hyyryläinen

    Further information for students

    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

    Degree Programme

    Information and Communication Technology

    Unit location

    Karaportti 2

    Virtual proportion

    3 credits

    Evaluation scale

    Hyväksytty/Hylätty

    Completion alternatives

    N/A

    Work placement(s)

    N/A

    Exam schedule

    Can be find on study environment.

    International connections

    N/A

    Students use of time and load

    Up to Student her-/himself.

    Content periodicity

    Up to Student her-/himself.

    Location and Time

    Up to Student her-/himself.