SQL Querying Fundamentals

Who should attend

This course has been designed for individuals who wish to learn how to use SQL to query databases and extract information. The only requirements for attending this course are:

  • Basic computer literacy skills 
  • Familiarity with database structure and terminology 
Team Pass by Learnit

SQL Querying Fundamentals

From $0
Two, 2-hour Modules (9am - 11:30am PT)
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 
Course ID
L0166
Available times
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am

Course Outline

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 

Skills covered

No items found.

SQL Querying Fundamentals

Reviews

Coming soon