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.
DB Connection Create Read Update Insert Delete
In this guided Lab, you will:
Configure DBeaver / Pentaho database connections:
• Configure the Pentaho JDBC database connection.
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
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
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
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
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
