SQL Level 3
via Noble Desktop
Affiliated with Course Report
Build more involved queries in Noble Desktop's SQL Level 3 course. The curriculum extends earlier SQL work into techniques such as subqueries, conditional logic, and database programming features. You practice organizing complex retrieval and analysis tasks, using the relationships among query steps to produce useful results.
What's included with live classes
- Free course retake within one year to refresh the material and gain practice.
- Class recordings
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.
Who this course is for
This course is designed for students who have completed SQL Level II (or have equivalent intermediate SQL experience) and want to deepen their skills with advanced queries and data analysis.
Prerequisites
SQL proficiency equivalent to our SQL Level 2 course is required, including JOINs, aggregate functions, GROUP BY and HAVING, as well as working with CAST and date/time.
Topics included
Schedule & enrollment
Find dates that fit your schedule, then book on Noble Desktop.
- Live tuition
- $425
- Course length
- 6 hours
All class times are Eastern (ET).
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
Live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
Confirm current dates and availability on Noble Desktop before booking. Enrollment opens in a new tab.
Self-paced tuition & enrollment
Learn through recorded lessons on your own schedule.
- Tuition
- $425
- Course length
- 6 hours
- Format
- Self-paced online
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
Loading enrollment options…
Prefer to enroll directly? Open the course website.
Curriculum
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
Course syllabus
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
Self-paced course
Learn through recorded lessons on your own schedule.
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
View self-paced tuition & enrollmentIn this advanced SQL course, you’ll learn to enhance your queries with conditional logic using CASE statements and apply string functions to extract and format text with precision. You’ll also explore subqueries to dynamically retrieve and reuse data across different parts of a database.
Additionally, you’ll work with Views to query data when direct table access isn’t available, learn to use parameterized functions, and execute reusable stored procedures. By the end of this hands-on course, you’ll have mastered advanced SQL techniques and gained the expertise needed for roles in data analysis, data science, or any position involving database management and optimization.
Self-paced prerequisites
SQL proficiency equivalent to our SQL Level 2 course is required, including JOINs, aggregate functions, GROUP BY and HAVING, as well as working with CAST and date/time.
Self-paced curriculum
What you'll learn self-paced
- 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 structure and use cases
- Build and query views, user-defined functions, and stored procedures to modularize your SQL code
Self-paced syllabus
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
Course Reviews
Is this course right for you?
You should know joins, aggregate functions, grouping, and date operations before enrolling. Compare SQL Level 2 if you need that preparation before progressing to the more involved query techniques and database features at this level.