Advanced Database and SQLLaajuus (5 cr)

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

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

Execution methods

- Online lectures and weekly exercises 32h
- Individual project work and self study 100h

Accomplishment methods

- Weekly exercises 50%
- Project work 50%