SQL Bootcamp
Hands-on Classes in NYC
- $1075 $915
- 24 Hours
-
PC provided
We provide computers to use during class. This course is available on PC only.
- Small in-person class
-
Free retake
Students may retake the course once within six months if there is an available seat.
- 185 Madison Avenue, NYC
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
Upcoming Class Dates
Customize your own schedule (choose dates at checkout), or choose a preset package track by expanding the dates below.
-
Custom Schedule
-
Aug 24–Sep 8
-
SQL Level I
Sat, Aug 24, 9am–5pm
-
SQL Level II
Sat, Sep 7, 9am–5pm
-
SQL Level III
Sun, Sep 8, 9:30am–5:30pm
-
-
Sep 11–27
-
SQL Level I
Wed, Sep 11, 9am–5pm
-
SQL Level II
Thu, Sep 12, 9am–5pm
-
SQL Level III
Fri, Sep 27, 9am–5pm
-
-
Sep 16–Oct 6
-
SQL Level I
Mon–Tue, Sep 16–17, 5:50–9:20pm
-
SQL Level II
Mon–Tue, Sep 23–24, 5:50–9:20pm
-
SQL Level III
Sun, Oct 6, 9:30am–5:30pm
-
-
Sep 22–Oct 6
-
SQL Level I
Sun, Sep 22, 9am–5pm
-
SQL Level II
Sun, Sep 29, 9:30am–5:30pm
-
SQL Level III
Sun, Oct 6, 9:30am–5:30pm
-
-
Sep 25–27
-
SQL Level I
Wed, Sep 25, 9am–5pm
-
SQL Level II
Thu, Sep 26, 9am–5pm
-
SQL Level III
Fri, Sep 27, 9am–5pm
-
-
Oct 10–24
-
SQL Level I
Thu, Oct 10, 9am–5pm
-
SQL Level II
Fri, Oct 11, 9am–5pm
-
SQL Level III
Thu, Oct 24, 9am–5pm
-
-
Oct 16–Nov 9
-
SQL Level I
Wed–Thu, Oct 16–17, 5:50–9:20pm
-
SQL Level II
Wed–Thu, Oct 23–24, 5:50–9:20pm
-
SQL Level III
Sat, Nov 9, 9am–5pm
-
-
Oct 22–24
-
SQL Level I
Tue, Oct 22, 9am–5pm
-
SQL Level II
Wed, Oct 23, 9am–5pm
-
SQL Level III
Thu, Oct 24, 9am–5pm
-
-
Oct 26–Nov 9
-
SQL Level I
Sat, Oct 26, 9am–5pm
-
SQL Level II
Sat, Nov 2, 9am–5pm
-
SQL Level III
Sat, Nov 9, 9am–5pm
-
-
Nov 4–22
-
SQL Level I
Mon, Nov 4, 9am–5pm
-
SQL Level II
Tue, Nov 5, 9am–5pm
-
SQL Level III
Fri, Nov 22, 9am–5pm
-
-
Nov 11–Dec 15
-
SQL Level I
Mon–Tue, Nov 11–12, 5:50–9:20pm
-
SQL Level II
Mon–Tue, Nov 18–19, 5:50–9:20pm
-
SQL Level III
Sun, Dec 15, 9:30am–5:30pm
-
-
Nov 20–22
-
SQL Level I
Wed, Nov 20, 9am–5pm
-
SQL Level II
Thu, Nov 21, 9am–5pm
-
SQL Level III
Fri, Nov 22, 9am–5pm
-
-
Nov 24–Dec 15
-
SQL Level I
Sun, Nov 24, 9:30am–5:30pm
-
SQL Level II
Sun, Dec 8, 9:30am–5:30pm
-
SQL Level III
Sun, Dec 15, 9:30am–5:30pm
-
-
Dec 5–20
-
SQL Level I
Thu, Dec 5, 9am–5pm
-
SQL Level II
Fri, Dec 6, 9am–5pm
-
SQL Level III
Fri, Dec 20, 9am–5pm
-
-
Dec 18–20
-
SQL Level I
Wed, Dec 18, 9am–5pm
-
SQL Level II
Thu, Dec 19, 9am–5pm
-
SQL Level III
Fri, Dec 20, 9am–5pm
-
-
Jan 4–18
-
SQL Level I
Sat, Jan 4, 9am–5pm
-
SQL Level II
Sat, Jan 11, 9am–5pm
-
SQL Level III
Sat, Jan 18, 9am–5pm
-
-
Custom Schedule
-
Sep 11–27
-
SQL Level I
Wed, Sep 11, 9am–5pm
-
SQL Level II
Thu, Sep 12, 9am–5pm
-
SQL Level III
Fri, Sep 27, 9am–5pm
-
-
Sep 25–27
-
SQL Level I
Wed, Sep 25, 9am–5pm
-
SQL Level II
Thu, Sep 26, 9am–5pm
-
SQL Level III
Fri, Sep 27, 9am–5pm
-
-
Oct 10–24
-
SQL Level I
Thu, Oct 10, 9am–5pm
-
SQL Level II
Fri, Oct 11, 9am–5pm
-
SQL Level III
Thu, Oct 24, 9am–5pm
-
-
Oct 22–24
-
SQL Level I
Tue, Oct 22, 9am–5pm
-
SQL Level II
Wed, Oct 23, 9am–5pm
-
SQL Level III
Thu, Oct 24, 9am–5pm
-
-
Nov 4–22
-
SQL Level I
Mon, Nov 4, 9am–5pm
-
SQL Level II
Tue, Nov 5, 9am–5pm
-
SQL Level III
Fri, Nov 22, 9am–5pm
-
-
Nov 20–22
-
SQL Level I
Wed, Nov 20, 9am–5pm
-
SQL Level II
Thu, Nov 21, 9am–5pm
-
SQL Level III
Fri, Nov 22, 9am–5pm
-
-
Dec 5–20
-
SQL Level I
Thu, Dec 5, 9am–5pm
-
SQL Level II
Fri, Dec 6, 9am–5pm
-
SQL Level III
Fri, Dec 20, 9am–5pm
-
-
Dec 18–20
-
SQL Level I
Wed, Dec 18, 9am–5pm
-
SQL Level II
Thu, Dec 19, 9am–5pm
-
SQL Level III
Fri, Dec 20, 9am–5pm
-
-
Custom Schedule
-
Sep 16–Oct 6
-
SQL Level I
Mon–Tue, Sep 16–17, 5:50–9:20pm
-
SQL Level II
Mon–Tue, Sep 23–24, 5:50–9:20pm
-
SQL Level III
Sun, Oct 6, 9:30am–5:30pm
-
-
Oct 16–Nov 9
-
SQL Level I
Wed–Thu, Oct 16–17, 5:50–9:20pm
-
SQL Level II
Wed–Thu, Oct 23–24, 5:50–9:20pm
-
SQL Level III
Sat, Nov 9, 9am–5pm
-
-
Nov 11–Dec 15
-
SQL Level I
Mon–Tue, Nov 11–12, 5:50–9:20pm
-
SQL Level II
Mon–Tue, Nov 18–19, 5:50–9:20pm
-
SQL Level III
Sun, Dec 15, 9:30am–5:30pm
-
-
Custom Schedule
-
Aug 24–Sep 8
-
SQL Level I
Sat, Aug 24, 9am–5pm
-
SQL Level II
Sat, Sep 7, 9am–5pm
-
SQL Level III
Sun, Sep 8, 9:30am–5:30pm
-
-
Sep 22–Oct 6
-
SQL Level I
Sun, Sep 22, 9am–5pm
-
SQL Level II
Sun, Sep 29, 9:30am–5:30pm
-
SQL Level III
Sun, Oct 6, 9:30am–5:30pm
-
-
Oct 26–Nov 9
-
SQL Level I
Sat, Oct 26, 9am–5pm
-
SQL Level II
Sat, Nov 2, 9am–5pm
-
SQL Level III
Sat, Nov 9, 9am–5pm
-
-
Nov 24–Dec 15
-
SQL Level I
Sun, Nov 24, 9:30am–5:30pm
-
SQL Level II
Sun, Dec 8, 9:30am–5:30pm
-
SQL Level III
Sun, Dec 15, 9:30am–5:30pm
-
-
Jan 4–18
-
SQL Level I
Sat, Jan 4, 9am–5pm
-
SQL Level II
Sat, Jan 11, 9am–5pm
-
SQL Level III
Sat, Jan 18, 9am–5pm
-
Looking for corporate training?
We offer custom onsite training and discounted class vouchers.
The SQL Bootcamp Includes
SQL Level I
SQL Level II
SQL Level III
Full Course Syllabus
Download PDF OutlineSQL 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