Technology Staffing The Way It Was Meant To Be
Application Development Staffing
Infrastructure Staffing
Home
About Us
Mission & Core Values
Our Clients
Leadership
Careers
Links
Giving Back
Intellect Rewards Training Program Schedule
To enroll in any training event, please contact Tony Aponte at Tel: (800) 599-8781 or
aaponte@intellectcorp.com
Training
>
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