How do I actually learn to become a software engineer

This has been bugging me since last week when I started taking my programming seriously. Now I don't know how and where to start in order to become a soft eng.

The issue is I know some basics of coding in vbasic, c#, java, and python, and a little bit of oop(not the intermediate or advanced level) but I don't know- how do I put this... I pretty much don't know how to develop fully functional and secure softwares with them. Like, I don't know how to connect a server or database(MS SQL, MySQL, SQLite, etc..) to my project, I don't know how to make an app with a database that runs locally(offline) on any device it is installed to. I don't know also how to make a secure online software.

I also know little to nothing about Git, DevOps, and API

And that typescript, node.js, next.js, and those frameworks like .NET, ASP or something(idk what that even is) and react. Like, I searched them up so I know them by definition but I just can't seem to understand how they work, what are their requirements, what makes them work, how important are they, and why they're so sought after.

I need help guys, do you have some kind of tutorial or guide(videos, books, or sites) that explains these kinds of things??