Compare Classes & Certificates

Which course is right for you? This tool allows you to compare any class or certificate program in our catalogue with the important information you need to make the right decision.

Remove
Key Information
SQL Level 2 Course Online
$350 6 Hours
Learn More
Download Syllabus
Overview
Enhance your SQL skills by learning how to join, filter, group, and analyze data in this intermediate course. Discover techniques for outer joins, manipulating data types, working with dates and times, grouping data, and filtering grouped data. Gain the ability to extract and analyze specific data for actionable insights.
Prerequisite
SQL proficiency equivalent to our SQL Level 1 course is required, including basic querying, fundamentals of filtering (WHERE, LIKE, BETWEEN), and inner JOINs.
Location
Live Online or Live Online
Schedule
Next start date: January 20 & 22, Tuesday & Thursday, 6–9pm
Other scheduling options Evenings or weekdays
View full schedule
Certification
Software Included
Free Retake Within 1 Year See our class policies for more details
Workbook Included
Financing See our Climb Credit FAQ for more details
Target Audience
Anyone
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

Add Class or Certificate to Compare