From the course: SQL for Testers
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Validate user workflows
- [Lecturer] Now that you have the testing practice site set up, let's look at how you can use SQL as a tester to validate a user workflow. Now, this is obviously a very simple site, so let's take a look at a very simple cart workflow. Now, first we need to sign in so that we know what user the cart is associated with. And for this let's use fakeuser1@gmail.com and the password one, two, three, four, five, and we can use that to login. So now let's add and remove something from the cart and validate the steps with some SQL queries. So first we'll click on a T-shirt and add it to the cart. And then in the database, let's select everything from the cart table and see what we got. I can see that this user ID one has product ID two added to the cart. So let's look at the product table now to get an idea of how that, what that product idea is, what details it has. So we'll say select star from products where product ID…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.