# SQL Level 3 Course

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

## Overview

In this advanced SQL class, you’ll learn to add If-Else logic to your queries with CASE statements and use string functions to extract exactly the text you need. You’ll also work with subqueries, which let you dynamically pull data from anywhere in a database and use that result in another query.

If you (or others) don’t have permissions to query tables directly, you’ll discover how to query using Views instead. You’ll also learn to use functions with parameters and how to run reusable stored procedures.

By the end of this advanced, hands-on course, you’ll have mastered deeper SQL techniques that will better prepare you for work in data analysis, data science, or any position that requires SQL to manage and analyze data in databases.

## What you'll learn

- Write subqueries to create layered queries using single-value, multi-value, and table-value structures
- Use window functions with OVER and PARTITION BY to apply aggregate logic across rows without grouping
- Implement conditional logic with CASE and IIF statements to dynamically transform query results
- Manipulate text data using string functions like SUBSTRING, CHARINDEX, UPPER, and more
- Apply self-joins to compare records within the same table and understand their unique structure and use cases
- Build and query views, user-defined functions, and stored procedures to modularize your SQL code

## Prerequisites

SQL proficiency equivalent to our [SQL Level 2](/courses/sql-level-2) course is required, including JOINs, aggregate functions, GROUP BY and HAVING, as well as working with CAST and date/time.

## Curriculum

### Advanced Query Techniques

#### Subqueries

- Subqueries: Queries within queries
- Single-Value vs Multi-Value vs Table-Value Subqueries

#### Aggregate Window Functions

- Using OVER and PARTITION BY to apply Aggregate Functions

#### Conditionals with CASE

- Adding If-Else Logic with CASE
- Simple CASE vs Searched CASE
- IIF (Inline IF)

#### String Functions

- Manipulating text using string functions
- Using SUBSTRING, LEFT/RIGHT, CHARINDEX, UPPER, etc.
- Combining with Inline IF statements (IIF)

#### Self Join

- How a Self Join is different from other types of joins
- Using a Self Join

### Views, Functions, & Stored Procedures

#### Using Views

- What are Views?
- The Advantages & Disadvantages of using Views
- How to Use & Query a View

#### User-Defined Functions with Parameters

- Using Scalar-Value (Single-Value) Functions
- Using Table-Value Functions

#### Executing Stored Procedures

- The difference between Views, Functions, and Stored Procedures
- Using Stored Procedures

## Schedule
- Jun 12, 2026 10:00am–5:00pm — Live Online
- Jul 29, 2026 10:00am–5:00pm — Live Online
- Sep 24, 2026 10:00am–5:00pm — Live Online

## Pricing

**Tuition:** $425