Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
SQL for Cyber Security
·
Module 5
Modifying Data (DML)
1
Inserting Data with INSERT Statements
Write INSERT statements to add single and multiple rows to a table.
2
Updating Specific Rows with WHERE
Write UPDATE statements with a WHERE clause to modify specific rows.
3
Deleting Specific Rows with DELETE and WHERE
Write DELETE statements with a WHERE clause to remove specific rows.
4
Accidental Data Loss: The Peril of Missing WHERE Clauses
Demonstrate the destructive impact of running UPDATE or DELETE without a WHERE clause on a test table.
5
Database Record Manipulation Practice
Practice manipulating records in a simulated user management database.
Previous module
Advanced Queries with Subqueries
Next module
Database Reconnaissance and Permissions