A 1 day course. 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. Testers are often called upon to verify the data outputs of applications, this requires an understanding of databases and the ability to interact with the database to verify the data. SQL Skills will benefit both functional and non-functional testers.
SQL for Testers
On completion of this course, attendees will: Know the different databases in the market place 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 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.
This one day course will cover: 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 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 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
This is a QA approved partner course
Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.
Find dates and prices
We have 2 courses available across 1 locations on 2 different dates
EastCall us on 0113 220 7150 to discuss availability in this region.Contact us
London1 Location / 2 coursesView dates
MidlandsCall us on 0113 220 7150 to discuss availability in this region.Contact us
NorthCall us on 0113 220 7150 to discuss availability in this region.Contact us
ScotlandCall us on 0113 220 7150 to discuss availability in this region.Contact us
SouthCall us on 0113 220 7150 to discuss availability in this region.Contact us
Attend from AnywhereCall us on 0113 220 7150 to discuss availability in this region.Contact us
All locations1 Location / 2 coursesView dates
Fully accredited to ensure we provide the highest possible standards in learning