SQL Fundamentals of Querying

Course Description

SQL Fundamentals of Querying

Class Price: $410

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.

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
Oct 2 8:00 am - 4:00 pm SQL Fundamentals of Querying Phoenix SQL Fundamentals of Querying SQL Fundamentals of Querying Class Price: $410 What’s included – a $900 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class if you need... Mission Critical Systems 02-10-2018T08:00 02-10-2018T16:00 Active
Active 02-10-2018 Active 410.00 02-10-2018
Register Now
SQL Fundamentals of Querying Phoenix Oct 2  8:00 am - 4:00 pm

410.00

Attendee 1