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
