Performing Create, Read, Update and Delete (CRUD) operations on databases is just the beginning in your database-learning journey. Besides that, there are other interesting things that you can do with databases, for example, addressing data warehouse concepts. This chapter is fully devoted to data warehouse-related concepts. The list of the topics that will be covered includes the following:
- Introducing dimensional modeling
- Learning the basics of dimensions
- Loading a different kind of dimensions including time, junk and mini dimensions
- Loading slowly changing dimensions Type I and Type II
- Learning the basics of fact tables
- Loading cumulative and snapshot fact tables