SQL for Testers

sqs_logo SQS Academyistqb_platinum_-logoLogo DGERT

A SQS é a Nº 1 em Formação de Qualidade de Software. É ISTQB® Accredited Training Provider e como parceiro PLATINUM do ISTQB®, (entidade internacional responsável pela certificação de profissionais na área de qualidade de software), possui um vasto portfólio formativo neste âmbito com o objetivo de formar profissionais na área de qualidade de software, com garantias de reconhecimento no mercado nacional e internacional.

A Olisipo é a empresa responsável pela divulgação, gestão e operacionalização desse portfólio formativo em Portugal. A SQS Academy, efetua a preparação para a Certificação Oficial de profissionais em ISTQB® (Certified Tester Foundation Level; Certified Tester Foundation Level – Agile Extension; Certified Tester Advanced Level, Test Manager; Certified Tester Advanced Level, Test Analyst e Certified Tester Advanced Level, Tecnhical Test Analyst).

Conheça o Calendário SQS Academy 2018

Apresentação

A 1 day course that aims to teach beginners how to use the SQL programming language to query a database for testing purposes.The SQL taught in this course is independent of any database management system and can be used on Oracle, SQL Server, MySQL and other database management systems.

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

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.

Please see below for further  details, including course learning objectives.

Destinatários

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

Objetivos

  • Know the different database management systems in the market place (E.g. Oracle, SQL Server)
  • 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 aliases 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 statement

Programa

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

Inscreva-se

SQL for Testers

  • Nº Horas
    7h
  • Preço
    Sob Consulta