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

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

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