SQL Querying Fundamentals - Part 1

Skip to Scheduled Dates

Course Overview

In this course, students will compose SQL queries to retrieve desired information from a database.

Who Should Attend

Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Course Objectives

    • connect to the SQL Server database and execute a simple query.
    • include a search condition in a simple query.
    • use various functions to perform calculations on data.
    • organize data obtained from a query before it is displayed on-screen.
    • retrieve data from tables.
    • format an output, save a result, and generate a report.

Course Outline

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

 Back to Course Search

Class Dates & Times

Class times are listed Central time

This is a 1-day class

Price: $695.00

Register When Time
 Register 12/24/2024 8:00AM - 4:00PM
 Register 01/07/2025 8:00AM - 4:00PM
 Register 01/20/2025 8:00AM - 4:00PM
 Register 01/29/2025 8:00AM - 4:00PM
 Register 02/11/2025 8:00AM - 4:00PM
 Register 02/24/2025 8:00AM - 4:00PM
 Register 03/06/2025 8:00AM - 4:00PM
 Register 03/20/2025 8:00AM - 4:00PM
 Register 04/02/2025 8:00AM - 4:00PM
 Register 04/16/2025 8:00AM - 4:00PM
 Register 04/29/2025 8:00AM - 4:00PM
 Register 05/12/2025 8:00AM - 4:00PM
 Register 05/22/2025 8:00AM - 4:00PM
 Register 06/05/2025 8:00AM - 4:00PM
 Register 06/20/2025 8:00AM - 4:00PM