SQL Querying - Level 1 Fundamentals of Querying

Lesson 1: Executing a Simple Query

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

Lesson 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

Lesson 3: Working with Functions

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

Lesson 4: Organizing Data

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

Lesson 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

Lesson 6: Presenting Query Results

• Save the Query Result
• Generate an XML Report

• Atlanta, GA - April 20, 2012
• Chattanooga, TN - April 26, 2012
• Madison, WI - April 26, 2012
• Memphis, TN - April 30, 2012
• Charleston, SC - May 2, 2012
• Columbia, SC - May 2, 2012
• Greenville, SC - May 2, 2012
• Charleston, WV - May 2, 2012
• Mechanicsburg, PA - May 3, 2012
• Madison, WI - May 7, 2012
• Gainesville, FL - May 8, 2012
• Pensacola, FL - May 8, 2012
• New York, NY - May 11, 2012
• Irving, TX - May 16, 2012
• West Valley City, UT - May 21, 2012
• Pittsburgh, PA - May 22, 2012
• Wauwatosa, WI - May 22, 2012
• Carmel, IN - May 25, 2012
• Eagan, MN - May 25, 2012
• Westerville, OH - May 29, 2012
• Las Vegas, NV - May 30, 2012
• Sacramento, CA - May 30, 2012
• Reno, NV - May 30, 2012
• Richmond, VA - June 4, 2012
• Parsippany, NJ - June 4, 2012
• Charleston, SC - June 5, 2012
• Columbia, SC - June 5, 2012
• Greenville, SC - June 5, 2012
• Charleston, WV - June 5, 2012
• Madison, WI - June 5, 2012