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.

The SQL programming language opens the door to deeper and more efficient software testing. SQL allows testers to examine the back end of application, automate testing through scripting, and simplify and speed up data generation. This course provides a quick-start guide to database testing with SQL. Dave Westerveld shows how to choose the right tools, set up a local site, and start validating data using simple SQL table joins. Next, you can learn how to generate test data by creating, updating, and deleting table entries. Finally, learn how to test SQL queries and find bugs in transactions, implement field constraints to prevent future bugs, and use schema validation to improve the quality of your application. Plus, find out how to prevent unauthorized access to data and measure the runtime of your queries to make sure you're not impeding database performance.

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. Using SQL for Validation

• Setting up a site for testing
• Validate user workflows
• Validate data integrity

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