How to learn SQL

Answer 1

By learning and studying the language. I believe there's no order way than that, is there?

Answer 2

Answer to this question should consider 2 factors, whether you will be working with local databases or will you be working in and through a network.

If you're working in and through a network, you ideally should have a DBMS application (database server application) installed on a machine where you can practice and experiment with what you've read or viewed. If you're working with local databases then there are other ways, as some languages apparently have internal support for SQL.

Learning without practice, like most of us know already, is like building a house only to be abandoned, it will eventually break and be ruined with time.

You can choose whichever route you feel comfortable with in learning, but in the end, without practice, what you learned will diminish, so don't forget to practice. Practice also allows us to experiment and improvise by making changes here and there, and learn what the changes bring and how the changes affect the outcome : )

Answer 3

Ipang you don't really need a server, I use sql within python codes, and store data in files, works perfectly fine for practicing

Answer 4

Ipang I didn't mean it like that, you wrote 'you should have a...', but she doesn't need to, should means she has to use it, that's how I meant it

Answer 5

Aymane Boukrouh
Yes, I understand now, I guess I need to revise my response : )

I answered that way was just because that's how I learned it, I did use local files, but back then I was using MS Access for local database, and I didn't know Python had internal support for SQL : )

(Edit)
I have edited my response.

Answer 6

Now you do :p

Answer 7

Aymane Boukrouh
The question was just "How to learn SQL", there is no detail as how the OP was working with SQL. Is s/he working on a local computer using local files, or through a network?.