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
-
KATS21SISmartICT - 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