Have a question for the event organizer?
Send your message below!
NYC: SQL Corporate Training
Master SQL Server through hands-on training that teaches you to write powerful queries and extract actionable insights from databases. In this group class, you'll learn to join tables, filter data, and apply advanced techniques that transform raw information into business intelligence for smarter decision-making.
| Provider | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Location | 185 Madison Ave, New York | |||||||||||||||
| Pricing |
$1,800 for up to 20 people
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! |
|||||||||||||||
| Duration |
Up to 7 hours For a shortened session, please request desired length in special requests at checkout.
|
|||||||||||||||
| Group Size |
Up to 20 people Group size can be changed after booking if needed.
|
|||||||||||||||
| Materials | None required | |||||||||||||||
| Other |
General Notes
Supported Platforms for Virtual Events: Zoom is our recommended platform, but we can accommodate Google Meets, Microsoft Teams, and WebEx if you provide the meeting link to CourseHorse in advance of the event. PoliciesPrice Match GuaranteeIf 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 PolicyReschedule or cancel your event by emailing us at [email protected].
Rescheduled events must occur within 1 year of the original event. |
|||||||||||||||
Description
Learn Microsoft SQL Server through hands-on queries that join tables, aggregate values and filter results.
Start with database tables, columns and rows, then write queries to retrieve, filter and group data. Learn joins, aggregate functions, subqueries, function parameters and reusable stored procedures.
Explore databases and run queries in Microsoft SQL Server and the free SQL Server Management Studio. The concepts transfer to PostgreSQL, Microsoft Access and MySQL with syntax adjustments.
Why SQL Proficiency Matters
Use SQL to answer questions with organizational data and support business decisions.
SQL supports business analysis, data analysis and science, web development and other roles that work with databases.
What You Will Learn
- Database exploration using SQL Server Management Studio graphical tools to examine tables, columns, and row contents
- SQL query composition for precise data retrieval from database tables
- Multiple table information combination using JOIN statement syntax
- Data filtering, organization, and sorting to extract the required information
- Advanced capabilities, including Subqueries, String manipulation functions, IF-Else conditional logic through CASE statements
- Views and parameterized Functions as alternatives to direct table queries
Course Curriculum Structure
Unit 1: SQL Level I
- Database exploration utilizing SQL Server Management Studio interface
- SQL query composition for database table data retrieval
- Primary SQL clauses: SELECT and FROM fundamentals
- Result filtering using WHERE, AND/OR, IN, and NOT operators
- Wildcard filtering patterns and mathematical comparisons
- Multiple table information combination using inner JOIN operations
Unit 2: SQL Level II
- Outer Join techniques and NULL data identification
- Data grouping and statistical calculation using Aggregate Functions
- Grouped data filtering with the HAVING clause
- CAST functionality for data type conversion
- Date and time data handling
Unit 3: SQL Level III
- Subquery implementation for retrieving and utilizing data from multiple query levels
- View-based queries as database abstraction layer
- If-Else logic implementation through CASE statements
- Function creation and reusable Stored Procedure execution
- String Functions for text manipulation and extraction
Corporate Training Solutions
Flexible Voucher and Group Class Options
Group training vouchers let employees choose classes throughout the week, live online or at our Manhattan locations. Large purchases include a registration tracking portal.
Employees choose classes by skill level, schedule and location without coordinating a single group time.
Industry-Expert Instruction
Keep all course materials for ongoing reference and practice at work.
Hands-on instruction uses realistic workplace challenges and accommodates different learning preferences.
Private curricula can be customized for your office, our Midtown Manhattan facilities or live online delivery.