Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
What is CRUD?1:55 with Alena Holligan
At the heart of a dynamic application is a database. The acronym CRUD refers to all of the major functions that are implemented in relational database applications - create, read, update and delete.
CRUD for Database Applications
The acronym CRUD refers to all of the major functions that are implemented in relational database applications. Each letter in the acronym can map to a standard SQL statement:
Although a relational database provides a common persistence layer in software applications, numerous other persistence layers exist. CRUD functionality can be implemented with an object database, an XML database, flat text files, custom file formats, tape, or card, for example.
[SOUND] Hi, I'm Alina.
I'm happy that you've chosen to join me today.
In this course, we'll delve into the full spectrum of database interactions.
At the heart of a dynamic application is a database.
Whether the application is an e-commerce or social network or
even a to-do 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 the products,
update stock counts, create new orders or
new products in your database, and remove all discontinued products.
The site is dynamic because the state changes all the time.
CRUD is an acronym that refers to the four main operations that you'd want to perform
on data in a database.
First, you want to be able to create or add data to a database.
Second, you want to read the data.
Reading would include searching and filtering the results.
Third, you'd want to update or edit rows of data in any of the tables.
Finally, you need a way to delete the data or remove the data.
These four operations, create, read, update, and
delete are shortened to the acronym CRUD.
In this course, we're going to focus on creating, updating, and
deleting rows of data from our database tables.
Each of the CRUD operations has a SQL keyword associated with it.
If you have experience querying a database,
you should be familiar with reading from the database using the select keyword.
We'll also use select again to create reports for our data.
If you haven't taken the prerequisite and
are new to databases, I'd recommend that you go and take them now.
We'll use Treehouse workspaces, so you can choose launch workspaces to follow along.
Alternatively, you can download the project files as well and
work on your own machine if you prefer.
Next, we'll take a look at the finished project.
You need to sign up for Treehouse in order to download course files.Sign up