>> Home > Course Portfolio > Structured Query Language (SQL) for Testers Print this page
 

FACULTY TRAINING INSTITUTE

 
  >> Home > Course Portfolio > Structured Query Language (SQL) for Testers  
 

Structured Query Language (SQL) for Testers

Use Structured Query Language (SQL) to solve those data mysteries

Course Overview

Organisations are looking to Testers, as a part of the Testing Profession, to constantly apply fast and smart methods to assure quality in software. The demand for SQL is growing as is the level of SQL proficiency and as a Tester with SQL skills you enable yourself to add more value to your part of the QA process, to your Team, to the Project Team and to the Organisation.

Structured Query Language (SQL) is used; to create and maintain databases, to transact between application and database, to generate reports and other information artefacts.

Where Testers are required only to test functionality through traditional “point and click” methods (black box), SQL expertise is not required. However there is a growing demand for Testers with the ability to test through applications (Glass Box method) and here SQL is a required skill.

Testers may use SQL to:

  • test process, application and system functionality
  • test artefacts in the form of reports, letters, statements, invoices, etc
  • generate data for files
  • populate test environments for specific test conditions

Course Objectives:

  • Gain a basic understanding of the history of SQL
  • Understand elements of the mathematics that supports SQL
  • Have a basic understanding of a network architecture
  • Know what a database is and why it exists
  • Be able to read and interpret an Entity Relationship Diagram
  • Understand the components of a database
  • Understand data types and operators used with SQL
  • Be able to script and execute basic and complex SQL statements using SQL clauses, commands and functions to read, update and delete data
  • Be able to factor in performance into your SQL statements
  • Be able to reverse engineer a SQL statement

Course Delivery

The course delivery comprises instructor-led seminars interspersed with practical exercises.

Course Assessment

There are no formal assessments (exams, tests, presentations etc.) for this course. However, to earn a certificate of attendance, delegates will berequired to:

  • Attend both course days
  • Actively participate in exercises and discussion workshops

Course Prerequisites

  • A laptop with MS Access 2000 upwards will be required
  • Intermediate understanding of the English language as this course is delivered in English
  • Delegates do not require knowledge or previous experience of Testing, Quality Assurance, Databases or SQL

Accreditation

FTI is a Registered Education Provider with the Project Management Institute.

Faculty Training Institute holds the following institutional accreditations

  • Provisionally accredited as an Education and Training Provider with the MICT Seta (ACC/2010/00/601)
  • An Institute of Sectoral and Occupational Excellence (ISOE) in Business Analysis with the MICT Seta
  • The first Education Provider to be endorsed by the International Institute of Business Analysis (IIBA®) in South Africa and is the only Endorsed Education Provider (EEP™) to hold Charter status
  • A Registered Education Provider (REP 2841) with the Project Management Institute (PMI®). 
  • Member of the Information Technology Association of South Africa

 

© 2018 Faculty Training Institute Disclaimer | Back to the Top
  National ShareCall     0860 CAREER     or     0860 227 337

Follow us    

 follow us on Facebook !   Join us on Twitter    Google+    LinkedIn   FTI on You Tube   FTI 0n : Instagram   Pinterest  

Cape Town - FTI - EOH Building ,Block C, The Estuaries, 3 Oxbow Crescent, off Century Avenue, Century City, 7441 - Tel +27 (0) 21 683-4506
Johannesburg - FTI Training Centre, Block C, Inyanga Close, Sunninghill, Sandton, Tel +27 (0) 11 807-9478 , Fax +27 (0) 11 807-9480
-->