Discover Classes. Earn Rewards.

SQL Level III

Take your SQL skills to the next level with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.

  • Advanced
  • 18 and older
  • $425
  • 185 Madison Ave, New York, NY & Virtually Online

Start Dates (8)

  • $425
  • Career Centers @ 185 Madison Ave Suite 1104, New York, NY 10016
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
Showing 15 of 8

Class Description

Description

What you'll learn in this sql server training:

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 variables, functions, and stored procedures can be used to make SQL code more reusable, flexible, and repeatable.

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.

This course has a 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.

Learn more about SQL Level III at NYC Career Centers.

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 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 NYC Career Centers (680)

(4.5-star rating across 680 reviews)
  • SQL Level III

    Reviewed by Gracie H. on 2/21/2017
    Peter is an amazing instructor. Very clear, well structured
  • SQL Level III

    Reviewed by Daniel T. on 6/2/2016
    Good class, instructor was very informative .
  • SQL Level III

    Anonymous review on 10/21/2015
    Super helpful. Peter is a great teacher and he makes sure nobody falls behind. And we have covered all the material in-depth! Definitely recommend!
  • SQL Level III

    Reviewed by Huijun W. on 12/16/2019
  • SQL Level III

    Reviewed by Wei Z. on 12/29/2018
  • SQL Level III

    Reviewed by Duke P. on 5/20/2018
  • SQL Level III

    Reviewed by Daniel D. on 9/7/2017
  • SQL Level III

    Anonymous review on 9/7/2017
  • SQL Level III

    Reviewed by Nadia Z. on 2/25/2017
  • SQL Level III

    Reviewed by Mike R. on 7/12/2016
  • SQL Level III

    Anonymous review on 6/27/2016
  • SQL Level III

    Anonymous review on 6/5/2016
  • SQL Level III

    Reviewed by Michael I. on 1/15/2016
  • SQL Level III

    Reviewed by Susan W. on 11/17/2015
See reviews for other classes at NYC Career Centers
loading...
Hide Reviews

Review Summary by CourseHorse

Students have much positive feedback about classes at SQL Level III, particularly praising the instructor, Peter. They describe him as amazing, clear, well-structured, informative, helpful, and a great teacher. Students appreciate that Peter ensures nobody falls behind and that the material is covered in-depth. As a result, students feel confident in recommending these classes. Quotes: 1. "Peter is a great teacher and he makes sure nobody falls behind." 2. "Very clear, well structured." 3. "And we have covered all the material in-depth!"

Questions & Answers (3)

Get quick answers from CourseHorse and past students.

Question from Angelica B.
What is the background of the trainer?
Answer from Angelica B. CourseHorse StaffCourseHorse Staff
All of our Instructors are BPSS approved with more than 20 years of Experience.
Answer Show answer
Cancel
Question from Angelica B.
Will the users be using ssms and doing actual queries?
Answer from Angelica B. CourseHorse StaffCourseHorse Staff
Students will be using SQL Server Management Studio 2014, and yes, they are doing actual queries.
Answer Show answer
Cancel
Question from Angelica B.
Are the classes definite? We may have someone travel to NY for one of these classes.
Answer from Angelica B. CourseHorse StaffCourseHorse Staff
We only reschedule or cancel classes in case of emergency and will try to notify students in advance of any potential schedule changes.
Answer Show answer
Cancel

Similar Classes

NYC Career Centers

Since 1988, Career Centers has been a leader in software training courses for individuals and businesses, including Microsoft Excel, VBA, PowerPoint, SQL Server, Adobe Photoshop, InDesign, Illustrator, and AutoCAD.

Our courses are instructor-led in small class sizes, located in our state-of-the-art training...

Read more about NYC Career Centers

CourseHorse Approved

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

NYC Career Centers

NYC Career Centers

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
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

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
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...