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
Jun 7 8:00 am - 4:00 pm SQL Fundamentals of Querying Phoenix SQL Fundamentals of Querying SQL Fundamentals of Querying 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... Mission Critical Systems 07-06-2018T08:00 07-06-2018T16:00 Active
Active 07-06-2018 Active 410.00 07-06-2018
Register Now
SQL Fundamentals of Querying
Oct 2 8:00 am - 4:00 pm SQL Fundamentals of Querying Phoenix SQL Fundamentals of Querying SQL Fundamentals of Querying 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... Mission Critical Systems 02-10-2018T08:00 02-10-2018T16:00 Active
Active 02-10-2018 Active 410.00 02-10-2018
Register Now

Bookings are closed for this class.