• Databases (TTC2020-3028),
         30.08.2022 – 31.07.2023,  4 cr  (ZJA22STINO1, ...) — Online learning +-
    Learning outcomes of the course
    Purpose:
    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 database descriptions and make basic queries using SQL (Structured Query Language).

    EUR-ACE Competences:
    Knowledge and Understanding
    Engineering practice

    Learning outcomes:
    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, and you know the basics of SQL.
    Course contents
    Basic concepts related to databases
    Database design with conceptual analysis
    Basics of SQL including database queries and database management.
    Assessment criteria
    Assessment criteria - grade 1 and 2
    Pass/Sufficient 1: You are 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: You are 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: You are able to design and implement a database where the choices have been justified. You have a comprehensive understanding of SQL basic commands. The documentation of the assignment is thorough and the given presentation has been fluent.
    Assessment criteria - grade 5
    Excellent 5: You are able to design and implement an out of the ordinary database where the choices have been justified and the metadata saved. You are able to use SQL in demanding data retrieval tasks. The database documentation is extensive and understandable as well as well composed and fluently presented. You are able to critically assess your competence in your solutions.

    Language of instruction
    English
    Finnish
    Location and time

    Online course

    Planned learning activities, teaching methods and guidance

    Distance learning: Students can make the assignments at their own pace during the course (exercises and course exercise). Exam will be held at the end of the course (several available exam dates in each semester).

    Learning materials and recommended literature

    Course material page (material for course topics, exercises, course exercise guidance)

    Lecturer(s)

    Antti Häkkinen

    Campus

    Lutakko Campus

    Exam dates and re-exam possibilities

    The exam of the course is structured so that the student can choose the time of the exam, taking into account the time limitations of the non-stop implementation.

    Timing

    30.08.2022 - 31.07.2023

    Learning assignments and student workload

    Distance learning (exercises, course exercise, preparation for exam) for total of 108 hours

    Groups
    • ZJA22STINO1
    • ZJA22STINO2
    • ZJA23KTINO3
    Assessment methods

    Avoin amk 48 (not translated)

    Degree Programme

    Bachelor's Degree Programme in Information and Communications Technology, 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