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.

Workshops

Understanding these core CRUID operations is essential for anyone working with databases, as virtually all database interactions can be categorized into one of these five fundamental actions.

CRUID

DB Connection

DB Connections

In this guided Workshop, you will:

Configure DBeaver / Pentaho database connections:

• Configure the Pentaho JDBC database connection.

Database Connections

Create

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 Workshop, you will onboard data from a CSV file into a database table:

• CSV File input step

• Table output step

Create DB

Read

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

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

Insert / Update

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