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

LinkedIn Learning

SQL for Testers

via LinkedIn Learning

Write review
Scrimba Ad

Free courses from frontend to fullstack and AI

Learn More → Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates 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 2228 ratings

Start your review of SQL for Testers

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.