SQL Fundamentals of Querying

Course Description

SQL Fundamentals of Querying

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.

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

Bookings are closed for this class.