The purpose of the course is to learn the database structure of SimCorp Dimension. Understanding the database structure will both ease the use of SimCorp Dimension for you as end-user as well as making the Data Extraction and report developing a much easier task.
The scope of the course is to give the participants a basis for report developing and analysis through any report generator. It is out of the scope of this course to describe the report generators. However, during the course we use Seagate Crystal Reports and SQL developer to retrieve data.
Introduction to Database Theory
- What is a Database?
- Normalized Database
- Structured Query Language
- Joining Tables
- Database Views
- Domain Values
- Using online help to retrieve field and table names
SimCorp Dimension Database Structure
- Static and Reference Data Structure
- Transactions structure
- Holdings structure
- Market data structure
- Portfolio calculation
- FX Instruments
Pre-requisites:Basic database understanding (tables, fields, SQL, joins)
Days: 1 day
Daily training hours: 9:00-17:00
Course Fee: EUR 925 (excl. VAT)
How to register for this course
Click your preferred date below and register by filling out the form.
If no date is found for your preferred course please contact firstname.lastname@example.org to request the course.