Database Theory and Practice for Actuarial Analysis

Lifetime access.
  • Learn about database theory, types of databases, RDBMS Platforms, data normalization & ERDs, basic to advanced SQL, and how to use databases effectively in an actuarial setting
  • 110+ video lessons (14+ hours of instruction)
  • Over 75 pages of sample SQL and VBA code that you can reference and reuse for your own purposes
  • Capstone project demonstrating actuarial database usage

An overview of our Database Theory & Practice Course

Database work is the starting point for predictive analytics, currently the hottest topic in actuarial work today. You can't get exciting results from Generalized Linear Models, Decision Trees, Advanced Regression Models, or Neural Networks unless you can obtain the data to feed those models.

Why take this course?

  • This course will cover an array of theory, terminology, and skills to help you effectively use your databases and interact with other professionals working with data.
  • This course is ideally suited for any aspiring or practicing actuaries that would like to advance their job skills and use databases more effectively.
  • This course is taught from an insurance perspective using insurance centric examples and exercises.
  • New capstones added periodically so that you can continue learning with lifetime access

Topics include:

  • Database theory & types of databases
  • RDBMS Platforms
  • Data normalization & ERDs
  • Basic to advanced Structured Query Language (SQL)
  • Special topics for actuarial analysts
  • I'm stuck with Microsoft Access - How do I use it effectively?
  • P&C Reinsurance Problem
  • Using Oracle

What is in the course?

  • Lectures in each topic with instructor commentary that simplifies difficult concepts
  • Capstone projects to tie it all together
  • Video solutions for each project along with commentary on the proper method to solve them
  • Let us know what you want to see added next

TIA Study

TIA Study

A Modern Learning Platform

  • Lessons, practice problems, flashcards, sample exams, and more all scheduled to have you ready on exam day
  • Tasks scheduled only on the days you plan to study
  • Create your own custom tasks
  • Miss a day? Your schedule will automatically redistribute all your remaining tasks
instructor photo

Arlie Proctor

  • FCAS, MAAA    |   
  • Database Theory and Practice

Arlie graduated from Indiana University in December of 1989 and became a Fellow of the Casualty Actuarial Society in 1995. Arlie has 25 years as a practicing actuary with a specialty in database and system design and implementation. He has worked in primary insurance, consulting, and most recently for a large international reinsurer.

Arlie is an active volunteer for the Casualty Actuarial Society and has held many leadership positions including Senior Part Specialist on the Syllabus Committee, Chair of the Education Policy Committee, Chair of the Examinations Committee, Chair of the Strategic Planning Committee, Chair of the Branding Task Force, Member of the Board of Directors, and Vice President of Marketing and Communications. He has been responsible for the database work behind the annual travel time report since 2000. ... read more

Arlie brings a very practical approach to teaching actuarial science and techniques. His focus is on preparing students to both pass exams and at the same time be effective practicing actuaries who can combine theory with practical applications.

In his spare time, Arlie enjoys fishing and playing guitar in the blues, folk, and heavy metal genres.

Arlie lives in New Jersey with his wife and two boys (one already in college studying Computer Science).
show less

Database Theory & Practice Course

Expanded Features

This is an on-demand course designed for actuarial analysis to build their skillset databases. When you register for this course you will gain access to the following items (except as noted) from the day you register for life.

Comprehensive Course

110+ comprehensive video lessons (14+ hours) covering the entire syllabus that simplify complicated info into more understandable terms and illustrate important concepts through examples and graphics.

Online Discussion Forum

Active dedicated course forum loaded with existing questions and answers on syllabus material and past exam questions. Instructors and our Support Team try to ensure everyone's questions are answered in a timely manner.?

Capstone Projects

This course includes capstone projects to tie it all together with each project having a video solution walking you through the best way to solve it. These projects are created to give you a true sense of what you can expect in an actuarial setting.

Offline Videos

Take our videos with you everywhere you go and don't worry about a data cap or WiFi signal. Use the TIA Study app on your mobile device to download lessons or solutions videos and have them right at your fingertips. ?

Variable Speed Playback

Watch our lessons and video solutions at your pace! When watching our videos on a desktop or our Learn App you can select the speed that makes the most sense for you. The variable speed increases all the way up to 2x.

Background Audio Playback

Just want to listen to our lessons? We have you covered! Now when you download the TIA Study app on an iOS or Android device, you can start a video and simply lock your device and the audio will continue to play.

Microsoft Office

This course requires you to have access to Microsoft Office. You can get a trial version of the software here. Also note you will need a computer running Microsoft Windows to use Access, there is not a Mac version.


Oracle is also used in this course. There is a free version of Oracle (Oracle Express) available and the course includes instructions on downloading and installing the free version along with the necessary ODBC drivers so that you can integrate Oracle with Microsoft Office products.

Student Discount

This course offers a student discount to full-time students currently enrolled at a college or university. To receive the discount, click here. The discount code will then be sent to the school issued email. ?

Excellent Customer Service

You're never alone with The Infinite Actuary. Get help from your instructor and assistants in our online forum. Anything else you need help with, not related to the course material, just reach out to our customer service team and they will get your questions answered!

Lifetime Access

As long as The Infinite Actuary offers this course, you will have access. The access is given for all of the material from this course, including updates! In fact, we encourage you to check in periodically to see new topics. ?

Frequently Asked Questions