First time having sex!

so, me and my boyfriend have waited awhile to have sex bc I just wasn't ready, but...now i am. I have these scenarios in my head and how it's gonna go mostly based off of movie or things I've seen online so what should I truly be expecting? what's it like? I'm nervous I'm gonna make a fool out of myself!