You need to disentangle your expectations of yourself from what other people are expecting from you.
You have every right to feel uncomfortable about this situation, simply because from your life experience so far (as you have described it, at least) this is a new situation for you. You have spent a long time being educated. Education often works by teaching you how to do something and then asking you to do it. This is a comfortable situation: "We won't ask you to do something you don't know".
After this, having to do something that you really have not studied and really do not know how to do is naturally rather a shock.
First thing: eliminate guilt about not having studies these subjects earlier. It is not doing anything useful, and you can't go back in time.
The next thing is that this is going to be a good step in finding out who you are. Some people are at their best doing what they know how to do, becoming more and more expert at it throughout their lives. For others, the delight is to be always doing something that they do not already know how to do. I know a plumber who sorts out people's PC catastrophes for them: he has never trained for it, but he loves learning new things. I have just been proof-reading and editing some texts in Malagasy, a language which I do not know at all. It was tiring, but I enjoyed the challenge.
Some people are one way, some are the other way. There is no dishonour about being one as opposed to the other.
The one valid concern you have is that your advisor may be misunderstanding your level of knowledge. If you think your advisor thinks you are expert in fields that, in fact, you know nothing about, then you need to correct that impression. But don't do it in terms of "I can't do it because I haven't been trained". Do it in terms of "I don't know this or that subject, so I will have to get up to speed on them in order to get this work done". That way your advisor has been warned there is a risk that you may need extra help; but will also be encouraged by seeing someone who wants to learn and is willing to learn.
If I were you, I think I would go ahead with the job. But it is your decision. Just make it for the right reasons. Don't include any guilt about not having done the right courses before. That isn't relevant. And don't include too much worry about not being 100% successful, or taking longer than you should. As long as your advisor has been warned, you will not be letting anyone down.