# SQL Level 2 Course

Canonical URL: <https://www.graduateschool.edu/courses/sql-level-2>

## Overview

In this intermediate SQL course, you’ll expand on your understanding of SQL fundamentals, sharpening your ability to join, filter, group, and analyze data. Learn to use outer joins and identify NULL data.

You’ll also discover how to group data and run common statistical calculations with aggregate functions. Working with data often requires changing the data type when it’s not in the format you need (using CAST), as well as handling and formatting date and time values.

By the end of this hands-on intermediate course, you’ll have mastered additional SQL techniques to extract and analyze the exact data you need, making it easier to turn raw data into actionable insights.

## What you'll learn

- Compare INNER and OUTER JOIN types and use LEFT, RIGHT, and FULL JOINs to combine data across tables
- Identify and work with NULL values to ensure complete and accurate data analysis
- Use the CAST function to convert data types and make your queries more flexible
- Perform calculations with aggregate functions like SUM, COUNT, AVG, MAX, and MIN to summarize data
- Apply date functions to extract, format, and compare dates for time-based analysis
- Group results using GROUP BY and filter grouped data using the HAVING clause for advanced segmentation

## Prerequisites

SQL proficiency equivalent to our [SQL Level 1](/courses/sql-level-1) course is required, including basic querying, fundamentals of filtering (WHERE, LIKE, BETWEEN), and inner JOINs.

## Curriculum

### Inner vs Outer JOIN

#### Outer Joins & Finding NULLs

- Left Join
- Right Join
- Full Join
- Find NULL values

### Manipulating, Aggregating, & Filtering Data

#### Using CAST to Change Data Types

- Why and how to use CAST to make a data type fit your query’s needs

#### Aggregate Functions

- Using Aggregate Functions to perform common statistical calculations
- Using SUM, COUNT, AVG, MAX & MIN

#### Working with Dates & Time

- Date Functions: Getting the desired part of a date/time (Year, Month, Day, etc.)
- Formatting dates, including the day of the week (Sunday, Monday, etc.)
- Calculating the difference between 2 dates

### Grouping Data & Filtering Grouped Data

#### Grouping Data with Aggregate Functions

- Using GROUP BY to organize results into categories
- Applying Aggregate Functions to groups

#### Filtering Grouped Data with HAVING

- Using HAVING to filter the results of a GROUP BY
- HAVING vs WHERE

## Schedule
- Jun 11, 2026 10:00am–5:00pm — Live Online
- Jul 28, 2026 10:00am–5:00pm — Live Online
- Sep 23, 2026 10:00am–5:00pm — Live Online

## Pricing

**Tuition:** $350