Advanced Database and SQL (5 cr)
Code: DD10005-3001
General information
- Enrollment
- 01.10.2021 - 31.01.2022
- Registration for the implementation has ended.
- Timing
- 14.03.2022 - 20.05.2022
- Implementation has ended.
- Number of ECTS credits allocated
- 5 cr
- Local portion
- 0 cr
- Virtual portion
- 5 cr
- Mode of delivery
- Distance learning
- Unit
- Tradenomi / Tietojenkäsittely (DD)
- Campus
- Wärtsilä Campus Karjalankatu 3
- Teaching languages
- English
- Seats
- 25 - 60
- Degree programmes
- Degree Programme in Business Information Technology
Evaluation scale
H-5
Objective
- Student knows how to design and implement modern database solutions
- Student has moderate understanding and skills for different database models and techniques
Execution methods
- Online lectures and weekly exercises 32h
- Individual project work and self study 100h
Accomplishment methods
- Weekly exercises 50%
- Project work 50%
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