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.