SQL Level 2

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

• Students may cancel up to 14 days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price). 
• Cancellations within 14 days are not permitted, but students may reschedule up to three business days before the class start date.
• For cancellations and reschedules, please email us at [email protected]

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.