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.
Small classes
Computer provided
Book included
Free retake
Register for a Package
Customize your own schedule (choose dates at checkout), or choose a preset package track by expanding the start dates below.
Custom Schedule
May 1
SQL Level I
Wed–Thu, May 1–2, 5:50–9:20pm
SQL Level II
Wed–Thu, May 8–9, 5:50–9:20pm
SQL Level III
Sun, Jun 16, 9:30am–5:30pm
May 2
SQL Level I
Thu, May 2, 9am–5pm
SQL Level II
Fri, May 3, 9am–5pm
SQL Level III
Mon, May 20, 9am–5pm
May 4
SQL Level I
Sat, May 4, 9am–5pm
SQL Level II
Sat, May 11, 9am–5pm
SQL Level III
Sat, May 18, 9am–5pm
May 16
SQL Level I
Thu, May 16, 9am–5pm
SQL Level II
Fri, May 17, 9am–5pm
SQL Level III
Sat, May 18, 9am–5pm
May 16
SQL Level I
Thu, May 16, 9am–5pm
SQL Level II
Fri, May 17, 9am–5pm
SQL Level III
Mon, May 20, 9am–5pm
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
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!