SQL for Testers
1h 33mBeginner2020-09-15
Authors
Dave Westerveld
Test Developer with many years of testing experience
Course details
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.
Learning objectives
Getting set up with the tools you need
Writing SQL queries
Validating workflows and data with SQL
Generating test data with SQL
Finding bugs in transactions
Validating schema
Security and performance testing
Learning objectives
Getting set up with the tools you need
Writing SQL queries
Validating workflows and data with SQL
Generating test data with SQL
Finding bugs in transactions
Validating schema
Security and performance testing
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementPersonaData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware Development
Concepts
0. Introduction
- 01 - Dive deep into quality
- 02 - What you should know
1. Getting Started
- 03 - What is SQL and why use it as a tester
- 04 - Getting setup with the tools you need
- 05 - Getting started with SQL queries
- 06 - Understanding more complex SQL queries
2. Using SQL for Validation
- 07 - Setting up a site for testing
- 08 - Validate user workflows
- 09 - Validate data integrity
3. Using SQL for Data Generation
- 10 - Create new entries in a table
- 11 - Update existing entries in a table
- 12 - Deleting data from a table
- 13 - Challenge - Data generation
- 14 - Solution - Data generation
4. Testing SQL Queries
- 15 - Transactions
- 16 - Field constrains
- 17 - Schema validation
- 18 - Security testing
- 19 - Performance testing
- 20 - Challenge - Database tests
- 21 - Solution - Database tests
Conclusion
- 22 - Next steps