Adding Data to a Database
Databases aren't just for reading information out of, 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
5 questions
-
Databases with Frameworks
1:33
-
Modifying Data With SQL Review
10 questions
