Chapter 9. Performing Advanced Operations with Databases
In this chapter you will learn about advanced operations with databases. The first part of the chapter includes:
Populating the Jigsaw puzzle database so that 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 datawarehouse-related concepts. The list of the topics that will be covered includes:
Introducing dimensional modeling
Loading dimensions
Preparing the environment
In order to learn the concepts of this chapter, a database with little or no data is useless. Therefore, the first thing you'll do is populating your Jigsaw puzzle database.