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

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

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