Introduction to SQL
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.
Sign Up Now
Instructor: Brian Jankowitz
With more than half a decade of experience as a Data Engineer and Data Analyst, Brian 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.
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
Course Schedule
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
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
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
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
Prerequisites:
Students should have at least a basic understanding of the following topics and exams.
- Familiarity with basic arithmetic operations
Required Software/Operating System:
- Mac or Windows Computer
- MYSQL
- Slack
Join Computer Programming for Actuaries & Data Scientists and advance your computer skills to a level that will make you a hot commodity in the Actuarial Science and Data Science job markets.
REGISTER
