SQL for Testers

Go to class
Write Review

Free Online Course: SQL for Testers provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. SQL for Testers is taught by Dave Westerveld.

Overview
  • 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. 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