0345 4506120

SQL for Testers

Testers are often called upon to verify the data outputs of applications, this requires an undestanding of databases and the ability to interact with the database to verify the data. SQL Skills will benefit both functional and non-functional testers.

After completing this course, delegates will have a good understanding of basic techniques pertaining to SQL, allowing testers to design additional tests and gain a deeper understanding of the application they are testing.

We don't currently have any courses listed for SQL for Testers, would you like to view all courses for Software Testing?

Learning Objectives

On completion of this course, attendees will:

  • Know the different databases in the market place
  • Have an understanding of different types of databases.
  • Understand the basic structure of a database specifically for relational databases.
  • Be able to do a basic select statement.
  • Understand how to do basic calculations as part of the select statement.
  • Know how to create ailiases in a select statement.
  • Be able to expand the select statement to find specific data on the tables using the where clause.
  • Understand how to select data from different tables in one select statements.


This course is designed for software testers wishing to gain knowledge of Structured Query Language, as well as those wishing to brush up on their SQL skills

Course Content


    What is a database?
    Types of databases
    What is a logical data model?
    What is relational data model?
    Primary Keys
    Foreign Keys
    Common Data Types
    Example of a relational data mode

Normalisation and Database design

    Description of Normalization
    First, second and third Normal Forms
    Other Normalization Forms

The SELECT Statement

    Basic SELECT
    Select DISTINCT
    Select with formulas/calculations

Joins and other key words

    Basic Joins, Equi-Joins and Cross Joins
    Inner Join
    Outer Joins
    Nested Join
    Using Microsoft Query
    Using Excel
    Using Microsoft SQL Server  

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.


Our Customers Include