I think this is a lecture on concepts that are generally experienced and not directly used. I found it very informative, and I feel a little embarrassed that I only knew how to write general queries. Thank you for the great lecture :)