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

SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience.

When you arrive at The Career Center you are given a Course Manual, that is yours to keep, and then shown to your seat with a computer that is fully equipped with SQL.The instructor computer is attached to an overhead projector so you can easily follow their instructions. The class is taught in a very hands-on way, with the instructor teaching a concept and then the class doing exercises to enforce it. The maximum class size is 10 so you don't have to worry about getting lost in the crowd!

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