SQL for Testers

4.5
1 review
  • This course is very good for people who want to start their career in testing, especially if you want to get into the banking field. The educational experience here is high quality and at the same time gives you skills in different areas which would help your career to grow. Totally recommend it for beginners, it is an excellent first step in SQS.
    |

Course

In London

£ 400 + VAT

Description

  • Type

    Seminar

  • Location

    London

  • Class hours

    7h

  • Duration

    1 Month

Also delivered as inhouse/private course

A 1 day course that aims to teach beginners how to use the SQL programming language to query a database for testing purposes.

Facilities

Location

Start date

London
See map
7-11 Moorgate, EC2R 6AF

Start date

On request

About this course

Definition of SQL, normalisation and database desigh, the SELECT statement, joins and other key workds.

Test Manager l Developer  l Functional Tester l Agile Tester l  Test Automation Specialist l Performance Test Specialist.

None.

Attendance certificate.

SQS has a experienced team of trainers, that are consultants and are actually working on this field currently.

After requesting information, you will be either emailed the relevant information or called to discussed your requirements in detail.

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

4.5
  • This course is very good for people who want to start their career in testing, especially if you want to get into the banking field. The educational experience here is high quality and at the same time gives you skills in different areas which would help your career to grow. Totally recommend it for beginners, it is an excellent first step in SQS.
    |
0%
4.7
excellent

Course rating

Recommended

Centre rating

Former Student

4.5
16/06/2017
What I would highlight: This course is very good for people who want to start their career in testing, especially if you want to get into the banking field. The educational experience here is high quality and at the same time gives you skills in different areas which would help your career to grow. Totally recommend it for beginners, it is an excellent first step in SQS.
What could be improved: Nothing.
Would you recommend this course?: No
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • Database
  • SQL
  • Database training
  • Primary keys
  • Foreign Keys
  • Common Data Types
  • Keys
  • IT
  • Database Design
  • Computing

Course programme

This 1-day Introduction to SQL course covers the following areas:

What is SQL?
  • 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 Normalisation
  • First, second and third Normal Forms
  • Other Normalisation Forms
  • The SELECT Statement
  • Basic SELECT
  • Select DISTINCT
  • Select with formulas/calculations
  • WHERE
  • Other

Joins and other key words
  • Outer Joins
  • Inner Join
  • Full Join
  • Group By Clause
  • Having Clause

Additional information

This course can also be imparted distance-learning and in-house.

SQL for Testers

£ 400 + VAT