From the course: SQL for Testers
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Deleting data from a table - SQL Tutorial
From the course: SQL for Testers
Deleting data from a table
- [Instructor] Sometimes testers do nasty things to an application. We can't help it, right? It's our job to try and break things. In this video, I want to show you how to, drum roll please, delete things from a database. It should go without saying, but I'm going to say it anyways, when you're deleting things, you're performing a destructive action. So please be careful with what you do. Now, I'm going to put together an imaginary scenario for you. Imagine that our database, it hooks up to another process and this process can remove products. So this is some kind of other part of the business, and it can remove products that are no longer available for the site. What we want to test is to see what will happen if the product is removed while someone already has that product in their cart. So let's try that scenario out. First of all, we'll add a product to our cart and then we'll go check the database, so we'll say select star from cart, and we can see that we have that product in our…
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.