About this Course

Code TPQ42000
Duration 1 Day

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.

Delegates will learn how to

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.

Outline

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

1 Day

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.