�鶹������ý

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