Discover Classes. Earn Rewards.

SQL Bootcamp

at NYC Career Centers - Midtown

Master the art of extracting actionable insights from databases with the SQL Bootcamp at NYC Career Centers. Learn Microsoft SQL Server, join tables, aggregate data, and filter results in this hands-on course. Gain the skills needed to turn raw data into valuable insights for decision-making in any industry.

Course Details
Price $975
Start Date

Sat, Mar 09, 10:00am - Mar 23, 5:00pm Eastern Time ( 3 sessions )
Next start dates ( 7)

20 seats left Need more seats? See group options for 8+

Location Midtown, Manhattan
185 Madison Ave Suite 1104
At E 34th St
New York, New York 10016
(Map)
Important
Class Level All levels
Age Requirements 18 and older
Average Class Size 7
Purchase Options
Book at School
Or
Book Now

No Booking Fees. Lowest Price Guaranteed. Earn Rewards.

Give as a Gift Save to WishList

1 person wishlisted

Start Dates (8)

Career Centers
185 Madison Ave, New York, NY
TBD
$975
Book
Show all 3 sessions
  • Mon, Feb 26 at 10:00am - 5:00pm
  • Tue, Feb 27 at 10:00am - 5:00pm
  • Wed, Feb 28 at 10:00am - 5:00pm
Career Centers
185 Madison Ave, New York, NY
TBD
$975
Book
Show all 3 sessions
  • Sat, Mar 09 at 10:00am - 5:00pm
  • Sat, Mar 16 at 10:00am - 5:00pm
  • Sat, Mar 23 at 10:00am - 5:00pm
Career Centers
185 Madison Ave, New York, NY
TBD
$975
Book
Show all 3 sessions
  • Mon, Mar 11 at 10:00am - 5:00pm
  • Tue, Mar 12 at 10:00am - 5:00pm
  • Wed, Mar 13 at 10:00am - 5:00pm
Career Centers
185 Madison Ave, New York, NY
TBD
$975
Book
Show all 6 sessions
  • Wed, Mar 27 at 6:00pm - 9:00pm
  • Mon, Apr 01 at 6:00pm - 9:00pm
  • Wed, Apr 03 at 6:00pm - 9:00pm
  • Mon, Apr 08 at 6:00pm - 9:00pm
  • Wed, Apr 10 at 6:00pm - 9:00pm
  • Mon, Apr 15 at 6:00pm - 9:00pm
Career Centers
185 Madison Ave, New York, NY
TBD
$975
Book
Show all 3 sessions
  • Tue, Apr 30 at 10:00am - 5:00pm
  • Wed, May 01 at 10:00am - 5:00pm
  • Thu, May 02 at 10:00am - 5:00pm
Career Centers
185 Madison Ave, New York, NY
TBD
$975
Book
Show all 3 sessions
  • Mon, Jun 10 at 10:00am - 5:00pm
  • Tue, Jun 11 at 10:00am - 5:00pm
  • Wed, Jun 12 at 10:00am - 5:00pm
Career Centers
185 Madison Ave, New York, NY
TBD
$975
Book
Show all 6 sessions
  • Thu, Jul 25 at 6:00pm - 9:00pm
  • Tue, Jul 30 at 6:00pm - 9:00pm
  • Thu, Aug 01 at 6:00pm - 9:00pm
  • Tue, Aug 06 at 6:00pm - 9:00pm
  • Thu, Aug 08 at 6:00pm - 9:00pm
  • Tue, Aug 13 at 6:00pm - 9:00pm
Career Centers
185 Madison Ave, New York, NY
TBD
$975
Book
Show all 3 sessions
  • Mon, Aug 12 at 10:00am - 5:00pm
  • Tue, Aug 13 at 10:00am - 5:00pm
  • Wed, Aug 14 at 10:00am - 5:00pm
Save to WishList Purchase a Gift Card

Class Description

Description

What you'll learn in this sql server training:

Learn Microsoft SQL Server to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering the results. Extract actionable insights from data sets in this hands-on training.

Turn the information in databases into useful insights by writing SQL queries. Once you understand the basics of viewing tables, columns, and rows, you’ll learn how to code queries to extract the specific information you want.

Learn how to filter the data, group it, and turn raw data into insights. Combine information from multiple tables using join statements. You’ll also learn more advanced techniques like aggregate functions and subqueries, as well as how to use functions with parameters and stored procedures.

In this hands-on course you’ll learn Microsoft SQL Server and the free SQL Server Management Studio app (SSMS) to explore the database and execute SQL queries you write. The concepts you’ll learn on SQL Server can be applied to other flavors of SQL (such as PostgreSQL, Microsoft Access, MySQL, etc.) with minor syntax differences.

This SQL Server Bootcamp is our SQL Level 1, 2, and 3 classes combined into a single comprehensive course.

Why Learn SQL?
With SQL you can answer questions from information stored in a database (the ultimate system of storing data for most companies). As nearly every industry is becoming more data-driven, having this skill will give you a larger role in decision-making wherever you work.

SQL is vital to anyone in business or any job that involves working with data: business analysts, data analysts, data scientists, web developers, business people, and many others.

Learn more about SQL Bootcamp at NYC Career Centers.


Syllabus

Foundations of SQL & Databases

SQL Fundamental Concepts

  • What is SQL & why is it used?
  • Flavors of SQL: Postgres vs SQL Server, etc.
  • Database Tables, Rows, & Columns
  • Using ER (Entity Relationship) Diagrams to visual what’s in a database

Exploring Databases & Writing SQL Statements (using the free DBeaver app)

  • Connecting to a Database
  • Database Navigator
  • SQL Query Editor
  • Using Code Hints
  • Viewing the Results of your SQL query
  • Setting Preferences

Writing SQL Queries

Writing SELECT Statements

  • Syntax of a SELECT statement
  • Selecting all columns or specific columns from a table
  • Limiting the number of results using LIMIT
  • Ordering the results using ORDER BY
  • Returning only DISTINCT records (eliminating duplicates)

Filtering Results

  • Data Types (Strings vs Numbers)
  • Comparison Operators: equal to, greater or less than, not equal to, etc.
  • Filtering results using WHERE, AND, OR, IN, and NOT
  • Pattern Matching: Wildcard Filters
  • Case Sensitivity

Using Joins to Combine Data from Multiple Tables

Understanding Table Relationships

  • What are Primary vs Primary Keys
  • Database Relations: One-to-One, One-to-Many, & Many-to-Many

Inner Joins

  • The difference between Inner & Outer Joins
  • Inner Joins
  • Column & Table Aliases

Outer Joins & Finding NULLs

  • Left Join
  • Right Join
  • Full Join
  • Find NULL values

Manipulating, Aggregating, & Filtering Data

Using CAST to Change Data Types

  • Why and how to use CAST to make a data type fit your query’s needs

Aggregate Functions

  • Using Aggregate Functions to perform common statistical calculations
  • Using SUM, COUNT, AVG, MAX & MIN

Working with Dates & Time

  • Date Functions: Getting the desired part of a date/time (Year, Month, Day, etc.)
  • Formatting dates, including the day of the week (Sunday, Monday, etc.)
  • Calculating the difference between 2 dates

Grouping Data & Filtering Grouped Data

Grouping Data with Aggregate Functions

  • Using GROUP BY to organize results into categories
  • Applying Aggregate Functions to groups

Filtering Grouped Data with HAVING

  • Using HAVING to filter the results of a GROUP BY
  • HAVING vs WHERE

Advanced Query Techniques

Subqueries

  • Subqueries: Queries within queries
  • Single-Value vs Multi-Value vs Table-Value Subqueries

Aggregate Window Functions

  • Using OVER and PARTITION BY to apply Aggregate Functions

Conditionals with CASE

  • Adding If-Else Logic with CASE
  • Simple CASE vs Searched CASE

String Functions

  • Manipulating text using string functions
  • Using SUBSTRING, SPLIT_PART, UPPER, etc.

Self Join

  • How a Self Join is different from other types of joins
  • Using a Self Join

Views & User-Defined Functions

Views

  • What are Views?
  • The Advantages & Disadvantages of using Views
  • How to Use & Query a View

Materialized Views

  • The difference between regular Views and Materialized Views

User-Defined Functions

  • Using Scalar-Value (Single-Value) Functions
  • Using Table-Value Functions

Refund Policy

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
  • Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYC Career Centers (679)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

School: NYC Career Centers

NYC Career Centers

Since 1988, Career Centers has been a leader in software training courses for individuals and businesses, including Microsoft Excel, VBA, PowerPoint, SQL Server, Adobe Photoshop, InDesign, Illustrator, and AutoCAD.

Our courses are instructor-led in small class sizes, located in our state-of-the-art training...

Read more about NYC Career Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

NYC Career Centers

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

Google Map
Ready to take this class?
BOOK NOW

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Choose from thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...