SQL CRUD Basics Part 4 – Delete.

In this final part of the SQL CRUD Basics series, we visit the all-mighty and powerful DELETE command. Does that word frighten you? It should, as DELETE will completely remove rows of that oh-so-important data from your database table. Without warning or question, it will be gone. Perhaps your goal is to remove all rows. Great, no problem. However, removing a specific row or set of rows – instead of them all – requires filtering with a WHERE clause predicate, just the same as you would in SELECT and UPDATE statements. Continue reading to see DELETE command examples for better understanding…

[Keep reading for more SQL database and Python-centric content >>>]
Advertisements

SQL CRUD Basics Part 3 – Update.

Some data may never change. Yet, other data will change. In SQL, you modify existing rows of data with the UPDATE command. UPDATE is a powerful command as it can potentially change multiple rows of data in a single execution – for better or worse. UPDATE is categorized as a DML command which means: Data Manipulation Language. Let’s learn how to use this integral command with examples…

[Keep reading for more SQL database and Python-centric content >>>]

SQL CRUD Basics Part 2 – Read

In SQL CRUD Basics Part 1 – Create, we learned how to create new rows of data in a database table with the INSERT statement. In this post, we are going to visit the busiest statement in SQL – SELECT. If you want to view or read the stored data in a table, you use SELECT.

[Head this way for great SQL and Python-centric blogging >>>]

SQL CRUD Basics: Part 1 – Create

In Introduction to SQL CRUD Basics, I listed out the 4 elements of CRUD. Create is the first and the subject of this post. Create relates to the SQL INSERT statement, which is used to introduce new rows of data into a database table. Continue reading to learn basic usage of this first CRUD element.

[Head this way for great SQL and Python-centric blogging >>>]

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.

[Keep reading for more SQL database and Python-centric content >>>]