A 1 day practical workshop.
Live online events
23 October1 day, 09:30 AM BST - 05:00 PM BSTOnline
Register12 places remaining
- £600.00 excl. VAT
A one 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 knowledge of databases and the ability to interact with the database to verify the data. SQL Skills will benefit both functional and non-functional testers.
Upon completion of this course, attendees will be able to:
- 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
The 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?
- 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
Joins and other keywords
- Outer Joins
- Inner Join
- Full Join
- Group By Clause
- Having Clause
Who should attend
Test Managers, Developers, Functional Testers, Agile Testers, Test Automation Specialists, Performance Test Specialists
There are no specific prerequisites for this SQL course.
Your benefits at a glance
- Learn the most up-to-date methodology
- Deliver increased efficiency and effectiveness to your team
- Learn through best practices and real examples
- Learn with trainers who have proven track records
- Flexible delivery with online learning options
- Train with the world’s leading quality specialist for digital business
|Agile Certified Practitioner (PMI-ACP) Preparation Course Online||28 Sep|
|BCS Certificate in Requirements Engineering Online||14 Sep|
|ISTQB® Certified Tester – Foundation Level 2018 Syllabus||14 Sep|
|Estimating for Testers||12 Oct|