SQL Server Level I

Hands-on Training from Experts NYC or Live Online

Learn the fundamentals of SQL (Structured Query Language) and relational databases. You'll use Microsoft SQL Server to write SQL queries so you can extract and understand the information stored in databases.

  • Free retake
  • Setup assistance
  • Expert instructors
  • Small classes

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.

Read more

Upgrade to save: learn SQL in just 3 days with our SQL Bootcamp

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 Server Level I is rated 5.0 stars

in the past 24 months

Took the SQL level 1 course with no prior knowledge. It was extremely helpful and it went a pace slow enough for me to understand, while being fast enough that I did not get bored.

Jack D.

SQL Level 1 is a great course to introduce you to writing SQL queries. Starting with the basics, by the end you will understand complex queries with inner or outer joins. Peter was our instructor and his customized course material is very well laid out with practical examples. You work on a local sample database, so you can type notes and test your queries to better understand the output you get. The facility is neat, the equipment is fairly new and ready to use, and beverages are provided.

Martie B.

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.

Colleen M.

Very informative, great teacher, one good thing is you can retake once for no cost.

Michael G.

I took a SQL level 1 class on a Saturday and it was soo helpful. The instructor was humorous, extremely knowledgeable, and was an efficient communicator. He knew exactly how SQL was utilized in a real-world business aspect and was able to give examples of times you'd need to use certain queries and how they can be used most effectively.

Eric B.

I took SQL Levels 1, 2 and 3 with Peter. He is a great instructor who provides practical training you experience with databases. He was very clear with the explanations. Highly recommended!

Naveed K.

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

Kevin M.

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

Randie S.

I took the SQL Level 1 course and had a great experience. The course was very thoughtfully laid out, with easy to follow materials provided. The teacher was great and answered all questions well. Overall, I definitely recommend the course and will be taking more courses from NYIM in the future.

Chris G.

I felt that this class was a great introduction to SQL, coming from someone who had very little exposure to it before the class. They broke it down for us in a very comprehensible manner and provided examples along the way that we could practice. I look forward to taking Level 2!

Alie R.

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 s.
compass

SQL level one is very comprehensive and covers a lot of ground.

Kyle S.
situs

Jeanette is a really wonderful teacher who is very helpful and explains SQL material very well.

Jenyu W.

I had self taught myself SQL while on the job a couple of years ago. I took this as a refresher since I haven't used SQL in a while and I left learning a lot more b/c I finally understood why everything worked a certain way.

Judy Y.
VTS, Inc.

My experience at Career Center was extremely valuable. In one day I was able to feel confident querying databases to get desired results and perform analysis. Real-world examples make the experience even more valuable.

Tyler S.
Vita Coco

I would definitely use the service again, considering current events, the team has been very helpful.

Louis M.
Apple Bank

Jeannette took her time and used real world examples to highlight the usefulness of the material.

Jeannine B.
ForwardPMX

Schedule & Enrollment: SQL Server Level I

  • 6 Hours
  • $350
  • NYC or Live Online
  • Free retake
  • Setup assistance
  • Expert instructors
  • Small classes

  • May 14 & 16
    Tuesday & Thursday 6–9pm
    Enroll

  • May 28
    Tuesday 10–5pm
    Enroll

  • June 24
    Monday 10–5pm
    Enroll

  • July 29
    Monday 10–5pm
    Enroll

  • September 18
    Wednesday 10–5pm
    Enroll

  • September 30–October 7
    Mondays 6–9pm
    Enroll

Show more
Sunlit data science classroom
One-on-one training in NYC
Outside NYIM’s office at 34th & Madison
Excel class in session

Compare SQL Server Level I to Similar Courses

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

  • SQL Bootcamp

    18 hours $975

    Learn Microsoft SQL Server to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering the results. Extract actionable insights from data sets in this hands-on training.

    Full details

  • SQL Server Level II

    6 hours $350

    Build on your knowledge of SQL fundamentals and enhance your skills to filter, group, and analyze data in this intermediate SQL course.

    Full details

  • SQL Server Level III

    6 hours $425

    Take your SQL skills to the next level in this advanced course. You’ll learn about subqueries, views, variables, functions, stored procedures, and more.

    Full details

  • Microsoft Access Bootcamp

    12 hours $499

    If you want to master intermediate and advanced functions of Microsoft Access quickly, the bootcamp is the perfect place to start. In this two-day, 14-hour course, you’ll go from learning the Access interface to using advanced reporting techniques.

    Full details

Beginner SQL Classes New York City

Learn database fundamentals—Write Database Queries with SQL

SQL is the most commonly used coding language in databases around the world. SQL Level I covers the fundamentals of relational databases, Microsoft SQL Server, and the SQL database language. Learn how databases store data within tables and how to write queries to understand data.

Our experienced instructor will guide you through a variety of queries, including wildcard filters and multi-table queries with inner and outer joins. At the end of the class, apply the skills you’ve learned in a series of practice tasks. Our course workbook includes step-by-step instructions for each activity so you can brush up on the tasks at work or home.

At the end of this course, you’ll be able to do the following:

  • Explore information stored in a database using SQL Server Management Studio
  • Write simple SQL queries to retrieve data from tables in a database
  • Use primary SQL clauses and filter your data

Save 15% and Become a SQL Expert in 3 Days!

Is your ultimate goal to become a SQL pro? Go from Beginner to Expert in three days with our SQL bootcamp. You’ll start out with the same basic training in SQL fundamentals, and quickly move to advanced functions. Best of all, you’ll save 15%!

Why Take SQL Classes in NYC at NYIM?

At NYIM, we provide everything you need for SQL Level 1. Exploring SQL and not sure if you’re ready to commit? This is the perfect course for you. We supply computers (PC), SQL software, and course workbooks for each student that enrolls in our classes.

Within one year of completing the class, you can retake the course again at no additional charge. SQL Level 1 is the perfect course for beginners or individuals that would like to know the basics of databases and queries.

Read more
Yelp Facebook LinkedIn YouTube Twitter Instagram