SQL Querying Fundamentals – Standard (2 Days)

$ 990.00

Class Duration: 2 Days, 7 Hours/Day

Class Agenda

Day One Morning Session 3 Hours
Lunch 1 Hour
Afternoon Session 3 Hours
Breaks Prescribed by Instructor
Day Two Morning Session 3 Hours
Lunch 1 Hour
Afternoon Session 3 Hours
Breaks Prescribed by Instructor

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

  • What is SQL and What can SQL Do? 
  • SQL Keyword Command Language and Hierarchy 
  • Introduction and Usage of the Select Clause Statement 
  • Connect to a SQL Database 
  • Query a Database. 
  • Save a Query. 
  • Modify and Execute a Saved Query 
  • 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

  • Perform Date Calculations 
  • Summarize Data Using Aggregate Functions 
  • Manipulate Text Results with String Functions 
  • 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 
  • Understanding SQL Joins 
  • Retrieve Data by Joining Tables 
  • Combine the Results of Two Queries 
  • Compare the Results of Two Queries 
  • Introduction into Sub-Queries 
  • Export to Excel Workbook 
  • Generate a Text File 

Event Details

Phone: (602)252-3955

Email: registration@trainingtoyou.com

Other options for this content:

Scroll to Top