Expand your SQL skills by learning how to use Outer Joins, find NULL data, group data with aggregate functions, filter groups with HAVING, work with dates/time, and more.
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. 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.
Prerequisite:
SQL proficiency equivalent to our SQL Level 1 course is required, including basic querying, fundamentals of filtering (WHERE, LIKE, and wildcards), and inner JOINs.
What You’ll Learn at a Glance
- Learn to use Outer Joins and find NULL data
- Group data and perform common statistical calculations using Aggregate Functions
- Filter grouped data with HAVING
- Use CAST to make a data type fit your query’s needs
- Work with dates and time
Course Syllabus
- Inner vs Outer JOIN
- Outer Joins & Finding NULLs
- Manipulating, Aggregating, & Filtering Data
- Using CAST to Change Data Types
- Aggregate Functions
- Working with Dates & Time
- Grouping Data & Filtering Grouped Data
- Grouping Data with Aggregate Functions
- Filtering Grouped Data with HAVING
Develop Advanced SQL Functions—Create subqueries and logic statements
SQL Level 2 dives into the functions and features that make SQL easier to use. Learn how to group and filter data, start working with dates and times, and more.
Like our other SQL courses, SQL Level 2 is a project-based, hands-on class. Activities completed in SQL Level 2 help students retain and build upon skills.
At the end of this course, you’ll be able to do the following:
- Group data and perform common statistical calculations using Aggregate Functions
- Filter grouped data with HAVING
- Use CAST to make a data type fit your query’s needs
- Work with dates and time
- Advanced Joins such as Self Join and Union
Learn more about SQL Server Level II at NYIM Training.
