Skip to main content

Advanced database and SQL (5 cr)

Code: DD10005-3001

General information


Enrollment

01.10.2021 - 31.01.2022

Timing

14.03.2022 - 20.05.2022

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Campus

Wärtsilä Campus Karjalankatu 3

Teaching languages

  • English

Seats

25 - 60

Degree programmes

  • Degree Programme in Business Information Technology

Teachers

  • Radu Mariescu-Istodor
  • Jyri Kemppainen

Teacher in charge

Jyri Kemppainen

Groups

  • KATS21SI
    SmartICT - Expert in Intelligent Automation Programming

Objective

- Student knows how to design and implement modern database solutions
- Student has moderate understanding and skills for different database models and techniques

Content

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

Evaluation scale

H-5

Qualifications

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