SQL for Testers

Course

In London-City

£ 395 + VAT

Description

  • Type

    Course

  • Location

    London-city

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. Learning Objectives On completion of this course, attendees will: Know the different databases in the market placeHave 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.

Facilities

Location

Start date

London-City ((select))
EC3V 9LJ

Start date

On request

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Design
  • Database training
  • SQL
  • Database

Course programme

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


SQL for Testers

£ 395 + VAT