SQL for Actuaries and Data Scientists

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 15^th 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 22^rd 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 29^th 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 6^th 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

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.