SQL Fundamentals of Querying Training in Denver & Phoenix

What’s included – a $950 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!

This 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: $450

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
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
13-09-2019 Active 450.00 13-09-2019
Register Now
SQL Fundamentals of Querying
Feb 19 8:00 am - 4:00 pm SQL Fundamentals of Querying Tech Center 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-02-2020T08:00 19-02-2020T16:00 Active
19-02-2020 Active 450.00 19-02-2020
Register Now
SQL Fundamentals of Querying
Jul 23 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 23-07-2020T08:00 23-07-2020T16:00 Active
23-07-2020 Active 450.00 23-07-2020
Register Now
SQL Fundamentals of Querying
Dec 9 8:00 am - 4:00 pm SQL Fundamentals of Querying Tech Center 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 09-12-2020T08:00 09-12-2020T16:00 Active
09-12-2020 Active 450.00 09-12-2020
Register Now