asterisk-solid Classes available in-person (strict social distancing) or live online with an extended free retake period. See details.

window-close-line

SQL Classes Live Online

SQL Group Classes & Corporate Training

Learn to extract actionable insights from data with SQL, the most popular language for interacting with databases.

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

SQL Corporate Training

Drive team performance and efficiency with NYIM's industry-leading training. Send employees to our group classes in Live Online or create a custom training program onsite.

Get a Free Quote

Highly-Rated by Our Alumni

Instructor helping student one-on-one

Small Classes

Get personalized attention in small groups

Students collaborating on UX exercise

Hands-on Training

Work on real-world exercises & projects in SQL

Close-up of instructor leading a class

Top Instructors

Learn from industry experts with practical experience

Attentive students in class

Proprietary Curriculum

Take advantage of our 20+ years of curriculum development

5
4.9

Upcoming SQL Courses

Attend our SQL classes live online from anywhere, or request onsite training for your team.

  • 7 SAT
  • 8 SUN
  • 9 MON
  • 10 TUE
  • 11 WED
  • 12 THU
  • 13 FRI
  • 14 SAT
  • 15 SUN
  • 16 MON
  • 17 TUE
  • 18 WED
  • 19 THU
  • 20 FRI
  • 21 SAT
  • 22 SUN
  • 23 MON
  • 24 TUE
  • 25 WED
  • 26 THU
  • 27 FRI
  • 28 SAT
  • 29 SUN
  • 30 MON
  • DEC 1 TUE
  • 2 WED
  • 3 THU
  • 4 FRI
  • 5 SAT
  • 6 SUN
  • 7 MON
  • 8 TUE
  • 9 WED
  • 10 THU
  • 11 FRI
  • 12 SAT
  • 13 SUN
  • 14 MON
  • 15 TUE
  • 16 WED
  • 17 THU
  • 18 FRI
  • 19 SAT
  • 20 SUN
  • 21 MON
  • 22 TUE
  • 23 WED
  • 24 THU
  • 25 FRI
  • 26 SAT
  • 27 SUN
  • 28 MON
  • 29 TUE
  • 30 WED
  • 31 THU
  • JAN 1 FRI
  • 2 SAT
  • 3 SUN
  • 4 MON
  • 5 TUE
  • 6 WED
  • 7 THU
  • 8 FRI
  • 9 SAT
  • 10 SUN
  • 11 MON
  • 12 TUE
  • 13 WED
  • 14 THU
  • 15 FRI
  • 16 SAT
  • 17 SUN
  • 18 MON
  • 19 TUE
  • 20 WED
  • 21 THU
  • 22 FRI
  • 23 SAT
  • 24 SUN
  • 25 MON
  • 26 TUE
  • 27 WED
  • 28 THU
  • 29 FRI
  • 30 SAT
  • 31 SUN
  • FEB 1 MON
  • 2 TUE
  • 3 WED
  • 4 THU
  • 5 FRI
  • 6 SAT
  • 7 SUN
  • 8 MON
  • 9 TUE
  • 9–5pm
    9–5pm
    9–5pm
    9–5pm
    9–5pm
    9–5pm
    5:50–9:20pm
    5:50–9:20pm
    5:50–9:20pm
    5:50–9:20pm
    5:50–9:20pm
    5:50–9:20pm
    9–5pm
    9–5pm
    9–5pm
    9:30–5:30pm
    9:30–5:30pm
    9:30–5:30pm
    9–5pm
    9–5pm
    9–5pm
    5:50–9:20pm
    5:50–9:20pm
    5:50–9:20pm
    5:50–9:20pm
    5:50–9:20pm
    5:50–9:20pm
  • 9–5pm
    9–5pm
    5:50–9:20pm
    5:50–9:20pm
    9–5pm
    9:30–5:30pm
    9–5pm
    5:50–9:20pm
    5:50–9:20pm
  • 9–5pm
    9–5pm
    5:50–9:20pm
    5:50–9:20pm
    9–5pm
    9–5pm
    9:30–5:30pm
    5:50–9:20pm
    5:50–9:20pm
  • 9–5pm
    9–5pm
    9–5pm
    5:50–9:20pm
    5:50–9:20pm
    9–5pm
    9:30–5:30pm
    5:50–9:20pm
    5:50–9:20pm

SQL Training Resources

Learn SQL in Live Online Training

SQL is one of the most popular programming languages used by developers today, with countless technological uses and a secure future. 

Whether you're a developer, seasoned business analyst, or aspiring data enthusiast, our SQL courses give you all the tools you need to extract data, make data-driven business decisions, and develop a career in data analytics. 

For an introduction to SQL or to fill in skills gaps, take our beginner, intermediate or advanced workshops live online. Each course comes with a custom training manual, with step-by-step instructions to complete each skill learned in class. 

Our three-day SQL Bootcamp helps you build data analytics skills from ground zero. Day one starts with developing a thorough understanding of data, different types of databases, and the fundamentals of the SQL language. By day three, you'll work with text data, save SQL code for repetitive tasks using stored features, and create temporary tables. 

Data, Databases, and SQL

Extracting actionable insights from complex data sets is a valuable skill, and SQL is the key to unlocking this ability. Careers in database administration, software development, and market research analytics are growing at a faster than average rate. Whether you use large databases, work with Microsoft Applications, or manage data in an eCommerce store, with SQL, you’ll have the tools to make informed business decisions quickly.

Structured Query Language or SQL (pronounced S-Q-L or sequel) is a back-end programming language explicitly designed to work with database management systems (DBMSs). A database is a collection of organized data. Databases contain tables, which store data in structured groups. For example, a grocery store database would have separate data tables for produce, bakery items, and canned foods.

With SQL, you can:

  • Group and summarize data
  • Retrieve, sort, and filter data
  • Create new fields by calculating two existing fields
  • Retrieve data from multiple tables with inner and outer JOINs
  • Generate stored procedures to save and reuse SQL code
  • Use views to create tables based on other tables

What You'll Learn in our SQL Courses

Our SQL classes include simple, methodical, step-by-step tasks that will teach you everything you need to know. You’ll go from basic query and retrieval tasks to joining SQL tables for better insights and storing complex SQL code for later use. Topics covered in our SQL classes include:

  • Fundamentals of Relational Databases
  • Major clauses including SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY
  • Basic to advanced queries
  • Inner and outer joins to pull data from multiple tables
  • Aggregate functions: SUM, AVERAGE, MIN, MAX, COUNT
  • Tables, views, and indexes
  • Decision-making code using advanced functions

SQL Training Benefits at NYIM

  • Hands-on: Go beyond just lectures and put your new knowledge to work with our “learn by doing” approach. You’ll work on real SQL projects so you can walk away with the skills and confidence you need in SQL.
  • Top Instructors: You’ll learn from top professionals and SQL experts 
  • SQL Workbook: You’ll receive a SQL workbook with training exercises so you brush up and review the materials from the class
  • Interactive: We keep our classes small so you can get personalized attention from the instructors as you work through projects in SQL

SQL Fundamentals & Content Overview

What is SQL?

SQL stands for Structured Query Language and is a 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 a large single table would lead to redundant data (the same customer with multiple order, same product sold multiple times, 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 the 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 existing database and basic theory behind database technology.

Key Topics:

  • Basics of Relational Databases
  • Working in SQL GUI
  • Foundational SQL Querying

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.

Key Topics:

  • More Querying & Joins
  • Saving Queries
  • Sub-querying
  • Math Functions

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 the flow of data through the database.

Key Topics:

  • Importing/Exporting Data
  • Control Structures
  • Temporary Tables
  • Stored Procedures