Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Introduction to CRUD2:04 with Andrew Chalkley
Data isn't static, it changes over time. Databases allow you to modify that data over time.
Four Main Data Operations
At the heart of a dynamic application is a database.
Whether the application is an e-commerce, sports team, or social network site, or
even a productivity app on your phone, the data needs to change over time.
For example, if you run an e-commerce site, you'd want to search for
products, update stock counts, create new orders or
new products in your database and remove all discontinued products.
The site is dynamic because its state changes all the time.
In short, there are four main operations that you'd want to perform on data
in a database.
Firstly, you want to be able to create or add data to a database.
Secondly, you want to read the data.
Reading would include searching and filtering the result set.
Thirdly, you'd want to update or edit rows of data in any of the tables.
Finally, you need to remove the data or delete the data.
These four operations create, read, update and
delete are shortened to the acronym CRUD.
I am Andrew, a Treehouse teacher, developer,
and life long learner, and welcome to this course.
In this course we're going to focus on inserting, updating and
deleting rows of data from our database tables.
Each of the CRUD operations has an SQL keyword associated with it.
If you've taken the prerequisite course, or have experience querying a database,
you should be familiar with reading from the database using the select keyword.
We will be covering that again in this course.
If you haven't taken the prerequisites or
are new to databases, I'd recommend you go and take them now.
Like before, we'll be using Treehouse's interactive SQL database environment,
Be sure to launch each new SQL Playground with each new video.
In this stage,
we're going to take a look at creating new rows of data in our tables.
You need to sign up for Treehouse in order to download course files.Sign up