Learn the most in-demand data and UX design skills

We are passionate about "discovering new healthcare opportunities and designing" intelligent solutions that help improve health. Therefore, we also have an ambition for our partners to gain new data techniques and design skills. We offer courses focused on building strong skills in relevant techniques in a practical and domain-specific way.

We look forward to seeing you here!

This course will help you understand and apply the updated data model for the Danish National Patient Registry (LPR3).

The course provides in-depth insight into the structure and application of LPR3, which is the latest data model for the National Patient Registry, which Enversion has built as a consulting project for the Danish National Board of Health. The course starts with an introduction to dimensional modelling, which is the basis for LPR3. In addition, we look at the practical application of LPR3 in the form of examples and assignments.

Content

• Dimensional modelling: facts, dimensions, bridges, surrogate keys and star chart

• LPR data model

• Modelling of disease courses in courses, contacts and contact locations

• Examples of use

Who is the target audience?

Anyone working with health data from LPR. E.g., data managers, researchers, statisticians, PhD students and research year students.

How long is it?

The course lasts one normal working day.

Price:

3.995 dkr ex VAT. An invoice will be sent after the course.

If there are fewer than 7 participants, the course date will be rescheduled.

This course is primarily aimed at people who are entirely new to the SQL language. We start from scratch and do not require any other programming experience, but you may have worked with STATA, SAS, or similar. The course combines lectures, examples, and exercises at the PC, using Microsoft SQL Server Management Studio as a tool.

Content

• Data types

• Tables and relationships

• Calculated variables/columns

• Aggregation functions

• Data manipulation functions

Introduction to more advanced SQL: Subqueries and window functions

Who is the target audience?

SQL novices in public organizations as well as private companies.

How long is it?

The course lasts one normal working day.

Price:

3.995 dkr ex VAT. An invoice will be sent after the course.

If there are fewer than 7 participants, the course date will be rescheduled.

The course requires knowledge of the SQL language and is aimed at people who want to raise their SQL level from "fair" to good or those who have a good understanding of SQL but have never learned the underlying structures.

The course combines lectures, examples, and exercises at the PC, using Microsoft SQL Server Management Studio as a tool.

Content

• Introduction to T-SQL Programming

• Single-table queries

• Set Operators

• Joins

• Subqueries

• Window Functions

• Table Expressions

• Apply

• Pivot

• Tips and Tricks

• Performance optimization

Who is the target audience?

SQL-experienced

How long is it?

The course lasts 3 regular working days.

Price:

12.000 dkr ex. VAT. An invoice will be sent after the course.

If there are fewer than 7 participants, the course date will be rescheduled.