Discover Classes. Earn 10% Rewards.

SQL Querying - Level 1 Fundamentals of Querying is unfortunately unavailable

Thankfully we have 12 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.

SQL Bootcamp

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Build expertise in turning raw data into actionable insights with SQL queries. The hands-on course teaches how to filter, group, and join data, plus advanced techniques such as subqueries and aggregate functions. Develop the skills to thrive in any data-driven industry and make more informed decisions.

(452) All levels 18 and older
$975

3 sessions

Gift it!

Data Analytics Technologies Bootcamp

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Through this course, students build mastery in Excel, SQL, and Tableau, some of the top data analytics tools. Students develop the skills to organize, analyze, summarize, and visualize data, presenting actionable insights for effective decision-making. Comprehensive classroom training in Midtown Manhattan.

(452) All levels 18 and older
$1,949

8 sessions

Gift it!

SQL Level 2

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Sharpen your SQL skills by mastering outer joins, NULL data, grouping, aggregate functions, filtering, and working with dates/times. Pull and analyze specific data from databases, turning raw information into valuable insight. Prerequisite: SQL proficiency equivalent to Noble Desktop's SQL Level 1 course.

(452) Intermediate 18 and older

SQL Level 1

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Unlock the power of SQL and relational databases in this comprehensive course. Learn how to write SQL queries, filter results, and join data across multiple tables, all while building a strong foundation in database architecture. Master the fundamentals of SQL at Noble Desktop.

(452) Beginner 18 and older

SQL Level 3

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Push your SQL skills further in this advanced course at Noble Desktop. Learn how to use subqueries, views, functions, stored procedures, and more to manipulate and analyze data in databases. Pick up in-depth techniques that prep you for a role in data analysis or data science.

(452) Advanced 18 and older
See all SQL classes NYC

SQL Querying - Level 1 Fundamentals of Querying

  • Beginner
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 462 Seventh Ave, New York, NY

Start Dates (0) $395/person

  • These classes sell out faster than we update our systems. Enroll and we'll confirm your spot.

No upcoming dates are currently available.

Book a Private Group Event

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

Or see all Data Analytics Group Events

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

Class Description

Description

In this course, students will compose SQL queries to retrieve desired information from a database.

​Who Should Attend
Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Prerequisite(s) or equivalent knowledge
  • Access 2003 - Level 1
  • Relational Database Design A Practical Approach

Outline

Lesson 1: Executing a Simple Query
  • Connect to the SQL Database 
  •  Query a Database 
  •  Save a Query 
  •  Modify a Query 
  •  Execute a Saved Query 
Lesson 2: Performing a Conditional Search
  •  Search Using a Simple Condition 
  •  Compare Column Values 
  •  Search Using Multiple Conditions 
  •  Search for a Range of Values and Null Values 
  •  Retrieve Data Based on Patterns 
Lesson 3: Working with Functions
  •  Perform Date Calculations 
  •  Calculate Data Using Aggregate Functions 
  •  Manipulate String Values
Lesson 4: Organizing Data
  •  Sort Data 
  •  Rank Data 
  •  Group Data 
  •  Filter Grouped Data 
  •  Summarize Grouped Data 
  •  Use PIVOT and UNPIVOT Operators
Lesson 5: Retrieving Data from Tables
  •  Combine Results of Two Queries 
  •  Compare the Results of Two Queries 
  •  Retrieve Data by Joining Tables 
  •  Check for Unmatched Records 
  •  Retrieve Information from a Single Table Using Joins
Lesson 6: Presenting Query Results
  •  Save the Query Result 
  •  Generate an XML Report

Refund Policy

Please notify us at [email protected]

  • 7 or more business days in advance of your scheduled class if you need to cancel your reservation for applications classes.
  • 12 or more business days for technical classes.
You will receive a 95% refund if you cancel according to the terms above for applications and technical classes.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

Reviews of Classes at New Horizons Computer Learning (8)

Similar Classes

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 3950 points. Earn 10% back in reward points!

New Horizons Computer Learning

New Horizons Computer Learning Center, part of the world’s largest independent IT training provider, offers flexible learning options from instructor-led and online courses to customized corporate training. With programs ranging from Microsoft Office to advanced Cisco and Citrix certifications, New Horizons equips individuals, businesses, and government agencies with the skills to succeed in today’s technology-driven world.

View school profile
New Horizons Computer Learning
Vetted by CourseHorse

A verified NYC educator.

Loading...