Product was successfully added to your shopping cart.

Modifying Data With SQL

Be the first to review this product

About this Course


At the heart of a dynamic application is a database. Whether the application is an eCommerce, sports team, social network or a 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.

Details

What you'll learn

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

Adding Data to a Database

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

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.

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.

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.

Average Rating

0
0 rating

Ratings area

There is no rating area for this product

  1. Be the first to review this product

Write Your Own Review

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
Support
Cost
Video Quality

level:
Beginner
Language:
English
Institute:
TreeHouse
Trail Period:
14 Days