Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Modifying Data with SQL

Well done!

You have completed Modifying Data with SQL!

Sign up for Treehouse Back to Library
Preview
Video Player
00:00
00:00
00:00
  1. 2x 2x
  2. 1.75x 1.75x
  3. 1.5x 1.5x
  4. 1.25x 1.25x
  5. 1.1x 1.1x
  6. 1x 1x
  7. 0.75x 0.75x
  8. 0.5x 0.5x
Use Up/Down Arrow keys to increase or decrease volume.

Review and Practice

0:57 with Andrew Chalkley

Let's review deleting rows in different ways and practice the different techniques.

You now know all CRUD operations, create, read, update, and delete, awesome. 0:00
To recap, to remove onrows from the table, you can write DELETE FROM <table>. 0:07
This removes every single entry in the table you specify. 0:14
To remove only the rows that match a particular condition, 0:18
you can use a where clause with any number of conditions. 0:22
Any rows matching the condition will be permanently removed. 0:27
Once again, to practice deleting rows 0:32
I've created a SQL playground with some more tasks for you to complete. 0:35
Familiarize yourself with the schema and the data and then complete the tasks. 0:39
You're finished with the main operations that CRUD has to offer, well done. 0:45
In our final section, we're going to look into handling multiple CRUD operations and 0:49
dealing with errors that you could encounter. 0:54