SQL Bootcamp in NYC or Live Online

Hands-on SQL Classes in NYC or Live Online & SQL Corporate Training

$1075 $915
24 Hours
PC provided
Small in-person class
Free retake
185 Madison Avenue, NYC
Also available live online

All SQL Courses SQL Bootcamp

3-Day Intensive SQL Bootcamp

Master SQL in as little as three days in our NYC SQL bootcamp. The SQL bootcamp combines SQL Level 1, SQL Level 2, and SQL Level 3 courses at a 15% discount.

SQL Bootcamp Courses

Day 1, beginner SQL, introduces relational database management systems, Microsoft SQL Server and database queries
Day 2, intermediate SQL, explores tables, views, indexes, math, and subqueries and introduces stored procedures.
Day 3, advanced SQL, dives into stored procedures and triggers to automate tasks, temporary tables, working with live data, and data conversion functions.

In our SQL bootcamp, our instructor will walk you through every exercise, teaching as you review examples and practice tasks on your own. The instructor’s computer is connected to a projected screen, so that you can follow along and ask questions. Each student has access to a computer with Microsoft SQL Server installed to use during the class.

Flexible SQL Training in New York

Choose from an intensive bootcamp over three consecutive days or take one course each week for three weeks. You can enroll in weekday, evening, and weekend courses. The bootcamp fee includes a free course retake 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

Custom Schedule
Register
Dec 2–17
Register
- SQL Level I
  
  Wed–Thu, Dec 2–3, 5:50–9:20pm
- SQL Level II
  
  Wed–Thu, Dec 9–10, 5:50–9:20pm
- SQL Level III
  
  Wed–Thu, Dec 16–17, 5:50–9:20pm
Dec 14–16
Register
- SQL Level I
  
  Mon, Dec 14, 9am–5pm
- SQL Level II
  
  Tue, Dec 15, 9am–5pm
- SQL Level III
  
  Wed, Dec 16, 9am–5pm
Jan 10–24
Register
- SQL Level I
  
  Sun, Jan 10, 9:30am–5:30pm
- SQL Level II
  
  Sun, Jan 17, 9:30am–5:30pm
- SQL Level III
  
  Sun, Jan 24, 9:30am–5:30pm
Jan 11–13
Register
- SQL Level I
  
  Mon, Jan 11, 9am–5pm
- SQL Level II
  
  Tue, Jan 12, 9am–5pm
- SQL Level III
  
  Wed, Jan 13, 9am–5pm
Jan 25–Feb 9
Register
- SQL Level I
  
  Mon–Tue, Jan 25–26, 5:50–9:20pm
- SQL Level II
  
  Mon–Tue, Feb 1–2, 5:50–9:20pm
- SQL Level III
  
  Mon–Tue, Feb 8–9, 5:50–9:20pm
Feb 17–19
Register
- SQL Level I
  
  Wed, Feb 17, 9am–5pm
- SQL Level II
  
  Thu, Feb 18, 9am–5pm
- SQL Level III
  
  Fri, Feb 19, 9am–5pm
Mar 13–27
Register
- SQL Level I
  
  Sat, Mar 13, 9:30am–5:30pm
- SQL Level II
  
  Sat, Mar 20, 9:30am–5:30pm
- SQL Level III
  
  Sat, Mar 27, 9:30am–5:30pm
Mar 24–26
Register
- SQL Level I
  
  Wed, Mar 24, 9am–5pm
- SQL Level II
  
  Thu, Mar 25, 9am–5pm
- SQL Level III
  
  Fri, Mar 26, 9am–5pm
Apr 7–22
Register
- SQL Level I
  
  Wed–Thu, Apr 7–8, 5:50–9:20pm
- SQL Level II
  
  Wed–Thu, Apr 14–15, 5:50–9:20pm
- SQL Level III
  
  Wed–Thu, Apr 21–22, 5:50–9:20pm
Apr 28–30
Register
- SQL Level I
  
  Wed, Apr 28, 9am–5pm
- SQL Level II
  
  Thu, Apr 29, 9am–5pm
- SQL Level III
  
  Fri, Apr 30, 9am–5pm

The SQL Bootcamp Includes

SQL Level I

Learn the basics of relational database management systems and SQL queries, including joins. By the end of this course, you'll be able to write basic SQL queries that retrieve data.

SQL Level II

Dive into the core of SQL. Learn views, functions, subqueries and more. By the end of this course, you'll be able to work with advanced queries, manipulate tables, and index table data.

SQL Level III

Gain mastery in the most complex areas of SQL, including stored procedures and temporary tables. After taking this course, you’ll be able to export data, create triggers, and automate tasks.

Full Course Syllabus

Download PDF Outline

SQL Level I

Basic Concepts

Microsoft SQL Server
What is SQL?
What are Relational Databases?

The Graphic User Interface

Object Explorer
Query Window
Results Grid
Options

The Code

Basic Clauses
Field and Table Aliases
Creative use of Aliases
Inner Table Joins
Aggregations
Distinct Records
Text Criteria & Operators
Wildcard Filters
Numeric Criteria & Operators

Student Labs

SQL Level II

The Code

Self Joins
Union Joins
Cross Joins

Saving Queries Programmatically

Views
Functions
Stored Procedures
Layered Views
Create Top Value Views

Sub Queries

What is a Sub Query?
Clarity and Transparency
Single Table Sub Query
Multiple Table Sub Query
Exists versus In Operators
Any versus All Operator

Math, Advanced Functions and Logic Statements

Basic Math
Advanced Date and Time Functions
Advanced Text Functions
Case When Then Logic Statements
Variables and User Functions

Student Labs

Creating Views
Sub Queries
Advanced Functions
Logic and Date Functions

SQL Level III

Importing and Exporting Data

Creating a Database and Tables in SQL
Importing and Exporting Data from and to Excel
Importing and Exporting Data from and to Access
Importing, Updating and Deleting Data via Code

Building Control Structures

Creating Primary Keys, Indexes and Constraints
Setting up Referential Integrity
Creating Database Diagrams

Temporary Tables

Low Level Security Overview
Local Temp Tables
Global Temp Tables

Stored Procedures

Parameter Queries using Variables through Views
Automation of Workflow Processes
Triggers to Create Workflow Events

Optional

Protect Views with Schema binding
Data Conversion Functions

This Course is Available Live Online

You can attend this training live online at the scheduled time the course is offered (New York, Eastern Time) through screen-sharing software Zoom (free for you).

Classes are activity-based and taught by a live instructor.
You can hear the instruction, ask questions, and share your screen—all in real-time.
Retake the course for free (in-person or live online) within one year.

Learn more about how our live online training works

3-Day Intensive SQL Bootcamp

SQL Bootcamp Courses

Flexible SQL Training in New York

Class Notes

Custom Schedule Register circle-arrow-solid

Dec 2–17 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Dec 14–16 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Jan 10–24 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Jan 11–13 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Jan 25–Feb 9 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Feb 17–19 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Mar 13–27 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Mar 24–26 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Apr 7–22 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Apr 28–30 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Custom Schedule Register circle-arrow-solid

Dec 14–16 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Jan 11–13 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Feb 17–19 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Mar 24–26 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Apr 28–30 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Custom Schedule Register circle-arrow-solid

Dec 2–17 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Jan 25–Feb 9 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Apr 7–22 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Custom Schedule Register circle-arrow-solid

Custom Schedule
Register

Dec 2–17
Register

Dec 14–16
Register

Jan 10–24
Register

Jan 11–13
Register

Jan 25–Feb 9
Register

Feb 17–19
Register

Mar 13–27
Register

Mar 24–26
Register

Apr 7–22
Register

Apr 28–30
Register

Custom Schedule
Register

Dec 14–16
Register

Jan 11–13
Register

Feb 17–19
Register

Mar 24–26
Register

Apr 28–30
Register

Custom Schedule
Register

Dec 2–17
Register

Jan 25–Feb 9
Register

Apr 7–22
Register

Custom Schedule
Register

Jan 10–24
Register

Mar 13–27
Register