SQL Querying: Fundamentals is unfortunately unavailable

Thankfully we have 4 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 - Schaumburg

(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:
Schaumburg, Suburbs
1320 Tower Rd 1st Fl
At N Wiley Rd
Chicago, Illinois 60173
(Map)
Share:
Important:
All classes are live, hands-on training via remote instructor.
Description
Class Level: Intermediate
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: 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.

Prerequisites: 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 Chicago educator.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

4 Top Choices

SQL Server 2012 Reporting Services

at ONLC Training Centers - Schaumburg 1320 Tower Rd 1st Fl, Chicago, Illinois 60173

This three-day instructor-led is intended for information workers and database professionals who are interested in expanding their knowledge about SQL Server 2012 Reporting Services. During this course, attendees will learn how to Report Designer in SSDT and Report Builder, work with solutions and projects, design basic reports, enhance reports with...

Monday Oct 28th, 9am - 3:45pm

  (3 sessions)
$1,795

3 sessions

Querying Microsoft SQL Server 2012/14/16

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

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, 9am - 4pm

  (5 sessions)
$2,925

5 sessions

MySQL Workbench: Data Modeling & Development

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

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, 9am - 4pm

  (4 sessions)
$2,280

4 sessions

Microsoft SQL Server 2012/14/16 Reporting Services

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

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 with SELECT queries Generate reports from the Report Wizard and from scratch...

Monday Dec 2nd, 9am - 4pm

  (5 sessions)
$2,925

5 sessions