Discover Classes. Earn Rewards.

SQL Level 2

Enhance your SQL skills by mastering Outer Joins, NULL data, grouping, aggregate functions, filtering, and working with dates/times. Extract and analyze specific data from databases, turning raw information into valuable insights. Prerequisite: SQL proficiency equivalent to Noble Desktop's SQL Level 1 course.

  • Level Intermediate
  • Age 18 and older
  • Price $350
  • Location Interactive Online Classroom

Start Dates (5)

  • $350
  • Interactive Online Classroom
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

Learn more about SQL Level 2 at Noble Desktop.


Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Also available in-person in NYC

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 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]"

Reviews of Classes at Noble Desktop (371)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

Noble Desktop

Noble Desktop is a renowned educational institution that specializes in providing comprehensive training in various creative and technology-related fields. Established in 1990 and headquartered in New York City, Noble Desktop has earned a stellar reputation for its high-quality courses and innovative...

Read more about Noble Desktop

CourseHorse Approved

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

Noble Desktop

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...