SQL classes got erased as i have not completed yet?

I am starting to complete the sql videos but i could not see the advanced sql concept ,can you please tell me where to get thecontent for the advanced sql topics like lead and log, date and time function etc .... I would grateful, if you could resolve my query.