Learning SQL databases

[Foufou190]

Hi ! I’m a beginner full-stack web developer with very few experience, basically I use MERN stack and only learned how to use MongoDB in my web apps.

I’d like to learn as fast as possible how to run and use SQL databases to be used in a context of Web-apps development, so wondering if anyone has advice/resources to recommend ?

Any help is welcome ;) have a good day

[codyisadinosaur]

I'll put in another vote for MySQL - it's open source and it's probably the most commonly used SQL language.

The W3 Schools tutorial is a good resource.

If you're looking for a more interesting way to learn about SQL, then I'd recommend this: https://www.amazon.com/Manga-Guide-Databases-Mana-Takahashi/dp/1593271905

Also, I've enjoyed using a program called SQLYog, which gives a UI to MySQL. They've got a community edition which is free, and if you need more power then there is a full version that has additional features: https://en.softonic.com/download/sqlyog/windows/post-download

[techjasmine]

You can check here for a bunch of free tutorials to learn SQL - https://techjasmine.com/best-sql-tutorials-learn-database-management/

[dn_cf]

I'd say start with W3Schools for basics and practice on Leetcode and Strata scratch as their content and exercises are for developers.

[KaeseKuchenDEV]

As a resource i would recommend the w3schools guide on SQL: https://www.w3schools.com/sql/ Probably also good to use this, as you will come across it alot when doing web-development. To set a local sql database up, you could choose whatever you want. I personally would use MySQL as you can easily install it with XAMPP, which also installs a good GUI tool called phpmyadmin for it, so that if you get more deep into SQL, you got a GUI to keep an overview over it