Objective

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.  

Prerequisites 

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

Goals

Organizing Data 
  • Sort Data 
  • Rank Data 
  • Group Data 
  • Filter Grouped Data 
  • Summarize Grouped Data 
  • Use PIVOT and UNPIVOT Operators 

Retrieving Data from Tables 
  • Combine Results of Two Queries 
  • Compare the Results of Two Queris 
  • 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 Date Calculations 
  • Calculate Data Using Aggregate Functions 
  • Manipulate String Values 


 

Credits

0.70 Continuing Education Units
Course ID #TECH292



Class Details

Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:02/19/2020
Time:8:00 am to 4:00 pm
List Price:$450.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:07/23/2020
Time:8:00 am to 4:00 pm
List Price:$450.00
Location:Mission Critical Systems - Tech Center, 7384 S Alton Way Ste 201, Centennial, CO 80112-2369
Date:12/09/2020
Time:8:00 am to 4:00 pm
List Price:$450.00

Don't see what you are looking for?

Contact Us