•     Advanced database and SQL DD10005-3001 14.03.2022-20.05.2022  5 cr  (KATS21SI) +-
    Learning objectives
    - Student knows how to design and implement modern database solutions
    - Student has moderate understanding and skills for different database models and techniques
    Starting level and linkage with other courses
    Prerequisites:
    • Student has knowledge and skills in basic relational database and data warehouse models and techiques
    • Student knows how to build basic web based database solutions (full stack)
    • Students has basic knowledge and skills in SQL
    Contents
    Database concepts and models
    Database administration: Integrity, Security, and Privacy
    Database programming:
    - SQL databases:
    - triggers, stored procedures and functions
    - embedded SQL
    - optimization
    - Database API
    - Comparison of different database languages
    Large databases
    - Design methods
    - Data Warehouse (ETL and ELT), Data mart, and Operational data store (ODS)
    - Online analytical processing (OLAP), Online transaction processing (OLTP), and Customer relationship management (CRM)
    - Data lakes and big data
    Responsible person

    Jyri Kemppainen

    Mode of delivery

    Distance learning

    Campus

    Wärtsilä Campus Karjalankatu 3

    Teaching language

    English

    Timing

    14.03.2022 - 20.05.2022

    Enrollment

    01.10.2021 - 31.01.2022

    Groups
    • KATS21SI
    Teachers

    Jyri Kemppainen, Radu Mariescu-Istodor

    Seats

    25 - 60

    Degree Programmes

    Degree Programme in Business Information Technology

    Virtual proportion

    5 cr

    Evaluation scale

    H-5