Discover Classes. Earn Rewards.

SQL Level I

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
  • 185 Madison Ave, New York, NY & Virtually Online

Start Dates (8)

  • $350
  • Career Centers @ 185 Madison Ave Suite 1104, New York, NY 10016
20 seats left
Book
20 seats left
Book
Show all 2 sessions
  • Tue, May 14 at 6:00pm - 9:00pm
  • Thu, May 16 at 6:00pm - 9:00pm
20 seats left
Book
20 seats left
Book
20 seats left
Book
Showing 15 of 8

Class Description

Description

What you'll learn in this sql server training:

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 (679)

(4.5-star rating across 679 reviews)
  • SQL Level I

    Anonymous review on 2/8/2020
    Great intro into SQL
  • SQL Level I

    Reviewed by Normari M. on 10/23/2019
    Great class very informative
  • SQL Level I

    Anonymous review on 5/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

    Reviewed by Rosanna M. on 2/7/2019
    Great instructor. Made the class interesting and fun
  • SQL Level I

    Reviewed by shariq m. on 11/8/2018
    Instructor was great!!! Learned a lot
  • SQL Level I

    Reviewed by Colleen M. on 10/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 review on 9/4/2018
    Wish we had more time to write our own queries
  • SQL Level I

    Reviewed by Francisco F. on 6/4/2018
    It was wonderful, but mainly the instructor made the class very interesting.
  • SQL Level I

    Reviewed by Kevin M. on 3/14/2018
    The class was very informative, the instructor was very detailed & I highly recommend the course for all SQL beginners.
  • SQL Level I

    Reviewed by Randie S. on 3/1/2018
    Great beginners class! The instructor was entertaining as she taught. Learned the fundamentals! I would definitely recommend this course.
  • SQL Level I

    Reviewed by Shira S. on 3/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

    Reviewed by Michael G. on 1/26/2018
    Could use more time for assessments and labs within the class
  • SQL Level I

    Anonymous review on 1/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

    Reviewed by Karen O. on 11/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 review on 9/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.
See 156 More Course Reviews
loading...
See reviews for other classes at NYC Career Centers
loading...
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 from Brenda L. CourseHorse StaffCourseHorse Staff
Hi there! We have two option for this class. We have one session that is from 9am to 5pm, and we have 2 sessions that are from 5:50pm to 9:20pm. You may choose which time works for you. Hope this helps!
Answer Show answer
Cancel
Question from anonymous
How many sessions?
Answer from Helen L. Verified Student
2
Answer Show answer
Cancel
Question from Anonymous
Is a computer provided?
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi there! Yes, computers are provided for students taking this course. Hope this helps!
Answer Show answer
Cancel
Question from anonymous
Is there are prerequisite training or experience expected?
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi there! This is a beginner SQL class that will introduce the fundamentals of databases. The only prerequisite is basic computer knowledge.
Answer Show answer
Cancel
Question from NanA
Are computers supplied or do students need to bring their own laptops? Thanks
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi Nana! Computers are provided by the school.
Answer Show answer
Cancel
Question from Anonymous
Hello, what're the length and schedule of the course? Thank you
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hello there! The class is for 8 hours and the schedule is posted on this class page. You may click on the link "Next Class Dates" just above this page to see the full class schedule that will fit your need. Hope this helps!
Answer Show answer
Cancel
Question from Angelica B.
What is the background of the trainer?
Answer from Angelica B. CourseHorse StaffCourseHorse Staff
All of our Instructors are BPSS approved with more than 20 years of Experience.
Answer Show answer
Cancel
Question from Angelica B.
Will the users be using ssms and doing actual queries?
Answer from Angelica B. CourseHorse StaffCourseHorse Staff
Students will be using SQL Server Management Studio 2014, and yes, they are doing actual queries.
Answer Show answer
Cancel
Question from Angelica B.
Are the classes definite? They may have someone travel to NY for one of these classes.
Answer from Angelica B. CourseHorse StaffCourseHorse Staff
We only reschedule or cancel classes in case of emergency and will try to notify students in advance of any potential schedule changes.
Answer Show answer
Cancel
Question from Chelsea C.
Can this class be taken on a Mac? And do we need any specific software?
Answer from Michael G. Verified Student
This class is given on a PC not a Mac. You don't need to bring your computer as they are provided for you. You also don't need to bring any software as it is provided for you.
Answer from Jenn C. CourseHorse StaffCourseHorse Staff
Hi Chelsea! Unfortunately, Microsoft SQL server 2014 cannot be installed on the mac. The flavor of SQL for the Mac is Postgres which the school does not support in the class. However, they provide PCs in the classroom for your convenience. If you'd be interested in private tutoring on Postgres for the Mac please let us know through [email protected] and we'll be happy to connect you with them!
Answer Show all 2 answers
Cancel
Question from Jenn S.
Hi guys, is this an appropriate course for me who doesn't have any database experience?
Answer from Angelica B. CourseHorse StaffCourseHorse Staff
Hi, yes it is appropriate. This is a beginner SQL class that will introduce the fundamentals of databases. The only prerequisite is basic computer knowledge.
Answer Show answer
Cancel
Question from Kate K.
And is this price for one or two sessions? Because when I try to book this course drop-down menu with dates will come out to select one date. So I wonder wether this is start date or single date. Thanks Kate
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi Kate! For the October 25 class, there will be two sessions. If you noticed, the class per day is only for 3.5 hours. The rest of the schedules are for one-day session only. You can check the number of sessions on the 4th column of the schedule. I hope this helps!
Answer Show answer
Cancel
Question from Kate K.
Hi! Do you provide any kind of certificate after taking the course? Thanks Kate
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi Kate! Yes, you will receive a certificate of completion for this class. I hope this helps!
Answer from Elisabeth B. Verified Student
Yes, I received a certificate at the end of the course stating it was completed and signed by the instructor
Answer Show all 2 answers
Cancel
View all 13 questions

Similar Classes

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

Read more about NYC Career Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

NYC Career Centers

NYC Career Centers

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

Google Map

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.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...