Discover Classes. Earn Rewards.

SQL Level III

Take your SQL skills to new heights with this advanced course. Learn subqueries, views, functions, stored procedures, and more to become proficient in manipulating data in relational databases.

  • Advanced
  • 18 and older
  • $425
  • Interactive Online Classroom

Start Dates (8)

  • $425
  • Interactive Online Classroom
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 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 will learn how to complete complex tasks in Microsoft SQL Server through hands-on projects.

Learn how to employ If-Else logic to queries through CASE statements, use string functions to extract specific text, and retrieve data from anywhere in a database via subqueries. You'll also find out how to query using Views instead of tables when you do not have the required database permissions and become knowledgeable about functions and stored procedures to make your SQL code reusable, adaptable, and reproducible.

Upon completion of this course, you will be better equipped to pursue a career in data analysis, data science, or any other role that requires you to use SQL to manipulate data in relational 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

Course Syllabus

  • Advanced Query Techniques
    • Subqueries
    • Aggregate Window Functions
    • Conditionals with CASE
    • String Functions
    • Self Join
  • Views, Functions, & Stored Procedures
    • Using Views
    • User-Defined Functions with Parameters
    • Executing Stored Procedures

Learn more about SQL Level III at NYIM Training

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

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

NYIM Training

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