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
Mar 13–27
Register
- SQL Level I
  
  Sat, Mar 13, 9:30am–5:15pm
- SQL Level II
  
  Sat, Mar 20, 9:30am–5:15pm
- SQL Level III
  
  Sat, Mar 27, 9:30am–5:15pm
Mar 24–26
Register
- SQL Level I
  
  Wed, Mar 24, 9:30am–5:15pm
- SQL Level II
  
  Thu, Mar 25, 9:30am–5:15pm
- SQL Level III
  
  Fri, Mar 26, 9:30am–5:15pm
Apr 7–22
Register
- SQL Level I
  
  Wed–Thu, Apr 7–8, 6–9:20pm
- SQL Level II
  
  Wed–Thu, Apr 14–15, 6–9:20pm
- SQL Level III
  
  Wed–Thu, Apr 21–22, 6–9:20pm
Apr 28–30
Register
- SQL Level I
  
  Wed, Apr 28, 9:30am–5:15pm
- SQL Level II
  
  Thu, Apr 29, 9:30am–5:15pm
- SQL Level III
  
  Fri, Apr 30, 9:30am–5:15pm
May 12–27
Register
- SQL Level I
  
  Wed–Thu, May 12–13, 6–9:20pm
- SQL Level II
  
  Wed–Thu, May 19–20, 6–9:20pm
- SQL Level III
  
  Wed–Thu, May 26–27, 6–9:20pm
Jun 9–11
Register
- SQL Level I
  
  Wed, Jun 9, 9:30am–5:15pm
- SQL Level II
  
  Thu, Jun 10, 9:30am–5:15pm
- SQL Level III
  
  Fri, Jun 11, 9:30am–5:15pm
Jun 12–26
Register
- SQL Level I
  
  Sat, Jun 12, 9:30am–5:15pm
- SQL Level II
  
  Sat, Jun 19, 9:30am–5:15pm
- SQL Level III
  
  Sat, Jun 26, 9:30am–5:15pm
Jul 21–23
Register
- SQL Level I
  
  Wed, Jul 21, 9:30am–5:15pm
- SQL Level II
  
  Thu, Jul 22, 9:30am–5:15pm
- SQL Level III
  
  Fri, Jul 23, 9:30am–5:15pm
Aug 25–27
Register
- SQL Level I
  
  Wed, Aug 25, 9:30am–5:15pm
- SQL Level II
  
  Thu, Aug 26, 9:30am–5:15pm
- SQL Level III
  
  Fri, Aug 27, 9:30am–5:15pm

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

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

May 12–27 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Jun 9–11 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Jun 12–26 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Jul 21–23 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Aug 25–27 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Custom Schedule Register circle-arrow-solid

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

Jun 9–11 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Jul 21–23 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Aug 25–27 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Custom Schedule Register circle-arrow-solid

Apr 7–22 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

May 12–27 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Custom Schedule Register circle-arrow-solid

Mar 13–27 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Jun 12–26 Register circle-arrow-solid

SQL Level I

SQL Level II

SQL Level III

Custom Schedule
Register

Mar 13–27
Register

Mar 24–26
Register

Apr 7–22
Register

Apr 28–30
Register

May 12–27
Register

Jun 9–11
Register

Jun 12–26
Register

Jul 21–23
Register

Aug 25–27
Register

Custom Schedule
Register

Mar 24–26
Register

Apr 28–30
Register

Jun 9–11
Register

Jul 21–23
Register

Aug 25–27
Register

Custom Schedule
Register

Apr 7–22
Register

May 12–27
Register

Custom Schedule
Register

Mar 13–27
Register

Jun 12–26
Register