SQL Bootcamp

Hands-on Classes in NYC

  • tag-solid $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 SQL training bootcamp

This SQL Bootcamp package includes our Beginner, Intermediate, and Advanced SQL classes at a 15% discount. In this bootcamp, you will use SQL as a tool to implement logic, define instructions and compose queries. You will create advanced queries and manipulate and index tables, and learn techniques for writing decision-making code using advanced functions.

SQL Bootcamp Classes

In our beginner SQL class, you will connect to the SQL Server database and execute a simple query, use various functions based on data types, organize the query data, retrieve data by combining data from multiple tables, and generate reports from the output.

In our intermediate SQL class, you will code subqueries to generate query output, manipulate table data, create tables, create views and manipulate data through views, and create indexes on table columns.

In our advanced SQL class, you will utilize 'Case When Then' statements, format and covert numeric data, work with text data, use stored procedures, and create local and global Temporary Tables.

Upcoming Class Dates help-solid

  • Custom Schedule

  • Jun 18–21

    • SQL Level I

      Tue, Jun 18, 9am–5pm

    • SQL Level II

      Thu, Jun 20, 9am–5pm

    • SQL Level III

      Fri, Jun 21, 9am–5pm

  • Jun 24–Jul 20

    • SQL Level I

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

    • SQL Level II

      Mon–Tue, Jul 1–2, 5:50–9:20pm

    • SQL Level III

      Sat, Jul 20, 9am–5pm

  • Jun 29–Jul 20

    • SQL Level I

      Sat, Jun 29, 9am–5pm

    • SQL Level II

      Sat, Jul 13, 9am–5pm

    • SQL Level III

      Sat, Jul 20, 9am–5pm

  • Jul 8–26

    • SQL Level I

      Mon, Jul 8, 9am–5pm

    • SQL Level II

      Tue, Jul 9, 9am–5pm

    • SQL Level III

      Fri, Jul 26, 9am–5pm

  • Jul 22–Aug 11

    • SQL Level I

      Mon–Tue, Jul 22–23, 5:50–9:20pm

    • SQL Level II

      Wed–Thu, Jul 24–25, 5:50–9:20pm

    • SQL Level III

      Sun, Aug 11, 9:30am–5:30pm

  • Jul 24–26

    • SQL Level I

      Wed, Jul 24, 9am–5pm

    • SQL Level II

      Thu, Jul 25, 9am–5pm

    • SQL Level III

      Fri, Jul 26, 9am–5pm

  • Jul 28–Aug 11

    • SQL Level I

      Sun, Jul 28, 9am–5pm

    • SQL Level II

      Sun, Aug 4, 9am–5pm

    • SQL Level III

      Sun, Aug 11, 9:30am–5:30pm

  • Aug 5–29

    • SQL Level I

      Mon, Aug 5, 9am–5pm

    • SQL Level II

      Tue, Aug 6, 9am–5pm

    • SQL Level III

      Thu, Aug 29, 9am–5pm

  • Aug 15–29

    • SQL Level I

      Thu, Aug 15, 9am–5pm

    • SQL Level II

      Fri, Aug 16, 9am–5pm

    • SQL Level III

      Thu, Aug 29, 9am–5pm

  • Aug 21–Sep 7

    • SQL Level I

      Wed–Thu, Aug 21–22, 5:50–9:20pm

    • SQL Level II

      Wed–Thu, Aug 28–29, 5:50–9:20pm

    • SQL Level III

      Sat, Sep 7, 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

Use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database.

SQL Level II

Create advanced SQL queries, and manipulate and index tables. Course Objective: You will work with advanced queries and manipulate tables. You will also view and index table data.

SQL Level III

Learn techniques for writing decision making code, using advanced functions for manipulating text, using data conversion functions and formatting output to make data more comprehensible. You will also explore temporary tables, parameterized queries and creating Stored Procedures to automate work flow.

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