Codecademy is mostly a teaching platform. To create your own software, you are better of setting up a local development environment.
Vscode seems to be really popular, you can use the text-editor to write html, css and JS. as for SQL, depends on the database engine. Mysql can be a good starting point, if you use windows, xampp might be easy to get started with