0845 450 6120

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.

Pre-Requisites

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

Introduction

    What is a database?
    Types of databases
    What is a logical data model?
    What is relational data model?
    Keys
    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
    WHERE, GROUP BY AND HAVING

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  


One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include