IFRS 17 Data Management Example using SQL (S2)

Explore advanced queries in SQL centred around data management techniques showcased through an indicative IFRS 17 example.

Introduction

If you’re looking to learn more about advanced functionalities of SQL, this course is ideal for you. An individual subscription gives you 3 months’ online access to:

  •  Course materials
  • Discussion forums to engage and collaborate with like-minded individuals
  • Option to ask tutors questions through forums and Q&A sessions
  • Hands-on practical examples linked to financial reporting work
  • On demand access

As Well As

Our  Data Science Resource Library which features Actuartech and Industry specific curated additional content to assist you on your data science journey.

A IT engineer working on a project.
Someone working on an online course at their desk.

Pick from any of our introductory or advanced courses with bespoke insurance and actuarial specific case studies.

Our platform is easy to use and embeds the coding environment and learning material in one place to enable you to apply data science hands-on.

We provide case studies and projects relevant to actuarial work, and based on relevant datasets provided. You have the option to interact and network with your peers.

Overview

The purpose of this course is to expose students to advanced uses of SQL and gives an overview of how to run SQL queries. The course builds on the “Foundations in SQL for Actuaries” course by using Jupyter Notebooks to connect to a MySQL workbench and exploring complex queries.

Throughout this course, students are exposed to data science topics such as data storage, data processing, and data manipulation, as well as ethical and wider business considerations when using data science in practice.

Furthermore, we use an indicative IFRS 17 dataset as an example to showcase advanced queries. We also discuss how to create visualisations in SQL.

This course is presented through our training platform and uses Jupyter Notebooks, with the code and explanations embedded, to facilitate interactive coding. This allows you to run the code and make your own tweaks to see how it affects the outcome. In order to offer the interactive coding environment, we make use of Python to integrate the SQL syntax into our environment.


Get started

IFRS 17 Data Management Example using SQL

Sign up for a free preview of this IFRS 17 case study in SQL

Free Preview

Preview

£150 once-off (3-month access)

Enroll Today

Course Structure

Chapter 1 introduces the Problem Specification, beginning with an overview of MySQL and Python. It also provides a recap of basic SQL concepts.

Chapter 2 covers Data Collection which addresses how to connect and retrieve a database and discusses foundational and advanced queries on tables.

Chapter 3 on Data Querying showcases how to use different filters to get the desired data, how to flag and replace error entries, and how to use an absolute function.

Chapter 4 outlines Data Management which includes an introduction to views, how to create views, how to use data management techniques to manipulate data, performing calculations using advanced SQL queries, and creating a backup of results in databases.

Chapter 5 is an overview of Data Science Model Building and outlines some of the various statistical tools Python has and discusses manipulation and calculation using the SQL data model rather than building a new model. 

Chapter 6 on Visualisation shows students how to use a variety of statistical functions to produce some basic graphs which assists in understanding the data better and validating the models.

The Appendix contains additional reading and references to some of the packages discussed, as well as additional guides for MySQL and Python.

A person showing different sections of an online course

Who's this course suitable for?

  • Individuals and teams seeking to improve their knowledge on running SQL queries, particularly advanced queries.
  • Individuals and teams wanting to know how to manage and analyse their data on the same platform.
  • Individuals and teams working on implementing IFRS 17 and performing IFRS 17 calculations.

Why is this topic important?

  • Students learn to manage and manipulate data using simple queries, saving them a lot of time.
  • Students learn to create backups of their queried data in separate databases for later use.
  • Basic analysis is explored, introducing students to analysing data in an efficient manner.

Short note to say really enjoyed today’s webinar. It had a very clear message. […] fully in agreement with the comments that it is imperative we maintain our professional and ethical stance at all times if we want to continue to be trusted and relied on.

Webinars

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

Heading

Short note to say really enjoyed today’s webinar. It had a very clear message. […] fully in agreement with the comments that it is imperative we maintain our professional and ethical stance at all times if we want to continue to be trusted and relied on.

Webinars

I just wanted to say what an interesting presentation that was. Thank you so much for taking the time to put this on for us, it is very much appreciated by all – especially the flexibility around hosting as a webinar instead of the original [in-person] format. It worked very well indeed!

Webinars

I think I’m [one of the first actuaries in my area] who are pointing towards Data Science, creating the new [role] of Actuarial data Scientist. For this reason i [sic] decided to follow a post graduate master in Business Intelligence and Big data analytics. I'm actively following your company and i [sic] think it is one of the best Actuarial consulting company [sic] who [sic] is pointing towards data Science!

Webinars

I love your videos - being free and accessible really helped me. The Q&A session was fantastic! It always comes down to execution and I feel this should always accompany your presentations - answering the question of how will your participants use what you give them. Keep up the great work!

Round Table

Thank you for having me along. I really found it the most motivating conversation I’ve had in a while, and made me think about what I’m trying to achieve within this area. We all need evenings like that to get some perspective on what we *think* is going on and what actually is. It was a very good evening.

Round Table

It was a really good introduction to Data Science and afterwards I felt that I now have a platform that I could use to further my understanding in this area.

Webinars

I am really happy to have been part of the talk. It was very insightful and please keep doing more of this. I am a data science student currently but I have an actuarial background. I worked in life insurance for about 5 months before resigning to do my masters in Data science so that I blend the actuarial world and Data science together. The talk gave me perspective. Even suggested some potential topics for my Thesis.

Webinars
Get started

IFRS 17 Data Management Example using SQL

Sign up for a free preview of this IFRS 17 case study in SQL

Free Preview

Preview

£150 once-off (3-month access)

Enroll Today

Interested in Corporate Training?

We have tailored packages available to ensure that corporate teams have the option to attend structured live lessons by our tutors, and the option to request a practical assignment and bespoke feedback. Invoicing option available.