SQL Querying Fundamentals - Part 1

Course Outline

Executing a Simple Query

• Connect to the SQL Database
• Query a Database
• Save a Query
• Modify a Query
• Execute a Saved Query

Performing a Conditional Search

• Search Using a Simple Condition
• Compare Column Values
• Search Using Multiple Conditions
• Search for a Range of Values and Null Values
• Retrieve Data Based on Patterns

Working with Functions

• Perform Date Calculations
• Calculate Data Using Aggregate Functions
• Manipulate String Values

Organizing Data

• Sort Data
• Rank Data
• Group Data
• Filter Grouped Data
• Summarize Grouped Data
• Use PIVOT and UNPIVOT Operators

Retrieving Data from Tables

• Combine Results of Two Queries
• Compare the Results of Two Queries
• Retrieve Data by Joining Tables
• Check for Unmatched Records
• Retrieve Information from a Single Table Using Joins

Presenting Query Results

• Save the Query Result
• Generate an XML Report