(212) 684-5151

SQL Courses New York City

Training facility for SQL classes

Hands-on SQL training classes in Manhattan, NYC

SQL has become the standard for relational database management, and the premier tool for storing and analyzing data. SQL is used to extract data from a large set of related tables, helping user make informed decisions based on data analytics. Career Centers offers the leading SQL courses, beginner to advanced, for the most effective SQL training experience in New York City.

Our SQL classes will cover: select queries, writing inner and outer joins, creating views, subqueries, user functions and stored procedures, importing and exporting. You'll get personalized attention in small class sizes and our comfortable Midtown Manhattan training facility. The classes are taught with proprietary training methods and step-by-step instruction to build comprehension.

Beginner to advanced SQL Courses

Starting with our beginner SQL course, you will use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database. In our intermediate SQL class, we will create advanced SQL queries, and manipulate and index tables. Our advanced SQL training will show how to write decision making code, using advanced functions for manipulating text.

Small Group SQL Classes & Corporate SQL Training

Our SQL classes are taught by a live instructor in NYC in small groups. We also offer private SQL training with the ability to customize the course content.

SQL Bootcamp NYC

If you are looking for comprehensive SQL training, our SQL bootcamp includes the beginner, intermediate and advanced SQL classes at a 15% discount. Buy the complete bootcamp package for only $915 ($160 discount).

Upcoming SQL Classes in New York City

Code Course Name Hours Price Location
SC Beginner SQL 8 $325 185 Madison Ave, NYC
SD Intermediate SQL 8 $325 185 Madison Ave, NYC
SE Advanced SQL 8 $425 185 Madison Ave, NYC
SQB SQL Bootcamp 24 $915 185 Madison Ave, NYC
SF Database Cleansing 8 $425 185 Madison Ave, NYC
ED Create/Analyze Database in Excel 8 $345 185 Madison Ave, NYC
RD Relational Database Fundamentals 8 $425 185 Madison Ave, NYC

Beginner SQL Course
  • Simple Queries
  • Conditional Criteria
  • Organize Data
  • Join Tables
  • Aggregate Functions
Use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database.

$325.00

Advanced SQL Course
  • CASE WHEN THEN
  • Format Numbers
  • Text Functions
  • Stored Procedures
  • Create Temp Tables
Learn techniques for writing decision making code, using advanced functions for manipulating text, using data conversion functions and formatting output to make data more comprehensible. You will also explore temporary tables, parameterized queries and creating Stored Procedures to automate work flow.

$425.00

Database Cleansing
  • Identify Bad Practices
  • Analyze Data Integrity
  • Correct Poor Data Using Formulas
  • Structure Tables For Import
  • Analyze Data Integrity
Explore various issues that cause databases to be unreliable and identify tools that can be used to correct the underlying problems.

$425.00

Relational Database Fundamentals
  • Identify the Components of a Database
  • Organize Data in Tables
  • Understand Relationships
  • Link Multiple Tables to Extract Data
  • Query a Database
  • Understand a Basic SQL Statement
Designed for students who not only need to learn the basics of the SQL language but to also understand how true databases function and understand the benefits of using these specialized tools. It is also recommended for students who need to learn MS Excel Power Pivots which is also based on relational concepts. It also provides the fundamental knowledge and techniques needed to advance to more complex data analysis scenarios.

$425.00

Intermediate SQL Course
  • Subqueries
  • Insert, Update, Delete
  • Create Tables
  • Create Views
  • Create Indexes
Create advanced SQL queries, and manipulate and index tables. Course Objective: You will work with advanced queries and manipulate tables. You will also view and index table data.

$325.00

SQL Bootcamp
  • Beginner SQL
  • Intermediate SQL
  • Advanced SQL
Sign up today for three levels of SQL at a 15% discount with our SQL Bootcamp package: Basic, intermediate, advanced.

$915.00

Creating & Analyzing Database
  • Working with Databases
  • Using AutoFilter
  • Working with Advanced Filters
  • Lookup Formulas
  • Exporting and Importing Data
  • Creating/Revising PivotTable
Provides students with the knowledge and skills, to use advanced Excel features, in creating and analyzing databases. Learn how to sort and manage data; filter and query data; and apply lookup and database functions. Learn to analyze and evaluate the information in the databases by creating pivot table and pivot charts.

$345.00

SQL Fundamentals & Content Overview

What is SQL?

SQL stands for Structured Query Language and is programming language used to manage data held in a relational database management system.

What is Microsoft SQL Server?

Microsoft’s database management application, comparable to many other database management tools made by many other software developers.

Relational Databases

Relational databases break up huge data sets into component elements called tables. Tables are designed to only hold elements pertaining to one specific topic.

For example, consider a scenario where customers are buying products. Storing the data in in a large single table would lead to redundant data (same customer with multiple order, same product sold multiple time, etc.). Instead, we break up the large table into its component parts (i.e. one table for customers, one table for products, one table for transactions, etc.). This reduces redundant data, facilitates data entry, allows for easy searching within the databases, and ability to summarize data. The tables contain certain fields that are common to other tables, thereby allowing them to be queried, or searched from, as if it were all in one table.

What can SQL be used for?

SQL is useful for database management, including storing databases, building databases, managing databases, analyzing databases, and communicating with other data management tools and reporting tools.

SQL Topics & Terms

  • Query: Extracting data and analyzing it (like a search request from the database)
  • Data normalization: Structuring tables to prevent duplication of data
  • Data integrity: Preventing records from being scrambled or matching up with incorrect items
  • Client server architecture: Server-side processing to facilitate rapid distribution of data
  • Aggregations: Summarizations via common functions
  • Set Theory: Branch of mathematics upon which SQL is based
  • One to many relationships: Connecting tables so one record can access many records in another table
  • Primary keys: Unique record identifier
  • Foreign keys: Fields in tables that connect to primary keys in other tables and enforce data integrity rules
  • Indexes: Sort orders & constraints that are placed on fields to enhance speed and prevent data duplication
  • Efficiencies and Execution Plans: writing code in a manner to promote speed and accuracy
  • Views: Programmatically stored queries made available to other users and to enable layered queries
  • Stored Procedures: Queries that can create automation for repetitive tasks and complex processes
  • Transactions: Creating undo levels for various processes

What You'll Learn in Our SQL Classes

Beginner SQL Class

Review the basics of coding to extract data from an existent database and basic theory behind database technology.

Intermediate SQL Class

Continue the extraction concepts into more complex scenarios. Introducing code that will also manage the structure of the database and concepts on security.

Advanced SQL Class

Build databases and the tables and other structures required for the management of databases: exporting, importing, editing and deleting data. Build automation to archive data and facilitate flow of data through the database.