# SQL Level III

Canonical URL: <https://www.careercenters.com/courses/sql-level-3>

## Overview

In this advanced SQL course, you’ll learn how to add If-Else logic to queries using CASE statements, and how to use string functions to get just the part of text you need. Subqueries enable you to dynamically grab data from anywhere in a database and use that result in another query.

You (or someone else) may not have the database permissions to query tables directly, so learn how to query using Views instead of tables. Finally, you’ll learn the how variables, functions, and stored procedures can be used to make SQL code more reusable, flexible, and repeatable.

By the end of this advanced hands-on course, you’ll know more in-depth SQL techniques that better prepare you for a job in data analysis, data science, or any role requiring you to use SQL to work with data in databases.

## What you'll learn

- Use Subqueries to grab data from anywhere in a database and use that result in another query
- Query from Views instead of tables
- Add If-Else logic to queries using CASE
- Learn how to use Functions, and execute reusable Stored Procedures  
- Use String Functions to get just the part of text you need

## 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
- Jul 29, 2026 10:00am–5:00pm — NYC
- Sep 24, 2026 10:00am–5:00pm — NYC
- Nov 4, 2026 10:00am–5:00pm — NYC

## Pricing

**Tuition:** $425