SQL Querying Fundamentals

Learning Outcomes: 

• Introduction to SQL Usage and Terminology 
• Executing Simple Queries 
• Performing Queries Using Criteria Conditions 
• Summarizing Data with Mathematical Functions 
• Organizing Query Data Results  
• Retrieving Data from Multiple Tables 
• Exporting Query Results 

Day 1 - Topics 

Introduction to SQL Usage and Terminology 

• What is SQL and What can SQL Do? 
  
• SQL Keyword Command Language and Hierarchy 
  
• Introduction and Usage of the Select Clause Statement 

Executing A Simple Query 

• Connect to a SQL Database 
  
• Query a Database. 
  
• Save a Query. 
  
• Modify and Execute a Saved Query 

Performing Queries Using Criteria Conditions 

• Query Using One or More Conditions 
  
• Query for a Range of Values and NULL Values 
  
• Query Data Using Wildcard Characters 
  
• Applying And/Or Operators 
  
• Format Column Headings with Aliases 
  
• Format Query Results Data 

Day 2 - Topics 

Summarizing Data with Mathematical Functions 

• Perform Date Calculations 
  
• Summarize Data Using Aggregate Functions 
  
• Manipulate Text Results with String Functions 
  

Organizing Query Data Results 

• Sort Data with “Order By” Clause 
  
• Group Data with “Group By” Clause 
  
• Rank Data Using “Rank” Function 
  
• Filter Grouped Data 
  
• Summarize Grouped Data 
  
• Use PIVOT and UNPIVOT Operators 
  

Retrieving Data from Multiple Tables 

• Understanding SQL Joins 
  
• Retrieve Data by Joining Tables 
  
• Combine the Results of Two Queries 
  
• Compare the Results of Two Queries 
  
• Introduction into Sub-Queries 
  

Exporting Query Results 

• Export to Excel Workbook 
  
• Generate a Text File