Hey people,
I've been wrecking my brain on learning SQL and I find it a little too confusing. I am currently learning MySQL from FreeCodeCamp.org 's YouTube channel
But I feel the IDE's they use is a little unnecessary. So I was wondering what is the most common "learning" environment and what language to use (I am good at Python and Web Dev with HTML, CSS and JS).
Also what I have learnt
Did some MySQL today, created an account, and learnt queries. But of course, I can't just take a course and expect it to be sufficient. So I am going to learn more of this in the following months.
Thanks!
Top comments (9)
I suggest starting with SQLite because it's super easy to get started and run on your computer.
All you need is DB Browser for SQLite. You can use it to create a SQLite database (which is just a file), browse it, and run queries on it. I find its UI simple and easy to use.
You can also get some pre-made databases here which you can open, explore, and run queries against.
As in, it is a python module and I had heard of it before. Thanks for reintroducing my brain cell to this :)
Oh! Is it a Python Module? Well that's useful. Thanks so much!
Like most database software, SQLite has packages available for most programming languages, including Python.
yes :)
The Oracle University has a free learning path of MySQL.
I could say a good way to learn is determine what you want to do with SQL, understand the basics and them get your hands dirty. You could try to model some project or doing challenges online.
Alright, I will try it out. Thanks!
Guys, stop looking at this, this is my first post and question, I'm genuinely worried on how you guys got here 😅
It has 100 views, like... Omg.