SQL Querying - Level 1 Fundamentals of Querying
- Beginner
- 18 and older
- $395
- 462 Seventh Ave, New York, NY
Apr 30th
10am–5pm EDT
Meets 3 Times
Discover Classes. Earn 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 @ 185 Madison Ave, New York, NY & Virtually Online
Master the art of turning raw data into actionable insights with SQL queries. This hands-on course will teach you how to filter, group, and join data, as well as use advanced techniques like subqueries and aggregate functions. Gain the skills to excel in any data-driven industry and make more informed decisions.
$975
20 Seats Left
May 20th
10am–5pm EDT
Meets 3 Times
$975
20 Seats Left
Jun 10th
10am–5pm EDT
Meets 3 Times
$975
20 Seats Left
This class has 4 more dates.
Tap here to see more
Tue, Apr 30th, 10am–5pm EDT
(21 hours over 3 sessions)
Other dates (8)
SQL Private Training
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
Unlock the power of databases with personalized SQL training. Master the art of querying, filtering, and aggregating data using PostgreSQL, gaining essential skills applicable across various database platforms. Transform
Wed, May 29th, 10am–1pm EDT
(3 hours)
Data Analytics Technologies Bootcamp
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
In this course, students will master Excel, SQL, and Tableau, some of the top data analytics tools. Here, students will gain the skills to organize, analyze, summarize, and visualize data, presenting actionable insights for effective decision-making. Comprehensive classroom training in Midtown Manhattan.
May 13th
10am–5pm EDT
Meets 8 Times
$1,949
20 Seats Left
May 14th
6–9pm EDT
Meets 16 Times
$1,949
20 Seats Left
Don't see any dates that work for you?
Add to Wishlist
Mon, May 13th, 10am–5pm EDT
(56 hours over 8 sessions)
Other dates (3)
SQL Level 1
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
Unlock the power of SQL and relational databases with this comprehensive course. Learn how to write SQL queries, filter results, and combine data from multiple tables, all while gaining a strong foundation in database architecture. Master the fundamentals of SQL at Noble Desktop.
May 14th
6–9pm EDT
Meets 2 Times
$350
20 Seats Left
May 28th
10am–5pm EDT
$350
20 Seats Left
This class has 3 more dates.
Tap here to see more
Tue, May 14th, 6–9pm EDT
(6 hours over 2 sessions)
Other dates (7)
SQL Level 3
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
Take your SQL skills to the next level with this advanced course at Noble Desktop. Learn how to use subqueries, views, functions, stored procedures, and more to manipulate and analyze data in databases. Gain in-depth techniques that will prepare you for a job in data analysis or data science.
May 28th
6–9pm EDT
Meets 2 Times
$425
20 Seats Left
May 30th
10am–5pm EDT
$425
20 Seats Left
This class has 3 more dates.
Tap here to see more
Tue, May 28th, 6–9pm EDT
(6 hours over 2 sessions)
Other dates (7)
Sold Out
Start Dates (0)
- $395
- These classes sell out faster than we update our systems. Enroll and we'll confirm your spot.
Showing
1
–
0
of
0
Class Description
Description
What you'll learn in this sql class:
In this course, students will compose SQL queries to retrieve desired information from a database.
Who Should Attend
Lesson 1: Executing a Simple Query
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.
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
People who viewed this class also viewed the following classes
CourseHorse Gift Card
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. Points give you money off your next class!
New Horizons Computer Learning
As part of the largest independent IT Training Provider, New Horizons Computer Learning Center delivers more courses than any other IT training company.
Innovative and Flexible Learning Methods
New Horizons New York City understands that not everyone is the same, and we have developed a variety of innovative...
Read more about New Horizons Computer Learning
This school has been carefully vetted by CourseHorse and is a verified NYC educator.
New Horizons Computer Learning
Midtown, Manhattan
462 Seventh Ave 6th Flr
Btwn W 36th & W 37th Streets
New York, New York 10018 Midtown, Manhattan
462 Seventh Ave 6th Flr
Btwn W 36th & W 37th Streets
New York, New York 10018
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
- Lock in a price with the Inflation Buster Gift Card Price Adjuster™
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.
One last thing!
Add a name to your account.
What name do you want displayed with your post?
What name do you want displayed with your post?
Get it first. Sign up for up-to-the-minute offers, sales and news.
More in Database
Made in NYC
© CourseHorse, Inc. 2024 Loading...