Skip to main content

SQL for Actuaries and Data Scientists

Register Today!





    This is an introductory course designed to give students an intermediate proficiency in SQL. By the end of this course, students will understand the structure of databases and be able to write queries.

    With more than half a decade of experience as a Data Engineer and Data Analyst, Brian Jankowitz has worked across the utilities and healthcare industries, transforming complex data into clear, actionable insights. His work has focused heavily on automating reporting solutions, building interactive dashboards powered by robust data repositories developed with Python and SQL scripts.

    SQL for Actuaries and Data Scientists Offers The Following:

    Objectives

    By taking this course you will learn the following skills:

    • To understand relational databases
    • To retrieve data from a table
    • To aggregate and summarize data
    • To work with multiple tables

    Schedule

    Weekly Live Classes & Subjects

    Sept 15th noon EDT

    Week 1
    SQL Set Up, Introduction to Databases, Data Types, Data Retrieval, Filtering Data

    Content:

    • SQL set up
    • Overview of databases
    • Data models, relationships, columns, and schemas
    • Data types
    • Review different systems
    • SQL syntax
    • Best practices for readable queries
    • SELECT and FROM
    • How DISTINCT is used
    • Filtering data WHERE (AND, OR, NOT)
    • Comparison operators (=, <, >, <=, >=, <>)
    • BETWEEN, IN, and Like

    Application:

    • To understand databases, be able to pull data from databases, and use comparison operators

    Sept 22rd noon EDT

    Week 2
    Sorting and Limiting Data, Aggregation, Joins

    Content:

    • Review SQL from previous class
    • Quiz 1
    • ORDER BY and LIMIT
    • Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
    • ROUND
    • GROUP BY
    • HAVING
    • Data cleaning
    • How to handle outliers
    • Missing data (how to approach this, data exploration)
    • Practice Questions

    Application:

    • To perform calculations on rows and by groups

    Sept 29th noon EDT

    Week 3
    Joins, If Statements

    Content:

    • Review SQL from previous class
    • Quiz 2
    • Overview of table relationships
    • INNER JOIN, LEFT JOIN, OUTER JOIN, CROSS JOINS
    • IFNULL, CASE, and COALESCE (Review differences)
    • Practice Questions

    Application:

    • To combine data from multiple tables, format numerical values, and write conditional statements

    October 6th noon EDT

    Week 4
    Data Manipulation

    Content:

    • Review SQL from previous class
    • Quiz 3
    • Subqueries
    • Overview of temporary tables
    • WITH
    • Overview of views
    • Overview of query optimization
    • Practice Questions

    Application:

    • To nest queries within other queries and provide an overview of query optimization to improve performance

    Join SQL for Actuaries and Data Scientists Today!

    REGISTER