Discover Classes. Earn Rewards.

SQL Level 3

Take your SQL skills to the next level with this advanced course at Noble Desktop. Learn how to use subqueries, views, functions, stored procedures, and more to manipulate and analyze data in databases. Gain in-depth techniques that will prepare you for a job in data analysis or data science.

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

Start Dates (6)

  • $425
  • Noble Desktop @ 185 Madison Ave 3rd Floor, New York, NY 10016
20 seats left
Book
20 seats left
Book
20 seats left
Book
Show all 2 sessions
  • Tue, May 28 at 6:00pm - 9:00pm
  • Thu, May 30 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:

Take your SQL skills to the next level in this advanced course. You’ll learn about subqueries, views, functions, stored procedures, and more.

In this advanced SQL course, you’ll learn how to add If-Else logic to queries using CASE statements, and how to use string functions to get just the part of text you need. Subqueries enable you to dynamically grab data from anywhere in a database and use that result in another query.

You (or someone else) may not have the database permissions to query tables directly, so learn how to query using Views instead of tables. Finally, you’ll learn the how to use functions with parameters, and how to execute reusable stored procedures.

By the end of this advanced hands-on course, you’ll know more in-depth SQL techniques that better prepare you for a job in data analysis, data science, or any role requiring you to use SQL to work with data in databases.

Prerequisite:

  • SQL proficiency equivalent to our SQL Level 2 course is required, including JOINs, aggregate functions, GROUP BY and HAVING, as well as working with CAST and date/time.

What You'll Learn at a Glance

  • Use Subqueries to grab data from anywhere in a database and use that result in another query 
  • Query from Views instead of tables 
  • Add If-Else logic to queries using CASE 
  • Learn how to use Functions, and execute reusable Stored Procedures
  • Use String Functions to get just the part of text you need

Learn more about SQL Level 3 at Noble Desktop.


Syllabus

Advanced Query Techniques

Subqueries

  • Subqueries: Queries within queries
  • Single-Value vs Multi-Value vs Table-Value Subqueries

Aggregate Window Functions

  • Using OVER and PARTITION BY to apply Aggregate Functions

Conditionals with CASE

  • Adding If-Else Logic with CASE
  • Simple CASE vs Searched CASE
  • IIF (Inline IF)

String Functions

  • Manipulating text using string functions
  • Using SUBSTRING, LEFT/RIGHT, CHARINDEX, UPPER, etc.
  • Combining with Inline IF statements (IIF)

Self Join

  • How a Self Join is different from other types of joins
  • Using a Self Join

Views, Functions, & Stored Procedures

Using Views

  • What are Views?
  • The Advantages & Disadvantages of using Views
  • How to Use & Query a View

User-Defined Functions with Parameters

  • Using Scalar-Value (Single-Value) Functions
  • Using Table-Value Functions

Executing Stored Procedures

  • The difference between Views, Functions, and Stored Procedures
  • Using Stored Procedures

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

Noble Desktop

Noble Desktop

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

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