SQL Level 3
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Book directly on nobledesktop.com. Opens in a new tab.
Book live on Noble DesktopSummary
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.
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
What's included
- Free course retake within one year to refresh the material and gain practice.
- Class recordings
Stated by the provider. Confirm what your tuition covers before enrolling.
Live classes
Choose dates and book your instructor-led class on nobledesktop.com.
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
Confirm current dates and availability on Noble Desktop before booking.
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.
- Tuition
- $425
- Course length
- 6 hours
- Schedule
- On your schedule
In 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