What app to use for creating videos?

Hello,

I have Creative Cloud but pretty much just use Photoshop, Illustrator, and InDesign. My son is wanting to start making videos to put online. The kind that has a screen capture of what he is doing on screen and then also a picture in picture type of setup to show him in the corner of the screen. I started looking to see what kind of software could be used for that and then thought, "hey, I have CC. Surely Adobe has something that can do this...."

Can someone point me to the right app(s)? I can look for tutorials and see if it is something he can use.

Thanks!