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

  • 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 4–20

    • SQL Level I

      Wed, Dec 4, 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 2–16

    • SQL Level I

      Thu, Jan 2, 9am–5pm

    • SQL Level II

      Fri, Jan 3, 9am–5pm

    • SQL Level III

      Thu, Jan 16, 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

Show more dates angle-line

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