SQL Bootcamp New York

Master SQL for Databases in Classroom Training

This three-day bootcamp guides beginners into confident SQL users that can write queries, manipulate tables and store advanced code.

Start by learning relational database and SQL fundamentals and compose basic queries. Create views, subqueries and conversion functions. By the end, you will create your own SQL database, import and export data from Microsoft Office applications and automate workflow with stored procedures.

Our SQL classes include simple, systematic, step-by-step tasks that will teach you everything you need to know in the most efficient, thorough approach. You’ll go from basic data query and retrieval tasks to joining SQL tables and storing complex SQL code for later use. Reference the bootcamp materials with our custom guides, and retake the course for free within six months if you need a refresher. 

This SQL Bootcamp package includes our Beginner, Intermediate, and Advanced SQL classes at a 15% discount.

  • icon for small classesSmall classes
  • icon for small classesComputer provided
  • icon for small classesBook included
  • icon for small classesFree retake

Register for a Package  help-solid

tag-solid $1075$915 clock-solid 24 Hours display-solid PC provided help-line map-marker-solid 185 Madison Avenue, NYC users-solid In-person classroom training

Corporate training available

Email us for information

  • Custom Schedule

  • Oct 22–24

    • SQL Level I

      Tuesday, Oct 22, 9am–5pm

    • SQL Level II

      Wednesday, Oct 23, 9am–5pm

    • SQL Level III

      Thursday, Oct 24, 9am–5pm

  • Oct 26–Nov 9

    • SQL Level I

      Saturday, Oct 26, 9am–5pm

    • SQL Level II

      Saturday, Nov 2, 9am–5pm

    • SQL Level III

      Saturday, Nov 9, 9am–5pm

  • Nov 4–22

    • SQL Level I

      Monday, Nov 4, 9am–5pm

    • SQL Level II

      Tuesday, Nov 5, 9am–5pm

    • SQL Level III

      Friday, 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

      Sunday, Dec 15, 9:30am–5:30pm

  • Nov 20–22

    • SQL Level I

      Wednesday, Nov 20, 9am–5pm

    • SQL Level II

      Thursday, Nov 21, 9am–5pm

    • SQL Level III

      Friday, Nov 22, 9am–5pm

Show more dates angle-line

The SQL Bootcamp includes

SQL Level I

Learn how SQL is used within relational database management systems. Connect to SQL Server and write queries with conditions. Use functions to calculate and format data before it’s presented on screen. In SQL Level 1, you’ll learn everything you need to write SQL queries on your own.

SQL Level II

Master views, subqueries, logic statements, and data conversions in SQL Level 2. Combine advanced SQL functions with fundamentals like inner and outer joins to proof your work. Develop your skills in SQL by writing advanced functions to gain more control in your relational DBMS (Database Management System).

SQL Level III

Master advanced SQL processes and controls. Create stored procedures and temporary tables. Connect to external data sources like Microsoft Applications applications and manipulate data with constraints, indexes, and triggers. In SQL 3, you’ll gain the skills to begin a career in database management.

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

SQL Bootcamp in NYC

Who is the SQL Bootcamp for?

The SQL Bootcamp is for you if:

  • You are new to SQL or need a refresher on SQL concepts
  • You are comfortable learning a lot of information quickly
  • You want to use SQL to store data or gather insights

Start with Queries and Retrieval Commands

SQL Level 1 is perfect for beginners who are new to SQL and using databases. Begin with instruction in the fundamentals of relational databases. In this hands-on class, beginners will become familiar with basic SQL commands and the Microsoft SQL Server DBMS (Database Management System).

Increase Your Knowledge with Views, Subqueries, and Advanced Functions

Students in SQL Level 2 will expand their knowledge of SQL and SQL server with advanced functions and table operations. Students will learn to manipulate and index tables using a variety of SQL commands. In addition, students will apply logic, date and conversion functions to data.

Use Stored Procedures to Automatic Tasks and Trigger Events

In SQL Level 3, students will create their own SQL database by using SQL code to store data. You will also learn how to import data from other sources, including Microsoft Office applications Microsoft Access and Excel. Finally, you will learn how to automate your workflow by saving SQL code to use later and creating automatic triggers for events.

SQL Bootcamp Program Benefits

  • Frequent Courses and Flexible Scheduling
  • Learn Practical applications of SQL
  • Live instructors with real-world experience
  • Retake the course within six months
  • Training manual with step-by-step instruction
  • Receive personalized attention in our small classes

Frequent Courses and Flexible Scheduling

Our SQL courses are offered each week at a variety of times to suit your schedule. Motivated learners can complete the entire 24-hour SQL bootcamp in one weekend. We also offer weekday and weeknight classes to accommodate any schedule. Purchase a package and choose the dates that are most convenient for you!

Engaging Instructors

NYIM instructors are real-world professionals with practical experience using the programs they teach in the real world. Your SQL instructor will patiently guide you through database concepts, SQL Server, and using SQL commands. Throughout the course, your instructor is available to answer and clarify questions and can provide support as you work through practice tasks.

Custom SQL Workbook

All of your class materials are including with your training fee! From our state-of-the-art computer lab with Macs and PCs to custom training workbooks, we’ve got everything you need! Our course manual is developed by our instructors and designed to guide you through each class exercise, step-by-step.

Small Classes and Personalized Attention

At NYIM, our classes are small, and you’ll have the opportunity to get your questions answered in class. Students will also end each SQL Level class with practice exercises to apply their skills firsthand. Instructors are available throughout the lesson to provide additional clarification or help with practice exercises.

Register for NYC’s Top SQL Bootcamp at NYIM!

At NYIM, our SQL bootcamp includes everything you need from course materials to a computer and necessary software for one affordable fee. Over two decades, we’ve developed a proven instructional model that includes project-based tasks with real-world applications and customized training materials. Secure your spot in our SQL bootcamp in NYC today!