CRUID

CRUID database operations are a set of five basic functions that allow us to manipulate data in a persistent storage system, such as a relational database.

CRUID stands for: Create, Read, Update, Insert, and Delete, and each letter corresponds to a standard SQL statement or HTTP method.

CRUID operations are essential for any application that needs to store and retrieve data from a database.

CRUID

Workshops

DB Connection

In this guided Lab, you will:

Configure DBeaver / Pentaho database connections:

• Configure the Pentaho JDBC database connection.

Database Connection

Create

To create a new record in a database, we can use the INSERT statement in SQL or the POST method in HTTP.

In this guided demonstration, you will onboard data from a CSV file into a database table:

• CSV File input step

• Table output step

Create DB

Read

To read data from a database, we can use the SELECT statement in SQL or the GET method in HTTP.

In this guided demonstration, you will Read from a database table to determine the state of customer orders:

• Table input step

• Calculator step

• Number range step

• Sort

• Select values

Read DB

Update

To update an existing record in a database, we can use the UPDATE statement in SQL or the PUT or PATCH method in HTTP.

In this guided demonstration, you will Update fields (Type1) in the employee table:

• Update step

Update DB

Insert

To insert data into an existing record in a database, we can use the MERGE statement in SQL or the PATCH method in HTTP.

In this guided demonstration, you will Update database fields and Insert new records into the employee table:

• Insert / update step

Insert / Update DB

Delete

To delete a record from a database, we can use the DELETE statement in SQL or the DELETE method in HTTP.

In this guided demonstration, you will Delete records based on a criteria set by a parameter and passed in a variable:

• Get variables step

• Delete step

Delete DB