Basic SQL

Course Description

This computer based course starts with the basics of databases. It progressively introduces the tester to structured query language, and how a tester can employ database queries to effectively enhance testing.  This course teaches candidates how to write structured query language and walks candidates through progressive queries on a sample database. The queries are aimed at retrieving results so a tester can validate that their GUI results are correct as per the information in the Database. 

Intended Audience

The course is relevant to testers who have no SQL experience.

Course Content

The course covers the following areas:

• 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.

Course Details

• Prerequisites
  The course is aimed at software testers with no SQL experience. General knowledge of the information technology industry is an advantage.

• Course presentation and duration
  The course is presented by an experienced software testing practitioner. The course duration is two days.  The course runs from 08:00 to 16:00. This includes a lunch and two tea breaks daily.

• Training style
  The course is conducted in practical classroom style, with one PC per student. Candidates use practical tasks to consolidate theoretical concepts. Any database-related problems encountered in the workplace can be discussed during the course.

• Course materials, certification and assessment
  Comprehensive course notes are provided. Practical exercises, which are completed during the course, are handed in for evaluation. On successful completion of this course, the Test and Data Services’ Certificate in Basic SQL is awarded. The candidates’ results will be displayed on their certificates.

• Training Venues
  Test and Data Services presents courses at several well-established training facilities in Midrand (near Johannesburg and Pretoria), Cape Town and Durban. Training can be arranged at the client’s premises depending on adequate facilities and candidate numbers.

Contact