Modifying Data with SQL Course (How To)

Adding Data to a Database

Databases aren't just for reading the information it contains, they're also for storing information. In this stage, we'll add data to a database table.

• Introduction to CRUD

  2:04

• Adding a Row to a Table

  7:27

• Adding Multiple Rows to a Table

  1:50

• Adding Data With SQL

  3 objectives

• Review and Practice

  1:21

• Adding Data to a Database Review

  5 questions

Updating Data in a Database

With dynamic applications, things change all the time. For example, the stock counts of products or the scores in a live soccer match. We need a way to update the data. In this stage we'll discover how to do just that.

• Update All Rows or Columns in a Table

  3:01

• Updating Specific Rows

  4:42

• Updating Data With SQL

  2 objectives

• Review and Practice

  0:55

• Updating Data in a Database Review

  5 questions

Deleting Data From a Database

There will come a time where you don't need certain data anymore. In this stage we'll look at removing all of the data from a table and how to remove specific rows too.

• Removing Data from All Rows in a Table

  1:27

• Removing Specific Rows

  3:17

• Deleting Data With SQL

  3 objectives

• Review and Practice

  0:57

• Deleting Data From a Database Review

  4 questions

Handling Errors When Manipulating Data

Sometimes you need to do multiple CRUD operations in a single go. This is where errors can occur. We'll tackle this with something called transactions.

• Introduction to Transactions

  3:14

• Rolling Back from Transactions

  1:15

• Transactions Review

  4 questions

• Databases with Frameworks

  1:33

• Modifying Data With SQL Review

  10 questions