Curriculum
- 1 Section
- 6 Lessons
- 1 Day
Expand all sectionsCollapse all sections
- Topics6
- 1.11: 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
- 1.22: 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
- 1.33: Working with Functions Topic A: Perform Date Calculations Topic B: Calculate Data Using Aggregate Functions Topic C: Manipulate String Values
- 1.44: 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
- 1.55: Retrieving Data from Multiple Tables Topic A: Combine the Results of Two Queries Topic B: Compare the Results of Two Queries Topic C: Retrieve Data by Joining Tables
- 1.66: Exporting Query Results Topic A: Generate a Text File Topic B: Generate an XML File
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
Prev
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
Next