SQL Bootcamp

Hands-on Classes in NYC

  • tag-solid $1075 $915
  • clock-solid 24 Hours
  • display-solid PC provided help-solid
  • users-solid Small in-person class
  • repeat-line Free retake help-solid
  • map-marker-solid 185 Madison Avenue, NYC
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
     

Upcoming Class Dates help-solid

  • Custom Schedule

  • Jan 26–Feb 23

    • SQL Level I

      Sun, Jan 26, 9:30am–5:30pm

    • SQL Level II

      Sun, Feb 9, 9:30am–5:30pm

    • SQL Level III

      Sun, Feb 23, 9:30am–5:30pm

  • Jan 27–Mar 6

    • SQL Level I

      Mon, Jan 27, 9am–5pm

    • SQL Level II

      Mon, Feb 10, 9am–5pm

    • SQL Level III

      Fri, Mar 6, 9am–5pm

  • Jan 27–Feb 11

    • SQL Level I

      Mon, Jan 27, 9am–5pm

    • SQL Level II

      Tue, Jan 28, 9am–5pm

    • SQL Level III

      Tue, Feb 11, 9am–5pm

  • Jan 27–Feb 23

    • SQL Level I

      Mon–Tue, Jan 27–28, 5:50–9:20pm

    • SQL Level II

      Wed–Thu, Jan 29–30, 5:50–9:20pm

    • SQL Level III

      Sun, Feb 23, 9:30am–5:30pm

  • Jan 27–Mar 21

    • SQL Level I

      Mon–Tue, Jan 27–28, 5:50–9:20pm

    • SQL Level II

      Mon–Tue, Feb 24–25, 5:50–9:20pm

    • SQL Level III

      Sat, Mar 21, 9am–5pm

  • Feb 7–Mar 6

    • SQL Level I

      Fri, Feb 7, 9am–5pm

    • SQL Level II

      Fri, Feb 21, 9am–5pm

    • SQL Level III

      Fri, Mar 6, 9am–5pm

  • Feb 7–11

    • SQL Level I

      Fri, Feb 7, 9am–5pm

    • SQL Level II

      Mon, Feb 10, 9am–5pm

    • SQL Level III

      Tue, Feb 11, 9am–5pm

  • Feb 20–Mar 6

    • SQL Level I

      Thu, Feb 20, 9am–5pm

    • SQL Level II

      Thu, Mar 5, 9am–5pm

    • SQL Level III

      Fri, Mar 6, 9am–5pm

  • Feb 20–Mar 6

    • SQL Level I

      Thu, Feb 20, 9am–5pm

    • SQL Level II

      Fri, Feb 21, 9am–5pm

    • SQL Level III

      Fri, Mar 6, 9am–5pm

  • Feb 22–Mar 21

    • SQL Level I

      Sat, Feb 22, 9am–5pm

    • SQL Level II

      Sat, Mar 7, 9am–5pm

    • SQL Level III

      Sat, Mar 21, 9am–5pm

Show more dates angle-line
Corporate training classroom
Career Centers teacher helping a student

Looking for corporate training?

We offer custom onsite training and discounted class vouchers.

envelope-solid nyc@careercenters.com
phone-handset-solid 212 • 684 • 5151
file-group-solid Download Syllabus

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

file-group-solid 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