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
