Technology Staffing The Way It Was Meant To Be
 Intellect Rewards Training Program Schedule
To enroll in any training event, please contact Tony Aponte at Tel: (800) 599-8781 or aaponte@intellectcorp.com

Skip Navigation LinksTraining > SQL Server
SQA: SQL Backend Testing                                                                               April 20, 2010
This course is ideal for SQA professionals:
  Seeking to gain a knowledge of relational databases
  Interested in gaining basic SQL fundamentals in relation to software testing
  Upon completion of course, be able to perform back-end database testing/data validation

Specific areas to be covered include:

  Using Transact-SQL Querying Tools—SQL Query Analyzer

DB Testing Concepts
  Testing Multiple Application Servers
  Testing a Clustered Database
  Test Checklist
  Test Transaction Integrity

Relational DB Basics for Testers

  Field Integrity
  Table Integrity
  Constraints between fields
  Primary Key fields
  Data set Integrity
  Inspecting Database designs

Introduction to SQL

  Standardization Layer
  SQL DML basics
  SELECT statements for Testing
  SQL Basics—SELECT
  Order of clauses in SQL SELECT statement:
  SQL Basics—INSERT, UPDATE, DELETE
  Combining data from multiple tables
  Introduction to Joins
  Database design fundamentals
Click Here to return to Training Schedule
Copyright © 2012 Intellect Technical Solutions Inc., All Rights Reserved