SQL Queries Intro – Class Outline
Lesson 1: Executing a Simple Query
- Topic A: Connect to the SQL Database
- Topic B: Query a Database
- Topic C: Save a Query
- Topic D: Modify and Execute a Saved Query
Lesson 2: Performing a Conditional Search
- Topic A: Search Using One or More Conditions
- Topic B: Search for a Range of Values and NULL Values
- Topic C: Search Data Based on Patterns
Lesson 3: Working with Functions
- Topic A: Perform Date Calculations
- Topic B: Calculate Data Using Aggregate Functions
- Topic C: Manipulate String Values
Lesson 4: Organizing Data
- Topic A: Sort Data
- Topic B: Rank Data
- Topic C: Group Data
- Topic D: Filter Grouped Data
- Topic E: Summarize Grouped Data
- Topic F: Use PIVOT and UNPIVOT Operators