Alex Mang, our trainer for the SQL Course, in my opinion, did all of that and a lot more. He is a passionate guy that loves the Microsoft technologies. One of his great assets is that he speaks from experience not from things he read in the books, he knows which material is more important in practice and knows where to insist.
The course was structured in two fun days, approximatively one month apart. The first day was a recall of core SQL concepts that many of us tend to forget and the second day was focused more on the performance optimisation of T-SQL. The material was split in theoretical and practical parts, so each chapter contained slides that were discussed and the matching practical exercises to understand better the theoretical part. For me this is a great approach which engages the participant to use their short memory in order to understand the key concepts better and to transfer them into the long memory.
The most valuable part for me was to have the opportunity to talk to such a prolific guy as Alex, be it answering questions or just talking about business or Microsoft technologies in general.