DEV Community

Cover image for The best way to learn SQL?
Wj
Wj

Posted on • Updated on

The best way to learn SQL?

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)

Collapse
 
mistval profile image
Randall

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.

Collapse
 
wjplatformer profile image
Wj

As in, it is a python module and I had heard of it before. Thanks for reintroducing my brain cell to this :)

Collapse
 
wjplatformer profile image
Wj

Oh! Is it a Python Module? Well that's useful. Thanks so much!

Collapse
 
mistval profile image
Randall

Like most database software, SQLite has packages available for most programming languages, including Python.

Thread Thread
 
wjplatformer profile image
Wj

yes :)

Collapse
 
guithomas profile image
Guilherme Thomas

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.

Collapse
 
wjplatformer profile image
Wj

Alright, I will try it out. Thanks!

Collapse
 
wjplatformer profile image
Wj

Guys, stop looking at this, this is my first post and question, I'm genuinely worried on how you guys got here 😅

Collapse
 
wjplatformer profile image
Wj

It has 100 views, like... Omg.