Introduction to SQL CRUD Basics
Are you familiar with CRUD operations? If not, are you interested in what they are? Moreover, what they are used for? Confused? In this particular sense of the word, CRUD applies to a specific set of operations in data storage. This post is an introduction to a planned series of posts, in which I’ll focus on the SQL database aspect of its meaning. Actually, CRUD is an acronym that stands for: Create, Read, Update, Delete.
Why is CRUD important for those interested in learning SQL? Each individual letter part of the acronym stands for a word that is in fact, a basic — and important — SQL operation.
Before proceeding, let’s see how Wikipedia defines CRUD: Wikipedia defines CRUD as this:
“In computer programming, create, read, update, and delete[1] (CRUD) are the four basic functions of persistent storage”
So how do these 4 basic functions relate directly to SQL?
- Create: Without rows of data, a database table doesn’t provide much value. The purpose of a table is to house data. But, how are new rows introduced into a table? With the statement. As we will see, can create multiple rows of data at a time.
- Read: When a table has rows of data, generally that information is used as part of another process — or several — over its lifetime. How can you see the stored data…
