Advanced SQL Training NYC - Learn Database Management with SQL

Become a master of all things SQL in SQL Level 3. Export data to external applications, like Access and Excel, automate workflow with triggers, and protect live data by using temporary tables. At the end of the course, you’ll have the option to explore data conversion functions and Schema binding.

Advanced SQL Classes in Midtown NYC

At the start of the course, you’ll receive a personal course workbook where you can add personal notes and tips to help you remember each exercise. After the course, use the workbook as a reference manual. Bring it with you on the job to review SQL concepts anytime you face a challenge.

NYC's Top SQL Bootcamp in Manhattan

Need a refresher before jumping into SQL Level 3? Sign up for SQL Bootcamp and receive a 15% discount on SQL Level 1, SQL Level 2, and SQL Level 3. Take our intensive bootcamp scheduled over three consecutive days or spread the course over a few weekends.

Students can take the course a second time within 6 months absolutely free of charge.

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 2 course is required, including outer joins, subqueries, and logic statements.

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

Create Databases and Tables
Insert, update and delete data through importing and coding techniques
Export data to other applications
Create constraints, indexes and referential integrity
Create database diagrams

Course Syllabus

Download Syllabus PDF

Importing and Exporting Data

1) Creating a Database and Tables in SQL

2) Importing and Exporting Data from and to Excel

3) Importing and Exporting Data from and to Access

4) Importing, Updating and Deleting Data via Code

Building Control Structures

5) Creating Primary Keys, Indexes and Constraints

6) Setting up Referential Integrity

7) Creating Database Diagrams

Optional

Protect Views with Schema binding

Data Conversion Functions

String Functions
Cast Function
Convert Function
Rounding Functions

Temporary Tables

Low Level Security Overview
Local Temp Tables
Global Temp Tables

Stored Procedures

Parameter Queries using Variables through Views
Automation of Workflow Processes
Triggers to Create Workflow Events

Schedule & Enrollment: SQL Level III

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

Policies

Course times are listed in Eastern Time.

Filter

August 27

Friday 9:30–5:15pm

Enroll
August 29

Sunday 9:30–5:15pm

Enroll
October 8

Friday 9:30–5:15pm

Enroll
October 18–19

Monday to Tuesday 6–9:20pm

Enroll
November 11

Thursday 9:30–5:15pm

Enroll
November 20

Saturday 9:30–5:15pm

Enroll

This Course is Available Live Online

You can attend this training live online at the scheduled time the course is offered (New York, Eastern Time) through screen-sharing software Zoom (free for you).
Our live online training is interactive and hands-on, just like our in-person classes. There are no extra fees and we’ll work with you to ensure your setup is perfect

Classes are activity-based and taught by a live 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.

See What Students Are Saying About Live Online

“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!”

Learn more about how our live online training works

Online Training Demo

1-Minute Overview

Frequently Asked Questions

Does this course require any prior knowledge or experience?

SQL proficiency equivalent to our SQL Level 2 course is required, including outer joins, subqueries, and logic statements.
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
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.

1 Student Rated Our SQL Level III 5 Stars

Great class learned a lot about sql via the bootcamp

Adam Harari

Advanced SQL Classes in Midtown NYC

NYC's Top SQL Bootcamp in Manhattan

Class Notes

This course has a prerequisite

Learn the Skills Guarantee™

Hands-on, personalized training

Cutting edge curriculum

Learn from industry experts

Free retake

What You’ll Learn

Course Syllabus

Importing and Exporting Data

1) Creating a Database and Tables in SQL

2) Importing and Exporting Data from and to Excel

3) Importing and Exporting Data from and to Access

4) Importing, Updating and Deleting Data via Code

Building Control Structures

5) Creating Primary Keys, Indexes and Constraints

6) Setting up Referential Integrity

7) Creating Database Diagrams

Optional

Protect Views with Schema binding

Data Conversion Functions

Temporary Tables

Stored Procedures

Schedule & Enrollment: SQL Level III

August 27 Friday 9:30–5:15pm Enroll

August 29 Sunday 9:30–5:15pm Enroll

October 8 Friday 9:30–5:15pm Enroll

October 18–19 Monday to Tuesday 6–9:20pm Enroll

November 11 Thursday 9:30–5:15pm Enroll

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

August 27 Friday 9:30–5:15pm Enroll

October 8 Friday 9:30–5:15pm Enroll

November 11 Thursday 9:30–5:15pm Enroll

October 18–19 Monday to Tuesday 6–9:20pm Enroll

August 29 Sunday 9:30–5:15pm Enroll

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

This Course is Available Live Online

See What Students Are Saying About Live Online

Online Training Demo

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:

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

1 Student Rated Our SQL Level III 5 Stars

Compare SQL Level III to Similar Courses

SQL Bootcamp

SQL Level I

SQL Level II

PostgreSQL Bootcamp

August 27

Friday 9:30–5:15pm

Enroll

August 29

Sunday 9:30–5:15pm

Enroll

October 8

Friday 9:30–5:15pm

Enroll

October 18–19

Monday to Tuesday 6–9:20pm

Enroll

November 11

Thursday 9:30–5:15pm

Enroll

November 20

Saturday 9:30–5:15pm

Enroll