Performing Basic Operations with Databases

Database systems are the main mechanisms used by most organizations to store and administer organizational data. Online sales, bank-related operations, customer service history, and credit card transactions are some examples of data stored in databases.

This is the first of two chapters fully dedicated to working with databases. Here is a list of the topics that will be covered in this chapter:

  • Connecting to a database and exploring its content
  • Previewing and getting data from a database
  • Inserting, updating, and deleting data
  • Verifying a connection, running Data Definition Language (DDL) scripts, and other useful tasks
  • Looking up data in different ways

Get Learning Pentaho Data Integration 8 CE - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.