SQL Querying: Fundamentals is unfortunately unavailable

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

SQL Querying: Fundamentals

at ONLC Training Centers - Murray Hill

(5)
Course Details
Price:
$395
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Murray Hill, Manhattan
275 Madison Ave 14th Fl
At E 40th St
New York, New York 10016
(Map)
Share:
Important:
All classes are live, hands-on training via remote instructor.
Purchase Options
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this sql server training:

Organizations use large SQL databases to store information about clients, products, or sales. However, that data is locked into those databases until it is accessed by a business intelligence tool such as Power BI, Tableau or Crystal Reports. With the proper permissions, analysts can use SQL to select the data they need for additional analysis and reporting. This class, SQL Querying: Fundamentals, provides an overview of the SQL commands that can be used to access that data.

You will:
  • Connect to the SQL Server database and execute a simple query.
  • Include a search condition in a simple query.
  • Use various functions to perform calculations on data.
  • Organize the data obtained from a query before it is displayed on-screen.
  • Retrieve data from multiple tables.
Target Student / Prerequisite: This course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Note: Some familiarity with database terminology and structure is helpful.

Course Outline
  • Executing a Simple Query
  • Performing a Conditional Search
  • Working with Functions
  • Organizing Data
  • Retrieving Data from Multiple Tables

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

Map

Google Map

ONLC Training Centers

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

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. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (2)

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

10 Top Choices

Intermediate SQL

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Intermediate SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep,...

Wednesday Oct 23rd, 9am - 5pm

Beginner SQL

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Beginner SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. Learn to use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database in our beginner SQL training class. Our SQL courses are taught in our state-of-the-art...

Tuesday Oct 22nd, 9am - 5pm

Advanced SQL

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Advanced SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep, and...

Thursday Oct 24th, 9am - 5pm

SQL Training For Beginners

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

Do you keep hearing the word ‘SQL’ buzzing around and want to find out more about it? This 3 hour workshop will provide an introduction to fundamental concepts in relational databases and using the query language SQL.  Participants will learn to how to work with data that is stored in a relational database. By the end of the workshop, you...

Monday Oct 21st, 6:30pm - 9:30pm

Querying Microsoft SQL Server 2012/14/16

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are seeking to prove their skills and knowledge in writing queries.  Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which...

Monday Nov 4th, 10am - 5pm

  (5 sessions)
$2,925

5 sessions

Designing and Deploying Microsoft Exchange Server 2016

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

This course provides experienced Exchange Server administrators with the knowledge to design and implement an Exchange Server 2016 messaging environment. Students will learn how to design and configure advanced components in an Exchange Server 2016 deployment such as site resiliency, advanced security, compliance, archiving, and discovery solutions. ...

Monday Nov 4th, 10am - 6pm

  (5 sessions)
$2,975

5 sessions

Querying Data with Transact-SQL

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761. Audience profile: The main purpose of the course...

Monday Nov 11th, 10am - 6pm

  (5 sessions)
$2,975

5 sessions

MySQL Workbench: Data Modeling & Development

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

This course explains how to design and model MySQL databases. MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to...

Monday Nov 11th, 10am - 5pm

  (4 sessions)
$2,280

4 sessions

Microsoft SQL Server 2012/14/16 Reporting Services

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

Full Course Name Microsoft SQL Server 2012/14/16 Reporting Services SSRS This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to:  Plan for, install, configure and customize SQL Server 2012 Reporting Services Retrieve data...

Monday Dec 2nd, 10am - 5pm

  (5 sessions)
$2,925

5 sessions

Administering Microsoft SQL Server 2012/14/16 Databases

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

This course is intended for Database Professionals who perform installation, maintenance, and configuration tasks as their primary areas of responsibility. They will often set up database systems and are responsible for making sure those systems operate efficiently. They also make sure that the data they store is backed up regularly, stored effectively,...

Monday Dec 9th, 10am - 5pm

  (5 sessions)
$2,925

5 sessions