Welcome to ONLC Training Centers


SQL Querying: Fundamentals Course Outline

 (1 day)

Overview
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
Connect to the SQL Database
Query a Database
Save a Query
Modify and Execute a Saved Query

Performing a Conditional Search
Search Using One or More Conditions
Search for a Range of Values and NULL Values
Search Data Based on Patterns

Working with Functions
Perform Date Calculations
Calculate Data Using Aggregate Functions
Manipulate String Values

Organizing Data
Sort Data
Rank Data
Group Data
Filter Grouped Data
Summarize Grouped Data
Use PIVOT and UNPIVOT Operators

Retrieving Data from Multiple Tables
Combine the Results of Two Queries
Compare the Results of Two Queries
Retrieve Data by Joining Tables

View outline in Word

XSQL01

Attend hands-on, instructor-led SQL Querying: Fundamentals training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $395

Savings options:

 CEA Apps Saver
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com