SQL Level I

Beginner SQL Courses in NYC

  • tag-solid $325
  • clock-solid 8 Hours
  • display-solid PC provided help-solid
  • users-solid Small in-person class
  • repeat-line Free retake help-solid
  • map-marker-solid 185 Madison Avenue, NYC
All SQL Courses SQL Level I

Get an overview of databases and queries in SQL Level 1. In this course, you’ll begin with an introduction to relational database management systems and practice connecting to Microsoft SQL Server. Next, you'll dive right into writing basic SQL queries to retrieve data from the database management system.

The Best SQL Courses in NYC

Our SQL courses offer the best value for your investment. Career Centers provide computers, Microsoft SQL Server, a proprietary training manual that you can keep, and small class sizes. You’ll learn everything you need to master SQL fundamentals for one affordable fee.

SQL Bootcamp

Choose from day evening and weekend options to find a course that suits your schedule. Our instructors are also available for private training. Enroll in our SQL bootcamp, which includes SQL Level 1, SQL Level 2, and SQL Level 3 at a 15% discount. 

Retake the course free of charge within 6 months. 

Class Notes

  • SQL can be used with a variety of programs. This course uses Microsoft SQL Server.
  • Prerequisites: None; basic computer skills

Upcoming Class Dates

Corporate training classroom
Career Centers teacher helping a student

Looking for corporate training?

We offer custom onsite training and discounted class vouchers.

envelope-solid nyc@careercenters.com
phone-handset-solid 212 • 684 • 5151
file-group-solid Download Syllabus

Course Overview

  • Connect to the SQL Server database and execute a simple query
  • Include a search condition in a simple query
  • Use various functions based on the data types to perform calculations on data
  • Organize the data obtained from the query before it is displayed on the screen
  • Retrieve data by combining information from multiple tables
  • Format the output, save the result, and generate a report
block-quote-line

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

circle-arrow-solid circle-arrow-solid

Full Course Syllabus

file-group-solid Download PDF Outline

Basic Concepts

1) Microsoft SQL Server

2) What is SQL?

3) What are Relational Databases?

The Graphic User Interface

4) Object Explorer

5) Query Window

6) Results Grid

7) Options

The Code

8) Basic Clauses

9) Field and Table Aliases

10) Creative use of Aliases

11) Inner Table Joins

12) Aggregations

13) Distinct Records

14) Text Criteria & Operators

15) Wildcard Filters

16) Numeric Criteria & Operators

Student Labs