Intermediate SQL Course NYC - Learn Database Management with SQL

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

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.

This course has a prerequisite

SQL proficiency equivalent to our SQL Level 1 course is required, including basic querying, filtering, and aggregation.

Learn the Skills Guarantee™

Hands-on, personalized training

Learn with real-world projects
Cutting edge curriculum

Step-by-step instruction to boost retention
Learn from industry experts

Gain industry knowledge from professionals
Free retake

Retake the course for free within one year

Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.

The Career Centers instructors are highly skilled communicators who really know their craft. They are wonderful about explaining and re-explaining when necessary and I never felt rushed or foolish for asking a question.
—Diane Speros

What You’ll Learn

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

Course Syllabus

Download Syllabus PDF

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

Schedule & Enrollment: SQL Level II

$325
8 Hours
NYC or Live Online
Free retake
Setup assistance
Expert instructors
Small classes

Policies

Course times are listed in Eastern Time.

Filter

October 7

Thursday 9:30–5:15pm

Live Online Only
Enroll
October 11–12

Monday to Tuesday 6–9:20pm

Enroll
November 9

Tuesday 9:30–5:15pm

Enroll
November 13

Saturday 9:30–5:15pm

Enroll

This Course is Available in NYC or Live Online

On Campus in NYC

185 Madison Avenue, NYC

In-person training happens at our campus in NYC where you’ll get face-to-face interaction with instructors and direct collaboration with other students. Courses are hands-on with all the necessary computers and software provided to you in class.

Classes are interactive and led by an experienced instructor who is in the classroom with you.
Each attendee will be set up on a computer (your choice of Mac or PC) with all the necessary software.
Retake the course for free (in-person or live online) within one year.

Live Online

Live online training happens through Zoom during the same time as the in-person class and gets you the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.

Classes are activity-based and taught in real-time by an experienced instructor.
You can hear the instruction, ask questions, and share your screen—all in real-time.
Retake the course for free (in-person or live online) within one year.

Online Training Demo

1-Minute Overview

Testimonials for Live Online Training

“Overall experience on Zoom was maybe even better than in IRL classroom because the instruction takes place right on your own screen, with less distraction. Great overall experience.”
“Given the fact that we had to do this entire class remotely due to Covid-19, I didn’t have very high expectations it would run so smoothly. However, I don’t think it could’ve gone any better. Not only do I feel very comfortable with the program now, but I’m actually excited to use it!”
“This was the first online class I’ve taken with ND and it was a great experience. Looking forward to the other classes I’ve signed up for!”

More about live online training

Frequently Asked Questions

Does this course require any prior knowledge or experience?

SQL proficiency equivalent to our SQL Level 1 course is required, including basic querying, filtering, and aggregation.
Do you offer any discounts for this course?
Discounts

We don’t currently offer discounts as we do our best to affordably prices our courses.

Take this course as part of a certificate program and save:
- SQL Bootcamp
  
  Price: $915 | Hours: 24 Hours
- Data Analytics Bootcamp
  
  Price: $1,949 | Hours: 60 Hours
- Business Analyst Certificate
  
  Price: $1,995 | Hours: 65 Hours
Are there any additional fees or expenses?

There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.

However, if you plan to take the course live online, you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost.
Do you offer payment plans or student financing for this course?

This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
Can I take this course online (remote learning)?
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).

How does attending “live online” work?
- Students can attend this training remotely through screen sharing software (we use Zoom).
- Participants can hear the instruction, ask questions, and even share their screen with the instructor.
- For audio you can use your computer’s microphone/speakers or call a phone number that we’ll provide.
- Classes are activity-based and taught by a live instructor, so we strongly encourage students who are local to the area to attend in person!
- You will need your own computer and copy of any required software. If you don’t have the software, you can usually do a free trial or purchase your own license. If you need assistance, contact us at nyc@careercenters.com

Why Learn at Career Centers

Highly Reviewed by Our Alumni

From our hands-on training style to world-class instructors and proprietary curriculum, we deliver a learning experience our alumni can be proud of.

4 Students Rated Our SQL Level II 5 Stars

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.

Reinforced what I already new and learned many new skills and capabilities of SQL!

sakia anwar, Healthfirst

This class is great! It teaches you everything you ever wanted to know about SQL queries and more!!

Matthew Weaver, Standard Motor Products

Great class with good examples and resources to follow along.

Nehreen Chowdhury, AmTrust Financial

Practical SQL Courses

SQL Bootcamp

Class Notes

This course has a prerequisite

Learn the Skills Guarantee™

Hands-on, personalized training

Cutting edge curriculum

Learn from industry experts

Free retake

Earn a Certificate of Completion

What You’ll Learn

Course Syllabus

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

Schedule & Enrollment: SQL Level II

October 7 Thursday 9:30–5:15pm Live Online Only Enroll

October 11–12 Monday to Tuesday 6–9:20pm Enroll

November 9 Tuesday 9:30–5:15pm Enroll

November 13 Saturday 9:30–5:15pm Enroll

October 7 Thursday 9:30–5:15pm Live Online Only Enroll

November 9 Tuesday 9:30–5:15pm Enroll

October 11–12 Monday to Tuesday 6–9:20pm Enroll

November 13 Saturday 9:30–5:15pm Enroll

This Course is Available in NYC or Live Online

On Campus in NYC

Live Online

Online Training Demo

Testimonials for Live Online Training

Frequently Asked Questions

Does this course require any prior knowledge or experience?

Do you offer any discounts for this course?

Discounts

Take this course as part of a certificate program and save:

Are there any additional fees or expenses?

Do you offer payment plans or student financing for this course?

Can I take this course online (remote learning)?

How does attending “live online” work?

Looking for corporate training?

Why Learn at Career Centers

Highly Reviewed by Our Alumni

4 Students Rated Our SQL Level II 5 Stars

Compare SQL Level II to Similar Courses

SQL Bootcamp

SQL Level I

SQL Level III

PostgreSQL Bootcamp

October 7

Thursday 9:30–5:15pm

Live Online Only
Enroll

October 11–12

Monday to Tuesday 6–9:20pm

Enroll

November 9

Tuesday 9:30–5:15pm

Enroll

November 13

Saturday 9:30–5:15pm

Enroll

October 7

Thursday 9:30–5:15pm

Live Online Only
Enroll

November 9

Tuesday 9:30–5:15pm

Enroll

October 11–12

Monday to Tuesday 6–9:20pm

Enroll

November 13

Saturday 9:30–5:15pm

Enroll