Modifying Data with SQL Course (How To)

At the heart of a dynamic application is a database. Whether the application is an eCommerce, sports team, social network, or productivity app on your phone, the data needs to change over time.

In this course, we'll take a look at the underpinning SQL statements that are needed for every dynamic application.

What you'll learn

• Inserting rows of data
• Updating data for specific entries
• Removing data from any table
• Understanding transactions for data integrity

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.

Chevron 6 steps

• 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.

Chevron 5 steps

• 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.

Chevron 5 steps

• 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.

Chevron 5 steps

• 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