A Olisipo é a empresa responsável pela divulgação do portfólio formativo da SQS em Portugal. A SQS Portugal é ISTQB® Accredited Training Provider e ISTQB® Platinum Partner.
A SQS Academy faz a preparação e Certificação Oficial de profissionais em ISTQB (Certified Tester Foundation Level; Certified Tester Foundation Level – Agile Extension; Certified Tester Foundation Level Specialist – Automotive Software Tester; Certified Tester Advanced Level, Test Manager, Test Analyst, Technical Test Analyst, Security Tester, Tester Automation Engineer, oferta única em Portugal, reconhecida pela ISTQB – International Software Testing and Qualification Board e pela PSTQB – Associação Portuguesa de Testes de Software.
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
PARTILHAR
De momento não temos datas disponíveis para este curso, entre em contacto para obter mais informações.
We use cookies to offer you a better browsing experience, analyse site traffic, presonalize content, and serve targeted ads. Read how we use cookies and how you can control them in our “Cookie Settings”. By using our site, you consent to our use of cookies.