SQL for Testers

Offered By: LinkedIn Learning

Tags

SQL Courses Software Testing Courses Data Integrity Courses Database Security Courses Data Validation Courses Performance Testing Courses

Course Description

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

Related Courses

Cryptography I
Stanford University via Coursera MongoDB Advanced Deployment and Operations
MongoDB University Developing SQL Databases
Microsoft via edX Six Sigma Tools for Define and Measure
University System of Georgia via Coursera Using clinical health data for better healthcare
The University of Sydney via Coursera