Discover Classes. Earn Rewards.

SQL Level II

Enhance your SQL skills by learning advanced techniques such as Outer Joins, NULL data analysis, grouping data with aggregate functions, date/time manipulation, and more. Take your data analysis to the next level with this intermediate SQL course.

  • Level Intermediate
  • Age 18 and older
  • Price $350
  • Location 185 Madison Ave, New York, NY

Start Dates (5)

  • $350
  • NYIM @ 185 Madison Ave 3rd Floor, New York, NY 10016
20 seats left
Book
20 seats left
Book
Show all 2 sessions
  • Tue, May 21 at 6:00pm - 9:00pm
  • Thu, May 23 at 6:00pm - 9:00pm
20 seats left
Book
20 seats left
Book
20 seats left
Book
Save to WishList Purchase a Gift Card

Class Description

Description

What you'll learn in this sql class:

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 Level 2 at NYIM Training


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

Refund Policy

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
  • Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYIM Training (742)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

NYIM Training

For nearly two decades, NYIM has trained thousands of business professionals in the latest computer software programs, including Excel, Financial Modeling, Microsoft Office, Adobe, SQL, AutoCAD, QuickBooks, and many more.

The company is known for its practical and hands-on approach to its instructor-led...

Read more about NYIM Training

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

NYIM Training

NYIM Training

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Choose from thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...