SQL Querying Fundamentals – Part 1

1 – Executing a Simple Query

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

2 – 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

3 – Working with Functions

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

4 – Organizing Data

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

5 – 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

6 – Presenting Query Results

• Save the Query Result
• Generate an XML Report