Ground yourself in the basic approaches to testing SQL queries and gain the ability to do deep testing and analysis of back-end problems.
Overview
Syllabus
Introduction
- Dive deep into quality
- What you should know
- What is SQL and why use it as a tester?
- Getting setup with the tools you need
- Getting started with SQL queries
- Understanding more complex SQL queries
- Setting up a site for testing
- Validate user workflows
- Validate data integrity
- Working through an example
- Create new entries in a table
- Update existing entries in a table
- Deleting data from a table
- Challenge: Data generation
- Solution: Data generation
- Transactions
- Field constrains
- Schema validation
- Security testing
- Performance testing
- Challenge: Database tests
- Solution: Database tests
- Next steps
Taught by
Dave Westerveld
