Limited Time Promotion: FREE $30 CourseHorse Gift Card for each event participant! How it Works

NYC: SQL Corporate Training

Teach your team how to turn database data into actionable insights by writing SQL queries at this SQL corporate training event. This hands-on training will teach your team to extract specific information, filter data, join tables, and use advanced techniques like subqueries and aggregate functions. It will give them the skills to make data-driven decisions and excel in their role.

  • Live professional host
  • Instantly bookable
Provider
CourseHorse Experiences (4.8-star rating across 3,884 reviews)
Location Murray Hill, 185 Madison Ave
Price Starting at $1125  (see price details)
Duration Up to 7 hours
Group Size Up to 20 people
Materials None required
Limited Time Promotion: FREE $30 CourseHorse Gift Card for each event participant! How it Works

Description

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.

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.

What You'll Learn at a Glance

  • Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of SQL Server Management Studio (Microsoft’s free database app)
  • Write SQL queries to retrieve data from tables in a database
  • Combine information from multiple tables with JOIN statements
  • Filter data, group it, and sort it to extract the specific info you need
  • Advanced techniques like Subqueries, String Functions, IF‑Else logic with CASE
  • How to use Views and Functions with parameters instead of directly querying tables

Course Syllabus

Unit 1

  • SQL Level I
    • Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of SQL Server Management Studio (Microsoft’s free database app)
    • Write SQL queries to retrieve data from tables in a database
    • Primary SQL clauses including SELECT and FROM
    • Filtering the results using WHERE, AND/OR, IN, and NOT
    • Wildcard filters as well as mathematical comparisons like equals, greater than, less than, etc.
    • Combine information from multiple tables with inner JOINs

Unit 2

  • SQL Level II
    • Learn to use Outer Joins and find NULL data
    • Group data and perform common statistical calculations using Aggregate Functions
    • Filter grouped data with HAVING
    • Use CAST to make a data type fit your query’s needs
    • Work with dates and time

Unit 3

  • SQL Level III
    • Use Subqueries to grab data from anywhere in a database and use that result in another query
    • Query from Views instead of tables
    • Add If-Else logic to queries using CASE
    • Learn how to use Functions, and execute reusable Stored Procedures
    • Use String Functions to get just the part of text you need

Custom solutions for every team:
Purchase Vouchers or Group Classes
You can purchase group vouchers so your employees can attend any of our courses at their convenience on weeknights, weekdays, or weekends. Our classes are live online or in person at our Manhattan offices. When you invest in a large block of vouchers, you'll also receive a custom registration tracking portal to manage them.

With various courses on our calendar, you don't have to worry about coordinating with each employee to find a class that works for them. Your employees can use their vouchers to enroll in the classes that fit their proficiency, schedule, and location needs.

Learn Relevant Skills from Industry Experts
Your employees will leave our training as proficient users who can implement what they've learned the next day. Your employees will also have our course files to keep forever so they can continue using their training as a guide for their day-to-day tasks.

Our hands-on curriculum and focused instruction cater to every learning style. We simulate the challenges your employees will actually face on the job.

We have extensive experience developing curricula for various training sessions, either onsite at your office, in our Midtown Manhattan offices, or through remote virtual training. Our programs can be completely customized to suit your training needs.

​Additional Note:

  • Schedule includes 1 hour break for lunch.
  • We can host the event in your office within the New York metro area for no additional cost.

Pricing

We're happy to discuss your training needs free of charge. Reach out for a free consultation and let us know which skill your team is interested in, your preferred custom training options, and the approximate number of participants you’ll have so we can create a package for you. Send us an email or give us a call today!

Rescheduling & Cancellation Policy

Reschedule or cancel your event by emailing us at [email protected].

Days before event 3 days or less 7 days or less 30 days or less More than 30 days
Reschedule Days before event: 3 days or less No reschedule allowed 7 days or less $150 fee More than 7 days Reschedule for no fee
Cancellation Days before event: 30 days or less No cancellation allowed More than 30 days 15% fee

Rescheduled events must occur within 1 year of the original event.

Book this Event

Available as soon as next Tuesday, Jul. 30th

Price Details

Your Discount
Total
  • Confirmation within 24 hours
  • All inclusive price
  • No registration required
  • Promo: Free $30 CourseHorse Gift Card for each participant. How it Works

Reviews of This Event

(5.0-star rating across 6 reviews)
Tracy D.
Genghis was AMAZING. He was so clear in his explanations, and especially helpful if you had a specific question. I am in an online bootcamp now and his instruction was fantastic and helped me tremendously. Great format to offer practice SQL exercises, and then review with the instructor.
Andrew Gordon
Instructors at Noble Desktop are devoted to their students!
Anderson Wang
A strong dive in SQL. You'll walk out of this class with a good grasp of database handling. A great professional skill.
Anderson W
A strong dive in SQL. You'll walk out of this class with a good grasp of database handling. A great professional skill.
Anderson W
A strong dive in SQL. You'll walk out of this class with a good grasp of database handling. A great professional skill.
Jason M.
Great introduction to SQL, top notch professor, and great learning materials.

Similar Team Building Activities

NYC: Python for Data Science Corporate Training

NYC: Python for Data Science Corporate Training

Help your team gain expertise in Python programming for data science, from basic statements to machine learning models, at our Python for Data Science Bootcamp. They'll learn how to work with data in Python, create visualizations, and use statistics to develop machine learning models, all while building a solid foundation in team collaboration and problem-solving.

Starting at $1645 Up to 7 hours
NYC: SQL Server Corporate Training

NYC: SQL Server Corporate Training

Unleash the power of data with our comprehensive SQL Server Bootcamp. Your team will learn how to extract valuable insights from databases, join tables, filter data, and more, empowering them to make data-driven decisions and enhancing their collaboration and problem-solving skills.

Starting at $1125
NYC: Data Analytics Corporate Training

NYC: Data Analytics Corporate Training

Introduce your team to data analytics and statistical analysis fundamentals at this beginner-friendly event. Discover how to use data for decision-making and explore the role of Big Data in today's business world, all while building valuable team skills.

Starting at $745 Up to 7 hours
NYC: Python Fundamentals Corporate Training

NYC: Python Fundamentals Corporate Training

Teach your team Python, a powerful programming language, in this beginner course that covers the fundamentals and includes hands-on web and data science projects. They'll gain confidence and practical skills to solve real-life problems while enjoying customized solutions and learning from industry experts.

Starting at $475 Up to 7 hours
NYC: Power BI Corporate Training

NYC: Power BI Corporate Training

Our comprehensive Power BI training will improve your team's data analysis skills. They'll learn how to connect multiple data sources, create compelling dashboards, and solve pressing data issues while gaining hands-on experience from industry experts.

Starting at $749
NYC: Machine Learning Corporate Training

NYC: Machine Learning Corporate Training

Give your team the practical skills needed to solve real-world problems with machine learning in this professional development corporate training event. Gain hands-on experience with popular algorithms and learn how to measure accuracy and choose effective features. Perfect for team building and advancing your knowledge in this high-demand field.

Starting at $2045
NYC: R for Data Analytics Corporate Training

NYC: R for Data Analytics Corporate Training

Teach your team the skills and knowledge needed to manage and make sense of the abundance of data in today's digital environment. From the fundamentals of coding to hands-on projects and custom solutions for teams, this course will equip them with the tools for success in data management.

Starting at $1645 Up to 7 hours
NYC: Intermediate Excel Corporate Training

NYC: Intermediate Excel Corporate Training

Join us for an intermediate Excel class where your team will learn essential functions like VLOOKUP and Pivot Tables, allowing them to streamline data analysis and enhance their productivity. With customizable solutions for every team, our industry experts will provide hands-on training that will equip your employees with relevant skills to apply immediately.

Starting at $399