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 185 Madison Avenue, NYC In-person classroom training

Corporate training available

Email us for information

Mar 6 Wed, 9am–5pm
Mar 9 Sat, 9am–5pm
Mar 18 Mon, 9am–5pm
Mar 20–21 Wed–Thu, 5:50–9:20pm
Apr 2 Tue, 9am–5pm
Apr 8–9 Mon–Tue, 5:50–9:20pm
Apr 14 Sun, 9am–5pm
Apr 15 Mon, 9am–5pm
May 3 Fri, 9am–5pm
May 8–9 Wed–Thu, 5:50–9:20pm
May 11 Sat, 9am–5pm
May 17 Fri, 9am–5pm
Jun 4 Tue, 9am–5pm
Jun 5–6 Wed–Thu, 5:50–9:20pm
Jun 9 Sun, 9am–5pm
Jun 20 Thu, 9am–5pm
Jul 9 Tue, 9am–5pm
Show more dates

What You'll Learn:

  • 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

Saving Queries Programmatically

1) Benefits versus Shortcomings

2) Views

3) Functions

4) Stored Procedures

5) Layered Views

6) Protect Views with Schema binding

7) Create Top Value Views

Sub Queries

8) What is a Sub Query?

9) Clarity and Transparency

10) Single Table Sub Query

11) Multiple Table Sub Query

12) Exists versus In Operators

13) Any versus All Operator

Math, Advanced Functions and Logic Statements

14) Basic Math

15) Advanced Date and Time Functions

16) Advanced Text Functions

17) Case When Then Logic Statements

18) Variables and User Functions

Data Conversion Functions

19) String Functions

20) Cast Function

21) Convert Function

22) Rounding Functions

Student Labs

23) Creating Views

24) Sub Queries

25) Advanced Functions

26) Logic and Date Functions

27) Conversion 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.