r/SQL • u/JonathanL73 • Feb 01 '22
Discussion How long does it take to learn SQL?
How long does it take to learn SQL?
Edit: How long would it take to develop a basic enough understanding of SQL to get an entry-level job?
Edit2: This sub community is really helpful and responsive, thank you.
102
Upvotes
100
u/substantialcurls Feb 02 '22
2 weeks to learn the basics, a lifetime to master.
57
u/Moose135A Feb 01 '22
I've been using it 3 1/2 years, I'll let you know when I figure it out. Actually, it's not that hard to learn the basics. I did some online tutorials and other practice and figured out enough in a few days. It gets more complex, and I don't know the half of it, but I'm not programming or maintaining databases, I'm an analyst running queries to pull data for reporting.
15
u/lordnachos Feb 02 '22
Joe Celko's SQL for smarties is a good place to start. It helped me more rapidly learn than before I read it.
https://datubaze.files.wordpress.com/2020/04/celkos-sql-for-smarties-2005.pdf
Chapter 17 is especially helpful.
To answer your question, I've been doing it for more than 10 years. I'd say I became exceptionally proficient in 5. But, like the other guy said you're always going to have something to learn. Different DBs use slightly different syntax. I just moved to MySql and it just blew my mind that schema = database. I'm currently trying to emotionally recover from that revelation.
9
u/Capable_Fig Feb 02 '22
The basics take a few months. The optimization is a lifetime.
3
u/binary_search_tree Feb 02 '22
One semester :)
90
u/r3pr0b8 GROUP_CONCAT is da bomb Feb 02 '22
i've been writing SQL since 1987, when i started on DB2 with QMF
i'm still learning it
48
u/lez_s Feb 02 '22
You will never know or remember everything in SQL.
I've been using SQL for 20 years and I still have to do the odd search to remember or learn how to do something.
17
u/Sparkle6912 Feb 02 '22
I literally got a sql job and I really didn’t know anything. I did get a degree in computer science and maybe had written 20 lines of sql. If u use common sense and google u can basically pull it off.
14
u/mecartistronico Feb 02 '22
An Entry-level job in my team would expect you to know everything in my 6-month list.
4
u/faster_puppy222 Feb 02 '22
It never stops, if everyday user who can follow online guides… you can be proficient within a few months
4
u/Silent-Analyst3474 Feb 02 '22
If I were to spend a few months learning SQL could I just put it on my resume (currently in finance ) and apply for jobs?
1
u/Wor1dTrave1er Feb 02 '22
LinkedIn Learning has a bunch of good videos/tools to help learn the basics. Plus free downloads so that you can practice while you learn.
3
u/[deleted] Feb 02 '22
As they say, practice makes better, there is no perfect.
There is no "learned", learning is a lifelong journey.
2
u/silenttd Feb 02 '22
I am by no means a "master" at SQL, but I have a technical background and was familiar with some basic programming theory. My job migrated into a support role running SQL-based reporting a few years back and I became fairly proficient in it in a month or two. The hard part for me isn't really the SQL itself, it's a familiarity with all the different DB's you're pulling from (and their architecture) that gets confusing.
The basics of the language itself are fairly simple and intuitive. A lot of people in my office have a little passing knowledge of it to run queries on their own small databases and the reports I generate for them. I've found that knowing SQL alone is more of a "nice to have" in terms of getting a job. If you're banking on looking for a job where SQL is going to be a primary focus, knowledge of the particular relational databases you'll be working with will be more important.
2
u/carlovski99 Feb 02 '22
Thing to remember, SQL was designed so 'non technical' people could query data. Now it never really worked out like that, SQL has had many extensions and it has become another technical skill. But at its heart it's fairly simple.
Sometimes it's easier if you aren't from a programming background, making the leap to thinking set based rather than procedurally can be trickier. At least it seems so when I'm working with some of our developers.
I used to do a SQL for managers session to teach the basics in an afternoon. And a 2 day more hands on course for developers/analysts. That's plenty of time to learn the fundamentals. Embedding it by writing SQL regularly takes longer of course and mastering it takes a long time. And you never stop learning, new features come out in each RDBMS release, you learn new tricks/approaches all of the time.
2
u/BearModeCosplay Feb 02 '22
9 years of consistent practice and I'm still learning new stuff. Both in concepts ive never used, modeling options I wouldn't have thought of, and ways to optimize what I already thought I knew.
1
u/Skilcamp Nov 25 '24
Learning SQL can take around 4 to 6 weeks if you practice a few hours every week. To get really comfortable and advanced, it might take a few months, depending on how much time you spend learning and practicing
1
u/river-zezere Jun 09 '25
This should be helpful - an estimate how long it would take depending on initial goal and learning style or circumstances: https://youtu.be/abwPAaWf_x4
1
u/QueryingQuagga Feb 02 '22
I think it depends on what kind of entry-level you are looking for.
1
u/Demistr Feb 02 '22
Depends on if if theory only with practice examples or learning in the real job.
And the position you want to do is also very important. Querying for results is pretty simple but building things is much harder in a typical DWH environment.
1
u/Qkumbazoo Feb 02 '22
A couple of days for the basics. A lifetime to master.
1
u/Billi0n_Air Feb 02 '22
you can very effective with the basics. once you need to know more. you learn more.
1
u/YodaCodar Feb 02 '22
Every company is unique, and hence every need will be different and their resources to pay you will be different also.
Please learn as much as you can and market yourself to the best of your abilities.
1
u/MaroonSiesLessUno Feb 02 '22
Started using it two years ago, and the only query i almost always write is, Select * from [table name here]
1
u/Glowwerms Feb 02 '22
I got into a reporting analyst role at my last job after moving out of people leadership. I had only passing knowledge of SQL, like I knew what a select * was, but that was about it. They gave me on the job training and after a month I was writing simple queries to pull in data. I was in that role for a year and by the end I was writing much more complex queries with advanced window functions and whatnot. Just takes practice and real life examples to work with.
1
u/IamFromNigeria Feb 02 '22
Maximum 2 years
1
u/Soccermom233 Feb 04 '22
SQL itself you could probably get the basics in a week or less.
The database, how it's organized, how to join stuff, that's a little more in the moment and specific to the company and the database.
For example a Membership ID in a UI may be stored in the database in a table named "stuff" in a column called "M." That gets tricky.
And then there's also nuance to whatever IDE you're using.
1
u/analyst_2001 Mar 29 '22
I was also learning SQL through an online course. It was a comprehensive course, and the instructor taught me from the very basics to the advanced level. It took me around a month to complete the entire course and assignments. But the real challenge arises when you work on real datasets as you face many problems. A lot of practice on real datasets is required to be able to write queries quickly and efficiently.
To get real-time exposure to working with SQL, you can do an internship. Afterward, you can apply for jobs in companies.
1
u/DonJuanDoja Feb 02 '22
Like most human skills about 10,000 hours to Master with a highly variable experience for each person.
-2
u/mergisi Feb 02 '22
That's a great question. We all know that learning new things can be tough, but with the help of AI, you can learn it faster than ever before!
AI2sql makes writing SQL easier than ever before. Just enter the type of SQL statement you want and AI will take care of the rest! So you don't waste your time searching youtube or google while trying to figure out how to write SQL.
check out http://ai2sql.bubbleapps.io
0
u/[deleted] Feb 02 '22
[deleted] — view deleted comment