SQL: Fundamentals of Querying

Days 1    Code SQLFUN   Fee £495

You will compose SQL queries to retrieve desired information from a database.

Course Details

You will compose SQL queries to retrieve desired information from a database.

Target Audience

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

Prerequisites

Basic end-user computer skills and some familiarity with database terminology and structure are required. Upon successful completion of this course, students will be able to:

  • Connect to the SQL Server database and execute a simple query.

  • Use various functions to perform calculations on data.

  • Retrieve data from tables.

  • Include a search condition in a simple query.

  • Organize data obtained from a query before it is displayed on-screen.

  • Format an output, save a result, and generate a report.

Course Outline

  • Executing a Simple Query

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

  • Working with Functions

    Perform Date Calculations
    Calculate Data Using Aggregate Functions
    Manipulate String Values

  • 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

  • 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

  • Organizing Data

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

  • Presenting Query Results

    Save the Query Result
    Generate an XML Report

Request a Call Back

WebSQL: Fundamentals of Querying