This chapter discussed how to use PDI to work with databases. Specifically, the chapter covered the following:
Introduction to the Pentaho Sample Data Steel Wheels—the starting point for you to learn basic database theory
Creating connections from PDI to different database engines
Exploring databases with the PDI Database explorer
Basics of SQL
Performing CRUD (Create, Read, Update, and Delete) operations on databases
In the next chapter you will continue working with databases. You will learn some advanced concepts, including datawarehouse-specific operations.