The final exam covers the entire lecture. It is an in-person, open-book exam during the examination period and takes place for the first time in 2026. I believe that the best preparation for the final exam is to attend the lecture and keep track of the topics discussed in the lecture.
I assembled a list of practice exam questions for the final exam 2026 (with solutions and for practising without solutions). Be aware that the final exam is a 1h exam (open book) and therefore much shorter than this list. The final exam questions are similar in style, but they are substantially different questions, so I more than anything else recommend to work through the lecture material (Units 1-8, excluding the section "SQL" in Unit 8) as exam preparation.