Training > Basic SQL
Basic SQL
This course could have been called 'the minimum a tester should know about databases'.
Course Objectives
- Teach the database novice the basics of databases.
- Introduce the tester to structured query language.
- Demonstrate how a tester can employ database queries to effectively enhance testing.
Course Content
- Module 1 – Introduction to the fundamentals
An introduction to SQL, Databases, Data Types, Primary and Foreign Keys. Foundation building information needed in order to build queries.
- Module 2 – Building queries
Query structure is explained and analysed. A clause by clause / keyword by keyword build up of the query to understand the SQL query structure.
- Module 3 – Expressions, Functions & Advanced Queries
Different facets of queries are explained and an introduction is given to Joins which falls into advanced queries.
Intended Audience
The course is relevant to testers who have no SQL experience.