SQL: CRUD

This entry is part 5 of 20 in the series SQL Tutorial

The acronym CRUD (create, read, update, delete) refers to the major functions that are implemented in relational database.  Once you have mastered these 4 functions, you will be quite proficient in manipulating the database, just like manipulating the DOM in web programming.

FunctionSQL
createinsert
readselect
updateupdate
deletedelete

In the earlier examples, we have already used insert into and select statements.

In the upcoming posts, we will delve further into the select statements.

SQL: Basic Database Programming

This entry is part 1 of 20 in the series SQL Tutorial

SQL is a special programming language designed for managing data.

There is an ANSI standard but codes are always not portable among the different database systems.

For example, the statements that you have written for Sybase might not work if you use it to query an Oracle database.

In SQL, we always say that you only need to know the most common functions which are known as CRUD, create, read, update and delete.

If you are new to database, CRUD are just the functions that you need to learn.