Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

SQL for Testers

via LinkedIn Learning

Write review

DataCamp

PowerBI Data Analyst - Create visualizations and dashboards from scratch

Scrimba

Free courses from frontend to fullstack and AI

Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Unlock All Certificates

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

Syllabus

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

Taught by

Dave Westerveld

Reviews

4.7 rating at LinkedIn Learning based on 1963 ratings

Start your review of SQL for Testers