Foundations in SQL for Actuaries (S1)

Learn the fundamentals of SQL through interactive Jupyter Notebooks, discover basic and complex SQL functionalities, data manipulation, and overall data management tools & techniques.

Introduction

If you’re looking to learn the foundations of SQL, this course is the ideal place to start. An individual subscription gives you 3 months’ online access to:

  • Course materials
  • A personal coding environment through Jupyter Notebooks
  • 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 actuarial 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.

You can also request to do the online assignment for an additional fee; and if successful a course completion certificate could be issued.

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

“Foundations in SQL for Actuaries” introduces students to the data science pipeline whilst teaching them the fundamentals of the open-source querying language, SQL.

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.

In this course, we consider various types of queries to build up from scratch. Each chapter has been formulated to deepen your knowledge as you progress and contains exercises to develop the practical know-how which will allow you to apply this course in practice.

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 using SQLite.

Get started

Foundations in SQL for Actuaries

Sign up for a free preview of this introductory course in SQL

Free Preview

Preview

£150 once-off without assignment (3-month access)

Enroll Today

Course Structure

Chapter 1 introduces Problem Specification, beginning with an overview of SQL. It highlights what SQL is and the different platforms on which you can use SQL. It also introduces students to the basic query clauses such as SELECT, FROM, and WHERE.

Chapter 2 covers Data Querying which addresses the different clauses and functionalities that can be placed within the query (e.g. GROUP BY and HAVING) to manipulate your search on your database, allowing you to retrieve the data you desire. 

Chapter 3 on Database Management showcases how to write purpose-built queries to manage data, and how to transform and manipulate a dataset within your database by discussing queries such as UPDATE, INSERT, and DELETE.

In Chapter 4, Database Creation, we focus on creating our database from scratch. By building our tables and using the techniques discussed in Chapter 3, we show how to modify data within the newly created tables. Here, we show how to use the CREATE TABLE function and more.

Chapter 5 covers Advanced SQL in which we look at more complex operations that can take place within the SQL language and we present complex examples.

The Appendix contains additional reading and references to some of the basic concepts discussed, as well as an additional guide for SQLite and MySQL.


A person showing different sections of an online course

Who's this course suitable for?

  • Individuals and teams who wish to learn how to code in SQL.
  • Individuals and teams who wish to understand how data science can enhance their operations.
  • Individuals and teams who wish to analyse data effectively and perform SQL queries.

Why is this topic important?

  • SQL can retrieve and manipulate large datasets allowing actuaries to spend more time analysing and communicating results.
  • Repetitive tasks can be easily automated in SQL through different queries.
  • Datasets from different sources can be easily merged using JOINS in SQL.
  • Data required can be accessed in a short amount of time.
  • SQL has an extensive list of functions that are useful in a data science context.

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

Foundations in SQL for Actuaries

Sign up for a free preview of this introductory course in SQL

Free Preview

Preview

£150 once-off without assignment (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.