SQL Fundamentals of Querying Training in Denver & Phoenix

What’s included – a $900 value with:

  • Face-to-face, live interactive class
  • Retake – allows you to retake the entire class if you need a refresher within 6 months
  • Lunch & Learn session – choose from different topics to learn something new in the future
  • Hard copy training manual – to take notes and take with you for future reference
  • Just Tips Newsletter subscription – for ongoing monthly tips to help you learn even more!

icon_accessThis class will show you how to retrieve information from SQL databases through querying. You will learn how to use Structured Query Language (SQL) as a tool to implement logic and define instructions to retrieve needed information.

Class Price: $410

Training Class Goal

Students will learn how to use Structured Query Language (SQL) as a tool to implement logic and define instructions.

PreRequisites

Intermediate Access skills and a full understanding of how to create query’s in Access databases.

Topics Covered

Organizing Data

  • Sort Data
  • Rank Data
  • Group Data
  • Filtered Grouped Data
  • Summarized Grouped Data
  • Use PIVOT and UNPIVOT Operators

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

Presenting Query Results

  • Save the Query Result
  • Generate an XML Report

Executing a Simple Query

  • Connect to the Database
  • Query the Database
  • Save a Query
  • Modify a Query
  • Execute a Saved Query

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

Working with Functions

  • Perform Data Calculations
  • Calculate Data Using Aggregate Functions
  • Manipulate String Values

Upcoming Classes

SQL Fundamentals of Querying
Jan 11 8:00 am - 4:00 pm SQL Fundamentals of Querying Phoenix SQL Fundamentals of Querying SQL Fundamentals of Querying Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class if you need... Mission Critical Systems 11-01-2019T08:00 11-01-2019T16:00 Active
Active 11-01-2019 Active 450.00 11-01-2019
Register Now
SQL Fundamentals of Querying
Mar 4 8:00 am - 4:00 pm SQL Fundamentals of Querying Westminster SQL Fundamentals of Querying SQL Fundamentals of Querying Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class if you need... Mission Critical Systems 04-03-2019T08:00 04-03-2019T16:00 Active
Active 04-03-2019 Active 450.00 04-03-2019
Register Now
SQL Fundamentals of Querying
May 10 8:00 am - 4:00 pm SQL Fundamentals of Querying Phoenix SQL Fundamentals of Querying SQL Fundamentals of Querying Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class if you need... Mission Critical Systems 10-05-2019T08:00 10-05-2019T16:00 Active
Active 10-05-2019 Active 450.00 10-05-2019
Register Now
SQL Fundamentals of Querying
Aug 19 8:00 am - 4:00 pm SQL Fundamentals of Querying Westminster SQL Fundamentals of Querying SQL Fundamentals of Querying Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class if you need... Mission Critical Systems 19-08-2019T08:00 19-08-2019T16:00 Active
Active 19-08-2019 Active 450.00 19-08-2019
Register Now
SQL Fundamentals of Querying
Sep 13 8:00 am - 4:00 pm SQL Fundamentals of Querying Phoenix SQL Fundamentals of Querying SQL Fundamentals of Querying Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class if you need... Mission Critical Systems 13-09-2019T08:00 13-09-2019T16:00 Active
Active 13-09-2019 Active 450.00 13-09-2019
Register Now