SQL: Fundamentals of Querying

This SQL training course provides attendees with fundamental skills to use a range of queries to retrieve and analyse data from databases using SQL.

    Interested in attending? Have a suggestion about running this event near you?
    Register your interest now

      Description

      This course introduces attendees to querying with SQL. You will learn how to connect to a SQL database and execute a range of queries to retrieve and analyse data.

      The course will cover a variety of functions including date calculations, aggregate functions, string manipulations and more.

      Prerequisites

      The following skills and knowledge are required for attendance to this course:

      • Basic end-user computer skills
      • Familiarity with database terminology and structure
      • Some experience with data manipulation using a tool like Microsoft Excel

      Key Topics

      • Executing a Simple Query
      • Performing a Conditional Search
      • Working with Functions
      • Organising Data
      • Retrieving Data from Tables
      • Presenting Query Results

      Learning Objectives

      When the participant completes this course they will be able to:

      • 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.

      Topic Outline

      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

      Target Audience

      This course is intended for attendees who are involved with reporting / data manipulation who would like to extend upon their skills to query data from databases using SQL.