Microsoft SQL Fundamentals Of Querying

Course Objectives

You will compose SQL queries to retrieve desired information from a database. You should have basic computer skills, be familiar with concepts related to database structure and terminology, and want to use SQL to query databases.

Course Content

• 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

Prerequisites

Basic end-user computer skills and some familiarity with database terminology and structure are required.