# SQL Level 3

Canonical URL: <https://www.nobledesktop.com/classes/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 how to use functions with parameters and how to execute reusable stored procedures.

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

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

## Instructors

### Dan Rodney — School Director, Instructor, & Senior Course Developer

Dan Rodney has been a designer and web developer for over 20 years, creating coursework and leading innovative training initiatives at Noble Desktop. He teaches courses covering Figma, HTML & CSS, Adobe Photoshop, InDesign, Illustrator, and Power BI. Dan has also been at the forefront of integrating AI into design and business workflows, spearheading Noble Desktop’s latest AI course offerings. In addition to teaching and curriculum development, he writes custom scripts for InDesign (Make Book Jacket, Proper Fraction Pro, and more) and works with automation and AI-driven tools in his free time. You can find Dan on X (Twitter), LinkedIn, Facebook, and at danrodney.com.

Learn more about [Dan Rodney's](/dan-rodney) background and expertise.

### Garfield Stinvil — Senior Instructor

Garfield is an experienced software trainer with over 16 years of real-world professional experience. He started as a data analyst with a Wall Street real estate investment company & continued working in the professional development department at New York Road Runners Organization before working at Noble. He enjoys bringing humor to whatever he teaches and loves conveying ideas in novel ways that help others learn more efficiently.

Since starting his professional training career in 2016, he has worked with several corporate clients including Adobe, HBO, Amazon, Yelp, Mitsubishi, WeWork, Michael Kors, Christian Dior, and Hermès. 

Outside of work, his hobbies include rescuing & archiving at-risk artistic online media using his database management skills.

## Pricing

**Tuition:** $425