SQL Querying Fundamentals

‍Download the free version of MS SQL. This software is a requirement to take this class. Please download and install it before the class begins. If you have restrictions on installing software, contact your IT department in advance for assistance.

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