SQL for Testers

Ground yourself in the basic approaches to testing SQL queries and gain the ability to do deep testing and analysis of back-end problems.

Introduction

• Dive deep into quality
• What you should know

1. Getting Started

• 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

2. Querying SQL Data

• Setting up a site for testing
• Validate user workflows
• Validate data integrity
• Working through an example

3. Using SQL for Data Generation

• Create new entries in a table
• Update existing entries in a table
• Deleting data from a table
• Challenge: Data generation
• Solution: Data generation

4. Testing SQL Queries

• Transactions
• Field constrains
• Schema validation
• Security testing
• Performance testing
• Challenge: Database tests
• Solution: Database tests

Conclusion

• Next steps