SQL Level I

Name: SQL Level I
Start: 2025-09-08T10:00:00-04:00
End: 2025-09-08T17:00:00-04:00
Location: NYC Career Centers

NYC Career Centers

4.5 683 reviews

Learn the fundamentals of SQL and relational databases in this introductory course, where you'll gain the skills to write SQL queries, filter results, and combine data from multiple tables. Explore the basics of database architecture and develop your skills in writing real SQL code with practical, hands-on exercises.

Beginner
18 and older
$350
Earn 10% Rewards
Price Lock
185 Madison Ave, New York, NY & Virtually Online

Book at School

Express Checkout – $350

Proceed to Checkout

No Booking Fees. Lowest Price Guaranteed. Earn 10% Rewards.

Give as a Gift

Start Dates (5)

$350/person

Mon, May 5th, 6–9pm EDT

20 left

Book

Show all 2 sessions

Mon, May 05 at 6:00pm - 9:00pm
Wed, May 07 at 6:00pm - 9:00pm

Mon, May 12th, 10am–5pm EDT

20 left

Book

Mon, Jun 16th, 10am–5pm EDT

20 left

Book

Mon, Jul 28th, 10am–5pm EDT

20 left

Book

Mon, Sep 8th, 10am–5pm EDT

20 left

Book

Showing 1 – 5 of 5

Save to WishList Give as a Gift

The class was very informative, the instructor was very detailed & I highly recommend the course for all SQL beginners.

Kevin M.

Description

Learn the fundamentals of SQL (Structured Query Language) and relational databases, so you can start writing SQL queries to extract and understand the information stored in databases.

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.

Learn more about SQL Level 1 at NYC Career Centers.

Syllabus

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

Refund Policy

Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYC Career Centers (683)

(4.5-star rating across 683 reviews)

SQL Level I

Anonymous • February 8, 2020

Great intro into SQL
SQL Level I

Normari M. • October 23, 2019

Great class very informative
SQL Level I

Anonymous • May 19, 2019

The class size was small, The instructor was knowledgeable and thorough, and very kind. However we didn't get a chance to do any labs/practice on our own - I believe that the best way of learning is practicing with the instructor, then independently, and then going over the labs together.
SQL Level I

Rosanna M. • February 7, 2019

Great instructor. Made the class interesting and fun
SQL Level I

shariq m. • November 8, 2018

Instructor was great!!! Learned a lot
SQL Level I

Colleen M. • October 24, 2018

This class was a great introduction. The instructor made the material relevant and fun. He did a great jab reinforcing the basics and laying the groundwork to continue advancing with next course levels.
SQL Level I

Anonymous • September 4, 2018

Wish we had more time to write our own queries
SQL Level I

Francisco F. • June 4, 2018

It was wonderful, but mainly the instructor made the class very interesting.
SQL Level I

Kevin M. • March 14, 2018

The class was very informative, the instructor was very detailed & I highly recommend the course for all SQL beginners.
SQL Level I

Randie S. • March 1, 2018

Great beginners class! The instructor was entertaining as she taught. Learned the fundamentals! I would definitely recommend this course.
SQL Level I

Shira S. • March 1, 2018

Thought it was really helpful - though it helped that I had a little experience using SQL already. I wish that they would use more medical/clinical examples as almost the entire class worked in hospital settings and the setup of these types of databases aren't as straightforward as something like product development.
SQL Level I

Michael G. • January 26, 2018

Could use more time for assessments and labs within the class
SQL Level I

Anonymous • January 17, 2018

The instructor was very knowledgeable and had a good course philosophy - hand-holding sometimes, letting us do things ourselves most of the time. I rated four instead of five stars because I was the only person that seemed to start from a true beginner's perspective in this course - everybody else seemed to have some knowledge about joins, aggregates, and other concepts. That's totally fine - I learned a lot from their conversation with the instructor. I will have to practice a bunch to learn some of the more complicated concepts.
SQL Level I

Karen O. • November 12, 2017

Pace was ideal, not too fast that beginner couldn't keep up, but not too slow that it got boring.
SQL Level I

Anonymous • September 7, 2017

Great class! This was a good overview of SQL. I am looking forward to practicing and attending Session 2. The only think i would improve is to have more independent work. I am a very hands on learner and I believe it would have been a good experience to try to create a lot of solutions on my own.
SQL Level I

Anonymous • August 27, 2017

Coming in with a few years of database experience, I find this class to be a very good refresher course. The instructor, Peter, is a database elite; and he was great conducting the class -- the pace was just right, the topics were covered, and he encouraged us to think and engage in discussions. Unfortunately, he doesn't teach at night (I plan to attend the night session of SQL Level 2). The location was easily accessible from where I live (Jersey City). The classroom was clean, but a little too tiny. Good thing the class was small -- we were only five in the session, so room size didn't really matter at the time. The PC's were all working and ready, and we experienced no technical disruptions at all. We had a short morning break, a one hour lunch, and an afternoon break. Our group decided to shorten our lunch break so we could leave a little early. Keurig coffee machine is available at the lobby, and there's also a mini-fridge with water bottles and cans of soda for everyone. My only nitpick was the outside noise: the location was at the intersection of Madison and 34th, I could hear the constructions and ambulances. But the same can be said to other training schools I went to, so I am used to it. YMMV. Overall, I would recommend this class to anyone who wants to get his/her feet wet on SQL database. If you don't get it the first time, there's always a free retake (valid for a year I believe).
SQL Level I

Anonymous • July 27, 2017

Ready to go computers. Small classroom size. Easy to find location
SQL Level I

Anonymous • May 25, 2017

SQL level 1 was a great class to introduce SQL and to practice it. The instructor, Peter, was very informative and made sure we understood the concepts before moving on. He did a great job of testing our knowledge throughout the class.
SQL Level I

Kevin B. • April 20, 2017

The teacher was incredibly knowledgeable and not afraid to challenge you to come up with answers yourself. I wish there was more emphasis on practicing the code and testing varied uses after seeing the initial example.
SQL Level I

Anonymous • April 8, 2017

Professor was dreamy

See 156 More Course Reviews

See reviews for other classes at NYC Career Centers

Hide Reviews

Review Summary by CourseHorse

Students who took the SQL Level I class found it to be a great introduction to SQL, as the the instructor was knowledgeable, thorough, and made the class interesting and fun. Overall, they felt the class was very informative and the instructor detailed and effective. Students appreciated that the class had a good pace, not too fast or slow. The location and facilities were also praised for being easily accessible, clean, and well-equipped. Overall, students found the class to be a great learning experience and would recommend it to others. Quotes: 1. "This class was a great introduction. The instructor made the material relevant and fun. He did a great job reinforcing the basics and laying the groundwork to continue advancing with next course levels." 2. "The instructor was very knowledgeable and had a good course philosophy - hand-holding sometimes, letting us do things ourselves most of the time. That's totally fine - I learned a lot from their conversation with the instructor." 3. "The instructor, Peter, was very informative and made sure we understood the concepts before moving on. He did a great job of testing our knowledge throughout the class."

Questions & Answers (13)

Get quick answers from CourseHorse and past students.

Question from Anonymous

What’s the duration of the course? Thank you

Answer Show answer

Question from anonymous

How many sessions?

Answer Show answer

Question from Anonymous

Is a computer provided?

Answer Show answer

Question from anonymous

Is there are prerequisite training or experience expected?

Answer Show answer

Question from Chelsea C.

Can this class be taken on a Mac? And do we need any specific software?

Answer Show all 2 answers

Question from Kate K.

Hi! Do you provide any kind of certificate after taking the course? Thanks Kate

Answer Show all 2 answers

View all 13 questions

NYC Career Centers

Since 1988, Career Centers has been a leader in software training courses for individuals and businesses, including Microsoft Excel, VBA, PowerPoint, SQL Server, Adobe Photoshop, InDesign, Illustrator, and AutoCAD.

Our courses are instructor-led in small class sizes, located in our state-of-the-art training...

Give This Course as a Gift Card

Thousands of classes
No expiration
Unique and memorable gifts for any occasion
Personalized
Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
Instant delivery
Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Express Checkout – $350

Start Dates (5)

Kevin M.

Class Description

Description

Syllabus

Foundations of SQL & Databases

SQL Fundamental Concepts

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

Writing SQL Queries

Writing SELECT Statements

Filtering Results

Using Joins to Combine Data from Multiple Tables

Understanding Table Relationships

Combining Tables with JOIN

Refund Policy

Reviews of Classes at NYC Career Centers (683)

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

SQL Level I

Review Summary by CourseHorse

Questions & Answers (13)

NYC Career Centers

Give This Course as a Gift Card

Book this Class as a Group Event

CourseHorse Gift Cards

Here’s 10% off (up to $20) your first class!

Your Event