Have a question for the event organizer?
Send your message below!
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.
| Provider | |
| Location | 185 Madison Ave, New York |
| Price | Starting at $1,800 (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.
General Notes
- After you book the event, we will send you a confirmation email and details for the event.
- For events with materials, we will then collect the addresses of each of the participants and ensure every individual is sent a kit.
- Our event fulfillment team will be able to answer any questions you have before, during, or after the event.
- You can customize your event for a $300 customization fee. Customizations include things like combining different games, requesting specific questions or a themed game, or adding something to an event with materials included. Using a different platform that is not Zoom is not a customization.
- Get a Demo: Not convinced? Book a 20-minute demo of this event for $25 before committing to it for your group. Your payment will apply towards your final purchase.
Supported Platforms for Virtual Events: Zoom is our recommended platform, but we can accommodate Google Meets, Microsoft Teams, and WebEx if the client provides the meeting details.
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!
Price Match Guarantee
If you find a similar event with a competitor at a lower price, we’ll gladly match it. This applies to events of comparable description and duration. Simply provide the details when booking, or within 72 hours of your booking, and we’ll ensure you get the best value. Contact an event concierge to get started.
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.