SQL Level II

Intermediate SQL Courses in NYC

  • tag-solid $325
  • clock-solid 8 Hours
  • display-solid PC provided help-solid
  • users-solid Small in-person class
  • repeat-line Free retake help-solid
  • map-marker-solid 185 Madison Avenue, NYC
All SQL Courses SQL Level II

Discover views, functions, and subqueries in SQL Level 2. You’ll begin by reviewing SQL queries related to joins. Next, you’ll dive into the core of SQL—views, functions, stored procedures, subqueries, math, functions, and logic statements. The course concludes with a lab session to practice your skills.

Practical SQL Courses in New York City

At the start of the class, you’ll receive our proprietary SQL course manual that you can keep after the course for reference. During the course, your instructor will explain concepts, show examples, and provide time to complete practice activities in the workbook. Our class sizes cap at 10, so you’ll be able to ask questions during the class.

SQL Bootcamp

Do you want to become a SQL expert? Get 15% off the SQL Bootcamp, which bundles SQL Level 1, SQL Level 2, and SQL Level 3 into three consecutive days of training. Choose from consecutive three-day classes offered on weekdays, or take the course over several weekends. 

Get a free retake of the course within 6 months. 

Class Notes

  • SQL can be used with a variety of programs. This course uses Microsoft SQL Server.
  • Prerequisites: SQL Level 1 or basic knowledge of SQL queries
     

Upcoming Class Dates

Corporate training classroom
Career Centers teacher helping a student

Looking for corporate training?

We offer custom onsite training and discounted class vouchers.

envelope-solid nyc@careercenters.com
phone-handset-solid 212 • 684 • 5151
file-group-solid Download Syllabus

Course Overview

  • Code subqueries to generate query output
  • Create views, manipulate data through views, modify the view structure, and drop views
  • Use date functions, text parsing, concatenation and formatting functions
  • Create logic statements, variables and user functions
  • Use conversion functions to make outputs more user friendly
block-quote-line

I would sign up for any programming class through these services. They are informative and easy to understand which sends me on my way with real world skills.

Matthew Breitner, MediaRadar, Inc.

circle-arrow-solid circle-arrow-solid

Full Course Syllabus

file-group-solid Download PDF Outline

The Code

1) Self Joins

2) Union Joins

3) Cross Joins

Saving Queries Programmatically

4) Views

5) Functions

6) Layered Views

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

Student Labs

19) Creating Views

20) Sub Queries

21) Advanced Functions

22) Logic and Date Functions