(212) 684-5151

SQL Bootcamp
SQL Bootcamp

Price: $915.00

Course Code: SQB | Hours: 24

SQL Bootcamp New York City

Training facility for SQL classes

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 Course Outline

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.

Register for the SQL Bootcamp

Check out by choosing your first class date above (Beginner SQL) for $915, a 15% discount. Then contact us to schedule your next two SQL classes. You can choose any combination of dates that work with your schedule, and if you're not sure yet, no problem. You'll have two years to complete the courses.

Beginner SQL Course Outline | Intermediate SQL Course Outline | Advanced Excel Course Outline

What You'll Learn in this Class:

Prerequisites:

Students should have a basic understanding of Windows, including how to use files and folders.

Related Classes:

See Also:

Prerequisites:

Students should have a basic understanding of Windows, including how to use files and folders.

Related Classes:

See Also:

SQL Bootcamp Course Outline

Beginner SQL

Basic Concepts

• Microsoft SQL Server
• What is SQL?
• What are Relational Databases?

The Graphic User Interface

• Object Explorer
• Query Window
• Options
• Results Grid

The Code

• Basic Clauses
• Field and Table Aliases
• Creative use of Aliases
• Inner and Outer Table Joins
• Self Joins
• Union Joins
• Cross Joins
• Aggregations
• Distinct Records
• Text Criteria & Operators
• Wildcard Filters
• Numeric Criteria & Operators

Student Labs

Intermediate SQL

Saving Queries Programmatically

• Benefits versus Shortcomings
• Views
• Functions
• Stored Procedures
• Layered Views
• Protect Views with Schema binding
• 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

Data Conversion Functions

• String Functions
• Cast Function
• Convert Function
• Rounding Functions

Student Labs

• Creating Views
• Sub Queries
• Advanced Functions
• Logic and Date Functions
• Conversion Functions

Advanced SQL

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

• Setting Up Indexes
• Setting up Referential Integrity
• Creating Database Diagrams

Temporary Tables

• Low Level Security Overview
• Local
• Global

Stored Procedures

• Parameters
• Automation
• Triggers