• Databases (TTC2020-3029),
         09.01.2023 – 28.02.2023,  4 cr  (ZJA22STIDI) — Online learning +-
    Learning outcomes of the course
    Objective
    After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read data base descriptions and make basic queries using SQL (Structured Query Language).

    Competences
    EU-EE EUR-ACE Engineering Design
    EU-KN EUR-ACE Knowledge and Understanding

    Objective
    You know the basic concepts of databases, you understand the generic structure of database system and its operational principle, you can read and create a database description based on the assignment. You also know the basics of SQL.
    Course contents
    Basic concepts related to databases
    Design of database with concept analysis
    Basics of SQL including database queries and database maangement.
    Assessment criteria
    Assessment criteria - grade 1 and 2
    Pass/Sufficient 1: The student is able to design and implement a simple database by creating a connection between at least two tables using basic and reference keys and make simple queries with SQL.

    Satisfactory 2: The student is able to design and implement a database and make basic queries with SQL. The assignment documentation contains at the very least a database description.
    Assessment criteria - grade 3 and 4
    Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.

    Very good 4: The student is able to design and implement a database where the choices have been justified. The student has a comprehensive command of SQL basic commands. The documentation of the assignment is thorough and the given presentation has been fluent.
    Assessment criteria - grade 5
    Excellent 5: The student is able to design and implement an out of the ordinary database where the choices have been justified and the metadata saved. The student is able to use SQL in demanding data retrieval tasks. The database documentation is extensive and understandable as well as well composed and fluently presented. The student is able to critically assess their own competence in the solutions.

    Language of instruction

    Finnish

    Planned learning activities, teaching methods and guidance

    Etäopiskelu (Videoluennot, omatoimiset harjoitukset, harjoitustyö, osaamistesti) (not translated)

    Learning materials and recommended literature

    Opintojakson verkkosivut (luentomateriaali, videoluennot, harjoitustehtävät) (not translated)

    Lecturer(s)

    Ari Rantala

    Campus

    Lutakko Campus

    Timing

    09.01.2023 - 28.02.2023

    Learning assignments and student workload

    Etäopiskelu 108 h (Videoluennot, omatoimiset harjoitukset ja harjoitustyö. Osaamistesti) Yhteensä 108 h (not translated)

    Groups
    • ZJA22STIDI
    Degree Programme

    Bachelor's Degree Programme in Information and Communications Technology

    Mode of delivery

    Online learning

    Share of virtual studies

    4 cr

    Credits
    • 4 cr
    Unit

    School of Technology