SQL Level II

Intermediate SQL Classroom Training

Master views, subqueries, logic statements, and data conversions in SQL Level 2. Combine advanced SQL functions with fundamentals like inner and outer joins to proof your work. Develop your skills in SQL by writing advanced functions to gain more control in your relational DBMS (Database Management System).

  • icon for small classesSmall classes
  • icon for small classesComputer provided
  • icon for small classesBook included
  • icon for small classesFree retake

Register for a Class 

$325 8 Hours PC provided 185 Madison Avenue, NYC In-person classroom training

Corporate training available

Email us for information

Aug 28 Wednesday, 9am–5pm
Aug 28–29 Wed–Thu, 5:50–9:20pm
Sep 7 Saturday, 9am–5pm
Sep 12 Thursday, 9am–5pm
Sep 23–24 Mon–Tue, 5:50–9:20pm
Sep 26 Thursday, 9am–5pm
Sep 29 Sunday, 9:30am–5:30pm
Oct 11 Friday, 9am–5pm
Oct 23 Wednesday, 9am–5pm
Oct 23–24 Wed–Thu, 5:50–9:20pm
Nov 2 Saturday, 9am–5pm
Nov 5 Tuesday, 9am–5pm
Nov 18–19 Mon–Tue, 5:50–9:20pm
Nov 21 Thursday, 9am–5pm
Dec 6 Friday, 9am–5pm
Dec 8 Sunday, 9:30am–5:30pm
Dec 18–19 Wed–Thu, 5:50–9:20pm
Dec 19 Thursday, 9am–5pm
Jan 3 Friday, 9am–5pm
Jan 11 Saturday, 9am–5pm
Show more dates

What You'll Learn:

  • Use outer joins to analyze data
  • Write and save queries to the server
  • Create and edit views
  • Use subqueries as an alternative to inner and outer joins
  • Calculate new data field using math functions
  • Format data for reporting with data conversion techniques

Full Course Syllabus

Download PDF Outline

The Code

1) Self Joins

2) Union Joins

3) Cross Joins

Saving Queries Programmatically

4) Views

5) Functions

6) Stored Procedures

7) Layered Views

8) Create Top Value Views

Sub Queries

9) What is a Sub Query?

10) Clarity and Transparency

11) Single Table Sub Query

12) Multiple Table Sub Query

13) Exists versus In Operators

14) Any versus All Operator

Math, Advanced Functions and Logic Statements

15) Basic Math

16) Advanced Date and Time Functions

17) Advanced Text Functions

18) Case When Then Logic Statements

19) Variables and User Functions

Student Labs

20) Creating Views

21) Sub Queries

22) Advanced Functions

23) Logic and Date Functions

Intermediate SQL Classes New York City

Develop Advanced SQL Functions—Create subqueries and logic statements

SQL Level II dives into the functions and features that make SQL easier to use.  Find rows that meet specific criteria with views and subqueries. Write advanced functions and logic statements with conditions. Manipulate data to facilitate scanning and increase readability of reports.

Like our other SQL courses, SQL Level 2 ends with a project-based lab. Activities completed in SQL Levels 1 and 2 help students retain and build upon skills. Labs in SQL Level II require students to create and edit views, write subqueries and logic and date functions, and more.

At the end of this course, you’ll be able to do the following:

  • Save queries to a server for all users to utilize

  • Create views to restrict data and draw up reports

  • Identify when and how to write subqueries to maximize efficiency

  • Perform count, sum, average and other math functions

  • Use data conversion functions to facilitate scanning

Take Your SQL Skills to the Next Level and Save 15%

Do you want to master all that SQL has to offer? Get the most out of your investment by enrolling in SQL bootcamp. NYIM’s SQL bootcamp delivers comprehensive instruction in beginner, intermediate, and advanced SQL in just three days. Receive 15% off when you enroll now!

In-Depth Course Overview

In SQL Level 2, you’ll learn tools and techniques related to the following commands:

  • Create Views - Create views to review a subset of data, and learn the advantages and restrictions when working with SQL views

  • Subqueries - Learn how to write subqueries and the benefits of using them instead of inner and outer table joins

  • Math Functions and Logic Statements - Calculate basic math functions and write logic statements to find data that meets certain conditions

  • Data Conversion Functions - Use data conversion functions to display numbers as text, round decimals, and format other data types

SQL Level 2 begins with lessons on SQL views. Start by reviewing the benefits and disadvantages of using views. For example, if variables are used in queries, then views won’t work. Next, you’ll jump into subqueries. Although subqueries can produce the same information as inner and outer joins, it can do so more quickly and efficiently.

Following subqueries students will learn how to write commands for basic math functions. Use SQL commands to add, subtract, multiply, and divide fields or calculate sums, averages, and counts. With logic statements, such as “CASE WHEN THEN” statements, you’ll group data into specific categories.

Finally, you’ll learn how to use data conversion functions to manipulate data types and appearance. For example, apply commas, decimals, and dollar signs to numerical data types to make it easier to scan prices in a report. The course ends with a lab, in which you’ll practice using the commands described above.

NYIM’s Advanced SQL Courses in New York City

  • Free course retake within six months

  • Custom training workbook with instructions

  • Small and personalized classes

  • Access to PC computer with SQL Server installed

NYIM offers the most practical, affordable SQL Server courses in NYC. NYIM's advanced SQL course will teach you how to harness the full power of DBMS (Database Management Systems).  Our live, in-person SQL classes are instructor-led with custom training materials and comprehensive review exercises each session.