Chapter 9. Performing Advanced Operations with Databases
Performing CRUD operations on databases are just the beginning in your database-learning journey. Besides creating, reading, updating, and deleting data from databases, there are other interesting things that you can do with databases, for example, searching for data, or even more, such as addressing data warehouse concepts.
This chapter explains the different advanced operations with databases. The first part of the chapter includes:
- Populating the Jigsaw puzzle database so it is prepared for the rest of the activities in the chapter
- Doing simple lookups in a database
- Doing complex lookups
The second part of the chapter is fully devoted to data warehouse-related concepts. The list of the topics ...
Get Pentaho Data Integration Beginner's Guide 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.
