SQL Level 2
via Noble Desktop
Affiliated with Course Report
Develop more capable database queries in Noble Desktop's SQL Level 2 course. The curriculum covers joins, aggregate functions, grouping, data types, and date operations. You practice combining records and summarizing information so that a query can answer questions that span multiple tables or require calculated 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 intermediate SQL course, you’ll build on your knowledge of SQL fundamentals, enhancing your skills to join, filter, group, and analyze data.
You’ll learn how to use outer joins and find NULL data. You'll learn how to group data and perform common statistical calculations using aggregate functions. Working with data requires the ability to change the data type when it’s not what you need (using CAST), and to be able to work with and format date and time information.
By the end of this intermediate hands-on course, you’ll know more SQL techniques to extract and analyze the specific data you want from the database. This will enable you to more easily turn raw data into actionable insights.
Prerequisites
SQL proficiency equivalent to our SQL Level 1 course is required, including basic querying, fundamentals of filtering (WHERE, LIKE, BETWEEN), and inner JOINs.
Topics included
Schedule & enrollment
Find dates that fit your schedule, then book on Noble Desktop.
- Live tuition
- $350
- 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
- $350
- 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
- Compare INNER and OUTER JOIN types and use LEFT, RIGHT, and FULL JOINs to combine data across tables
- Identify and work with NULL values to ensure complete and accurate data analysis
- Use the CAST function to convert data types and make your queries more flexible
- Perform calculations with aggregate functions like SUM, COUNT, AVG, MAX, and MIN to summarize data
- Apply date functions to extract, format, and compare dates for time-based analysis
- Group results using GROUP BY and filter grouped data using the HAVING clause for advanced segmentation
Course syllabus
Inner vs Outer JOIN
Outer Joins & Finding NULLs
- Left Join
- Right Join
- Full Join
- Find NULL values
Manipulating, Aggregating, & Filtering Data
Using CAST to Change Data Types
- Why and how to use CAST to make a data type fit your query’s needs
Aggregate Functions
- Using Aggregate Functions to perform common statistical calculations
- Using SUM, COUNT, AVG, MAX & MIN
Working with Dates & Time
- Date Functions: Getting the desired part of a date/time (Year, Month, Day, etc.)
- Formatting dates, including the day of the week (Sunday, Monday, etc.)
- Calculating the difference between 2 dates
Grouping Data & Filtering Grouped Data
Grouping Data with Aggregate Functions
- Using GROUP BY to organize results into categories
- Applying Aggregate Functions to groups
Filtering Grouped Data with HAVING
- Using HAVING to filter the results of a GROUP BY
- HAVING vs WHERE
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 self-paced intermediate SQL course, you’ll deepen your understanding of relational databases by learning to join, filter, group, and analyze data. You’ll explore outer joins, manage NULL values for more accurate results, and use the CAST function to convert data types for flexible, reliable queries.
You’ll also learn to group data and perform common statistical calculations using aggregate functions such as SUM, COUNT, and AVG. By the end of the course, you’ll have the skills to extract, organize, and manipulate data efficiently, turning raw information into meaningful insights.
Self-paced curriculum
What you'll learn self-paced
- Compare INNER and OUTER JOIN types and use LEFT, RIGHT, and FULL JOINs to combine data across tables
- Identify and work with NULL values to ensure complete and accurate data analysis
- Use the CAST function to convert data types and make your queries more flexible
- Perform calculations with aggregate functions like SUM, COUNT, AVG, MAX, and MIN to summarize data
- Apply date functions to extract, format, and compare dates for time-based analysis
- Group results using GROUP BY and filter grouped data using the HAVING clause for advanced segmentation
Self-paced syllabus
Inner vs Outer JOIN
Outer Joins & Finding NULLs
- Left Join
- Right Join
- Full Join
- Find NULL values
Manipulating, Aggregating, & Filtering Data
Using CAST to Change Data Types
- Why and how to use CAST to make a data type fit your query’s needs
Aggregate Functions
- Using Aggregate Functions to perform common statistical calculations
- Using SUM, COUNT, AVG, MAX & MIN
Working with Dates & Time
- Date Functions: Getting the desired part of a date/time (Year, Month, Day, etc.)
- Formatting dates, including the day of the week (Sunday, Monday, etc.)
- Calculating the difference between 2 dates
Grouping Data & Filtering Grouped Data
Grouping Data with Aggregate Functions
- Using GROUP BY to organize results into categories
- Applying Aggregate Functions to groups
Filtering Grouped Data with HAVING
- Using HAVING to filter the results of a GROUP BY
- HAVING vs WHERE
Course Reviews
Is this course right for you?
Basic SQL querying, filtering, and inner joins are required. Choose this course after introductory SQL. Compare the SQL Bootcamp if you want foundational and more advanced querying material together in one structured course sequence.