Please read 9.3, 9.4, 9.5.
Please read all of Chapter 10 (But you can skim most of 10.5 and not worry about the methods for calculating the costs of joins – all you need to worry about in this section are what it means to execute a join using nested loops in the two ways presented in 10.5 and how to execute a join using sort-merge). You can skip 10.6.
Also read Chapter 11, but do not worry about 11.4.
Please read Chapter 13, but do not worry about 13.6.