logo
Contact Us
  • Certifications
  • Certification Training
  • Courses
  • Training Options
  • Free Training
  • Upcoming Events
  • Tools
  • About

Free Software Testing Training Click For Info

Software Testing Training Is Coming To Your TownClick For Dates

Enter the Bug Free ZoneClick to Enter

Online Software Testing Training at your Pace and your PlaceClick For Details

On-Site Software Testing Training For Your TeamClick For Details

Database Testing: Structured Query Language for Test Professionals

(CSTAS #4) or (CSTP Elective) or (CTM Elective)

This tutorial covers the Elective area of the Test Management Body of Knowledge (TMBOK) required for the Certified Test Manager (CTM) certification. This tutorial also covers the Elective area of the Certified Software Test Professional requirements.

For cost and cities where this course might be offered, check our Public Training Schedule.To bring this course to your test team at your location, contact our Education and Professionals Services Group.

Course available as online self-paced
Course available to schedule onsite
Learn More
Applicable Certifications:
CSTAA #4
Concepts

The majority of today's commercial systems use a relational database backend. This course will enable testers to directly query the database to verify the results of their tests as well as insert test data into the database.

A single database can serve as the foundation for multiple applications, integrating their data and providing concurrency control. This course will enable testers to directly interact with a database independently of any given application, and thus be able to explicitly test the integrity and accuracy of corporate data and it’s adherence to corporate business rules.

Attendees will learn the SQL constructs and features necessary to test existing database applications as well as review the principles of good database design that help prevent data corruption and anomalies in the first place.

Preventing and testing for SQL Injection vulnerability will also be covered.

Outline
  • Module 1 - Relational DBMS Basics for Testers  
    • Creating tables with SQL
    • Table design principles
    • Update, insertion, and deletion anomalies
    • Static Testing: Reading an ERD
  • Module 2 - What a tester needs to know about SQL
    • SQL Basics – Select, Insert, Update, Delete
    • Using Aggregation to determine data health
    • Combining Data from Multiple Tables with Joins
    • Foreign Key Problems
    • Using Sub-queries
    • Generating Test Data
    • Views
    • Indices
  • Module 3 - Protecting against Database hacks: SQL Injection
    • Example injection attacks
    • Testing for SQL Injection Vulnerability
    • What vulnerabilities are inherent in the SQL code?
  • Module 4- Summary and review
    • What Color Do You Want that Database?
    • Testing Scalable Architectures
    • Transaction Process Monitor (TPM)
    • Database Integrity
    • UML Database Model
    • Outer Join example for testing 
    • Useful Queries for Data Verification
    • Where do we go from here?
Certifications
Professional Testing Certifications
Agile Testing Certifications
Mobile Testing Certifications
Test Automation Certifications
Test Management Certifications
Quality Management Certifications
Testing Certification Exams
Training Options
Online Interactive Training
Online Self-Paced Training
Public Training
Onsite Training
Certification Training
CSTP-A Training
CSTP-P Training
CSTP-M Training
CASTP-P Training
CASTP-M Training
CMSTP Training
CSTL Training
CTM-P Training
CTM-M Training
CSTAS Training
CSTAA Training
CSQM Training
Free Training
Online Interactive Webinars
Online Recorded Webinars
Courses
Search Course List
General Testing Courses
Mobile Testing Courses
Agile Testing Courses
Test Automation Courses
Requirement Courses
Database Courses
Test Management Courses
Register for Public Training Register for Online Training Retake Exam Request Course Extension Apply for Graduation Testimonials
Mailing List Request Information Site Map (HTML) Site Map (XML) Books Bug Free Zone
testing-institute-facebook testing-institute-youtube testing-institute-linkedin testing-institute-twitter testing-institute-mailto
business-review
©Copyright IIST 2017 Contact Us