SQL for Testers
Course
In London-City
Description
-
Type
Course
-
Location
London-city
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.
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. Learning Objectives On completion of this course, attendees will: Know the different databases in the market placeHave 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.
Facilities
Location
Start date
Start date
About this course
This course is designed for software testers wishing to gain knowledge of Structured Query Language, as well as those wishing to brush up on their SQL skills
Reviews
Subjects
- Design
- Database training
- SQL
- Database
Course programme
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
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
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
SQL for Testers