SQL Classes NYC - Beginner to Advanced SQL Training Courses

This SQL starter course will provide you with strong foundational skills to explore the tables, columns, and rows stored in a database and write/code SQL queries to extract and start analyzing that data. Using practical, hands-on exercises, our expert instructor will guide you through understanding the basics of database architecture and will develop your skills in writing real SQL code.

You’ll learn how to write SELECT statements to choose the specific columns you want from tables, start filtering the results using WHERE, AND/OR, IN, and NOT. You’ll learn how to use wildcard filters as well as mathematical comparisons like equals, greater than, less than, etc. to retrieve only the data you want. Finally, you’ll combine data from multiple tables with inner JOINs.

By the end of this introductory hands-on course, you’ll be able to write basic SQL queries for Microsoft SQL Server. You’ll learn how to use the free SQL Server Management Studio app to explore the database and execute your SQL queries. The concepts you’ll learn on SQL Server can be applied to other flavors of SQL (such as Microsoft Access, PostgreSQL, MySQL, etc.) with minor syntax differences.

Highly Reviewed by Our Alumni

From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.

SQL Level I is rated 4.7 stars by 395 students

in the past 24 months

Great instructor who was excited about the material and taught in a way that was engaging and interesting. I really enjoyed the examples provided to show how you can apply these SQL queries to workplace situations.

Molly P.

I've tried to learn SQL from courses, in books, and in asynchronous online courses. However, it was only after listening to this instructor that the material made sense. This has been helpful for me in my employment already.

Belinda Brewster-Clemence

Highly recommend introduction to SQL course. I thought it was well-paced, and Dan Rodney was well-spoken, easy to understand, and helpful!

Hai Ngo

The SQL I class was thorough, enjoyable, and made learning SQL easy! Will definitely continue the SQL courses and come back for Python. Great teachers and classrooms.

Brianna Schechter
Compass

Course covers useful concepts that you can use in a work environment. Beautiful, well-equipped facilities, nice instructors, and they also provide snacks which I was not expecting at all.

Julia Freiman
Healthfirst

I hope this is the beginning of my new career!

Adriana Nunez

The SQL class I took prepared me well for career growth.

Cheyenne Jasienski
Tableau Software

The class was uniquely helpful in pointing out applications of the material we covered in the real world. Clearly experienced instructor.

Sankalp Gosain
Hubble

I would recommend this class to anyone at any level

Kyle Eng
Memorial Sloan Kettering Cancer Center

The course exceeded my expectations! A lot was placed into perspective for me as a moderate SQL user. The location and facility is very convenient. The class size is perfect.

Maurice Clough
JT4 LLC

Super helpful in giving me the foundations for SQL.

Ben Kehoe
Starz

Really helped me understand SQL better and improve my skill base.

Kevin Andrees

Overall, I would recommend this class. It's worth taking and definitely perfect for someone new to SQL.

Roxanne L.

Jeanette was great. She was very thorough and enthusiastic!!

Matthew Weaver
Standard Motor Products

The class is very straight forward and easy to follow along. I learned new useful tricks I was not aware of before taking this class.

Nehreen Chowdhury
AmTrust Financial

Great class. The instructor constantly asked if anyone needed help - very attentive.

Seher Syed

This class is a great introduction to the basics of SQL database querying.

Joseph Lee

This class was relevant to what I'm doing at work. It gave me more confidence in SQL and taught me things that I wouldn't have even known to Google.

Felicia Hernandez

Great class! Thorough and took time to answer all my questions.

David Pak

This was my first SQL class and it has been a great experience. Our instructor was a very thoughtful teacher who put a lot of thought into how she presented the material. Her lessons were engaging and useful, and she was very patient with everyone in the class.

Apriya Jaskaran

Schedule & Enrollment: SQL Level I

6 Hours
$350

Policies

NYC or Live Online
Free retake
Setup assistance
Expert instructors
Small classes

Dates & times are listed in

October 15

Sunday 10–5pm

Enroll
October 30

Monday 10–5pm

Enroll
December 11

Monday 10–5pm

Enroll

Tuition

As one of our smaller courses, tuition for this course is due in full before the start date. The best way to save on this course is to take it as part of a certificate program.

Full Tuition

$350
Due before the class starts

What’s Included

6 hours of hands-on instruction
Live, project-based training from experts
Retake for free within 1 year
Verified digital certificate of completion

What’s included with my tuition?

A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement
Expert instructors who are industry professionals and experienced educators that are driven to help you succeed
Top-notch curricula that have been tried and tested over many cohorts and are consistently improved for an optimal learning experience
Supplemental materials to assist both during and after the course - please refer to specific course pages to see what supplemental materials are offered
A 1-year free retake policy which allows students to retake any part of the course or program for free to refresh the materials and gain additional practice
A certificate of completion to verify your accomplishment

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 any discounts for this course?

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: $975 | Hours: 18 Hours
Data Analytics Technologies Bootcamp

Price: $1,949 | Hours: 51 Hours
Business Analyst Certificate

Price: $1,995 | Hours: 63 Hours

Learn the Skills Guarantee™

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

Hands-on, personalized training

Learn with real-world projects

Several students, sitting at computers, looking at the front of the classroom

Cutting edge curriculum

Step-by-step instruction to boost retention

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

Learn from industry experts

Gain industry knowledge from professionals

Free retake

Retake the course for free within one year

Interactive Training

Learn in Real-Time with Small Class Sizes

Attend this course in-person in NYC or Live Online via Zoom. Engage with expert instructors, ask questions, and get feedback on your exercises and projects. Switch between live-online and in-person as needed, even after the course has started.

Unlike other providers, these are not mass open-enrollment classes. At NYC Career Centers, you’ll learn in small groups (typically 8-15 students) and receive personalized attention.

On Campus in NYC 185 Madison Avenue, NYC

Get face-to-face interaction with an instructor and other students when you learn at our NYC campus. Courses are hands-on with a computer and software provided.

Live, interactive class
Experienced instructor in the room with you
Computer and software provided

More about our campus

Live Online Remote, from anywhere

Get 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.

Live, interactive class
Experienced instructor teaching over Zoom
Remote setup assistance provided

More about live online training

photo of instructor leading a class in person

student taking a class live online, seated on their living room floor, leaning against a couch

Earn a Certificate of Completion

Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!

Shareable on

Sample credential for completion of SQL Level I

Free Retake & Class Recordings

Missed a session or need a refresher? We have you covered!

Free Retake

We offer a single free retake of the the class within a year.

Class Recordings

You can also access recordings of each session in your student portal within one business day of the session’s end. Recordings are available for one month after the session.

See terms and conditions.

SQL Level I Curriculum

What You’ll Learn at a Glance

Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of SQL Server Management Studio (Microsoft’s free database app)
Write SQL queries to retrieve data from tables in a database
Primary SQL clauses including SELECT and FROM
Filtering the results using WHERE, AND/OR, IN, and NOT
Wildcard filters as well as mathematical comparisons like equals, greater than, less than, etc.
Combine information from multiple tables with inner JOINs

Project Examples

Learn practical skills by working on real projects with instructor guidance and lectures to strengthen and improve your skill.

Basic Queries in SQL

Write SQL queries to retrieve information from a database to gain insights into your data

Navigate Databases with SQL Server Management Studio’s Interface

Get to know a database by exploring tables, columns, and more using the SQL Server Management Studio user interface

ER Diagrams in SQL Server Management Studio

Create ER Diagrams to see the structure of a database and how tables are connected via Primary & Foreign Keys

Joins in SQL Server

Combine data from multiple tables using JOIN

Course Syllabus

Download Syllabus PDF

Foundations of SQL & Databases

SQL Fundamental Concepts

What is SQL & why is it used?
Flavors of SQL: SQL Server vs Postgres, etc.
Database Tables, Rows, & Columns

Exploring Databases & Writing SQL Statements (with the free SQL Server Management Studio app)

Connecting to a Database
Object Explorer
SQL Query Editor
Using Code Hints
Viewing the Results of your SQL query
Setting Preferences (Options)

Writing SQL Queries

Writing SELECT Statements

Syntax of a SELECT statement
Selecting all columns or specific columns from a table
Limiting the number of results using TOP
Ordering the results using ORDER BY
Returning only DISTINCT records (eliminating duplicates)

Filtering Results

Data Types (Strings vs Numbers)
Comparison Operators: equal to, greater or less than, not equal to, etc.
Filtering results using WHERE, AND, OR, IN, and NOT
Pattern Matching: Wildcard Filters
Case Sensitivity

Using Joins to Combine Data from Multiple Tables

Understanding Table Relationships

What are Primary vs Primary Keys
Creating ER (Entity Relationship) Diagrams to visual what’s in a database
Database Relations: One-to-One, One-to-Many, & Many-to-Many

Combining Tables with JOIN

Inner Joins
Column & Table Aliases

Frequently Asked Questions

How is this class structured?

In this hands-on course you’ll learn to get started with SQL. You will learn to explore data using the graphical interface of SQL Server Management Studio, write SQL queries, combine information from multiple tables, and more. There will be a combination of lectures explaining the concepts, coding demonstrations showing you how to write SQL, and time for you to write SQL queries based on challenge questions we provide.

What flavor of SQL will I learn in this class?

In this training you’ll learn Microsoft SQL Server, but the core concepts can be applied to other flavors of SQL (such as PostgreSQL, MySQL, etc.) with minor syntax differences.

Is there mandatory work outside of the classroom?

You are not required to complete any work outside of class.

Does this course require any prior knowledge or experience?

Students must be comfortable using a computer. No other prior knowledge is required.

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.

Show all FAQs

Compare SQL Level I to Similar Courses

Select up to two courses and tap Compare selected courses to view a side-by-side comparison of SQL Level I with your selected courses.

Installments
	10% non-refundable deposit
$350.00	Total You Pay