There are a number of fairly polite expressions that could be used:
He is full of his own importance.
He is too big for his boots.
He is a legend in his own mind.
There is an extremely impolite expression that I couldn't repeat here, but it concerns the same substance you mention and its aroma!! Je suis sūr que vous pouvez le deviner
Student or Learner