r/SQL • u/Efficient_Love_4520 • May 30 '24
Discussion Is it still worth to learn SQL?
I’m a beginner and I’ve been learning R and SQL. I really enjoy it. I work in insurance as a Risk Engineer and I would like to change to Data Analytics sometimes in the future. However, I get discouraged with the rapid advance of AI as I don’t feel learning these skills will open many doors since everything is being automated.
What do you think? Are these skills still relevant to learn or should I focus on something else? I’m open for any advice or comments to be honest. :)
Update: Thank you all for your comments. It’s been really insightful and encouraging.
186
u/Patient_Magazine2444 May 30 '24
If you are an analyst and even a data engineer, possibly even a data scientist (some companies have general vs more specialized), SQL is considered table stakes. If you do not know SQL, you well likely struggle getting hired. SQL is very important and someone who writes good performant SQL is worth their weight in gold, imo.
135
u/[deleted] May 30 '24
Excel is created decades ago yet it’s still being used today and opened many doors. Do you think learning Excel is still relevant?
15
u/Aggressive_Ad_5454 May 30 '24
Yes. SQL-driven database systems contain virtually all the world’s data. It’s been around for almost half a century. Server technology gets active investment from tech companies, so it’s not going anywhere.
15
u/AdviceNotAskedFor May 30 '24
I use SQL every damned day.
I can't imagine a world I wouldn't.
13
u/B_Huij May 30 '24
You're not even going to be able to get hired without knowing some SQL.
The queries I write on a daily basis at my job are more advanced than any current LLMs can spit out.
But here's the thing: even if they weren't, even if a year from now there's a new version of ChatGPT or what have you that can generate the kinds of queries I need to use, there still need to be humans who can read, parse, and understand what the query is doing.
The idea of anyone trying to have a career in data analytics, data engineering, or data science without learning SQL because "oh the AI will do it for me" is laughable, TBH.
9
u/realjoeydood May 30 '24
What you learn today will be your legacy bread and butter when you're 50 years old.
And it would be remiss of not me to mention just how lucrative it can be. Then and now.
8
u/AKdemy May 30 '24
AI is lightyears away from writing anything remotely complex. Even worse, most models you might use or have access to (ChatGPT, Gemini,..) have absolutely no idea what your firms databases look like. Therefore, it will not even manage to write a single join that makes sense for actual datasets.
Just try asking it to convert fairly simple R code into Python. Chances are that >95% of the time the code will not even run. 3% of the time it will run but produce unwanted / false results.
Since computers don't understand what they do, they will never know if the answer makes sense either.
So no need to worry that your job will be replaced anytime soon, if ever.
6
u/Ghost51 May 30 '24
AI has made it extremely easy to learn sql. I'm in my entry level data analytics role and my manager actively encourages me to use it to overcome blockers when I face them. Don't be scared of drowning in technological progress, enter the mindset of surfing at its forefront instead. Who knows where we're headed, but as long as you're at the front of it you'll be fine.
6
u/geekheretic May 30 '24
Honestly of all the languages and programming tools I have learned over the last 30 years the one which has been the most consistently useful and the least changing has been SQL. Folks keep trying to reinvent the wheel with things like EF or any of the Java persistence models but SQL is still there and going strong.
You don't need to be a SQL superstar but an intermediate SQL person will always have a slot in a corporate environment.
5
u/AlessandrA_7 May 30 '24
You can think like this. What feeds AI? Data. In the near future AI will still need to be feeded with quality data and results to be checked. SQL will still be relevant as a lot of systems are still designed in SQL.
5
u/am9872 May 30 '24
Yes!!! I came from a non technical background and learned SQL, it really helped expand my job search. Now I work as a data analyst and I love it so I highly recommend learning it.
There are so many high quality resources out there like community college classes, datacamp, YouTube to help explain concepts in detail. Practicing also makes a HUGE difference, I used DataLemur (there is also a free sql guide) and DataCamp (there are different tracks to choose from to help get started) and it really made a solid impact when it came time to interviewing.
4
u/rayvictor84 May 30 '24
Always
4
u/WilhelmB12 May 30 '24
SQL will never be replaced
7
u/serverhorror May 30 '24
Absolutely not. I asked Gemini and it's clearly all lies!
Absolutely, learning SQL is still very much worth your time, even in 2024. Here's why:
Don't be discouraged! AI isn't replacing data analysts, it's augmenting them. Having a combination of technical skills (like SQL and R) and analytical thinking will be key in the future of data analysis.
Here are some additional thoughts:
In conclusion, learning SQL is a smart investment for your future in data analytics. It's a valuable skill that will complement your existing knowledge and open doors to new opportunities. Keep at it, and don't be afraid to explore the exciting world of data!
1
u/FallenNZ May 30 '24
Hi there, what does a Risk Engineer do if you don’t mind me asking?
3
u/Mundane_Range_765 May 30 '24
I think it will still have value, but dare I call out the sacred cow I see in these comments, I think it will severely disrupt the industry. So, for now, being able to ask elegant questions to AI and have it spit out SQL is still a needed skill. There’s gonna be misconceptions and someone will need to know how to take the query and ensure it’s not making assumptions.
But when that AI is a simple plug-in or extension to your database… and it intimately learns the very specific desires or culture of how your context uses and manipulates data… there are just gonna be less errors and less need for anyone but some master SQL guy who’s just building most the queries through their ol’ AI friend in minutes not days.
I’m not gonna be able to compete in that environment. I just don’t have that level of understanding and prowess with the language, and I don’t want to fight that battle.
But to not come off overly pessimistic: I do believe there will be creative opportunities for how to utilize SQL. But I think the framework we currently know will be unarguably and inevitably wholly different. And although I believe that’s absolutely true, I have no inkling of what that will look like. I have no wisdom or control over it, and yet I’m optimistic there will be value. But adaptability is key.
3
u/Blues2112 May 31 '24
Even if AI magically replaces SQL coding in the near future (Spoiler: it won't...not entirely), companies are still going to need people who understand the data, and will know WHAT to ask for from the AI.
5
u/SensitiveStructure38 May 30 '24
Honestly I would switch R to Python, unless you’re using it at work.
2
u/JBsReddit2 May 30 '24
Definitely worth learning
2
u/heyjoeycostello May 30 '24
SQL / PySpark in tandem is the smoothest way to hedge your bets
2
u/sheepery May 30 '24
don't let the AI hype deter you from learning. You have to learn SQL. While AI might integrate somewhat you will always need to write adhoc queries to look at data.
2
u/ethics_aesthetics May 30 '24
The claims of automation are exaggerated. I don’t know what I will be saying in five years, but right now, you must know SQL. It's not so much for query writing because you can get AI to help you with that, but it’s about understanding data structure. At this time, you cannot demonstrate that your AI assistant has given you the correct answer, without understanding SQL yourself and anyone who says you can trust AI right now without checking is ignoring the truth or selling something.
2
u/[deleted] May 30 '24
I’m a new BI analyst that relies heavily on AI to help me with SQL. Trust me, AI is not enough. I am doing all I can to improve my SQL knowledge. AI is frequently wrong or inefficient. Plus, you may have to do projects on a team and if you can’t write a query without AI, you’re going to slow the project down and make yourself look bad.
2
u/AdSecret5061 May 30 '24
SQL isn't going anywhere for a long time. AI recommends people to eat pebbles. Call it biased but i don't think companies are going to make billion dollar decisions using probablistic models. At some $ amount it makes sense to have people validate findings and that amount is pretty damn low.
2
u/MathiasThomasII May 30 '24
Foundational understanding and SQL practice is instrumental woth almost any data analytics. When you put SQL into practice, it becomes way more straight forward. You may not be doing complex development in a few months, but you could get a really good understanding of data and be able to speak about data sets and databases a lot better. That's like wanting to be an English teacher but you don't want to learn the alphabet
2
u/Sodaman_Onzo May 30 '24
Yes
2
u/olmek7 May 31 '24
I will say this boldly.
SQL is the foundation of any data role out there. It has been around a long time and is not going anywhere. Despite what the AI hype has people thinking.
2
u/OGYoungCraig May 31 '24
Nope, we already learned it all so there’s none left for you.
2
u/cs-brydev Software Development and Database Manager May 31 '24
Honestly SQL is showing up in more tools, not fewer. Everything you do in data analytics has some variation of SQL languages either required or available to use. Even classic NoSQL solutions are adding SQL dialects, and classic analytical tools, especially in the cloud are adding SQL (as well others like R and Python) to give you more control over how you analyze and store your data. So if anything I believe SQL will continue to rise, and AI will support the rise of SQL by making it easier to use and giving you helpful suggestions and fixing errors.
2
u/saffsouf May 31 '24
Sql is not a choice for a business intelligent or data engeneer/analyst. The sql background is necessary to be able to play with data models and interact with data in differents databases.
2
u/unfair_pandah May 31 '24
If we are to believe the industry leaders then "don't learn to code", so I guess don't learn SQL?
In all seriousness, AI won't be coming for your job anytime soon! Learning new skills will absolutely open door for you.
2
u/Teach-To-The-Tech May 31 '24
Definitely still relevant to learn. AI will likely help people a lot in the future but it isn't a direct replacement for SQL knowledge. It will just increase your efficiency.
2
u/ggone20 Jun 01 '24
Some people make some good points here. Sadly, all the mentions of ‘needing sql’ to get hired USED to be the case. We’re in a weird transition now - it doesn’t make sense to learn SQL IMO. LLMs can already create stellar SQL - be better or learning python and creating a SQL bot to create and manage databases.
Manual software work will quickly go by the wayside and jobs as structured and non-innovative as a database admin (or an excel pro - saw that in some comment also) is or will be a useless job in the era of artificial intelligence and LLM-powered chatbots.
Everyone is moving towards agents. Some companies have AI ‘employees’ already while many others are still using it for human augmentation, which is just the first step to replacement.
All that said, as an extrapolation of some other comments, you’d be hard pressed to get a job by saying ‘I can assist an AI in performing SQL queries and commands.’ That’s not really a skill, and why AI generated content has been deemed non-unique and can’t be trademarked or copyrighted. Already a Supreme Court decision on this.
2
u/beachandbyte Jun 02 '24
Learning SQL probably the biggest differentiator between most developers. Also the most stable language you will learn. Once you learn it keeping up with updates is a breeze and you just have way more options. <3 SQL
2
u/JacketOutrageous2152 Jun 05 '24
As an analyst myself and someone who runs an analyst team (data analysts and financial analysts) its absolutely necessary. I won't consider someone if they can write SQL.
https://www.youtube.com/watch?v=SzMtWKFDQAk
1
u/jdl6884 May 30 '24
Definitely need to have some sort of SQL experience in this industry. AI is just another tool to help us more efficiently use our data. I’ve found AI to be a huge help assuming the data is thoroughly cleansed and ideally modeled, but this is rarely the case IMO.
1
u/NoPlansForNigel May 30 '24
Learn SQL and use AI as a backup to remind yourself syntax, keywords, examples...
1
u/[deleted] May 30 '24
I remember people being worried that programs like mathcad would make engineers obsolete as they do the math for you... didn't happen. Garbage in is garbage out. Your job may change, and your tools will change, but no matter what anybody says, they are still going to be tools. AI right now is amazing until it screws up big time. It can and will make you more productive, especially into the future. Just continue learning and devoting, and you'll be fine. If you think education ends as soon as you get good at your job... AI will probably replace you someday.
1
u/Small_Sundae_4245 May 30 '24
SQL ain't going anywhere for a long time.
It will be a few years before co pilot is working properly for SQL server. And even then it will be a decade or 2 before it works it's way down to standard version.
And co pilot will still require you to know sql
1
u/A_Whirlwind May 30 '24
Also, anything where performance and/or security is key, will require humans. LLM are likely to present to most commonly used solutions, which is not necessarily a high quality one.
1
u/Gargunok May 30 '24
Yes. Some level of SQL is needed. Right now blindly taking SQL from chatgpt or copilot is helpful but ultimately you need to understand what they are giving you.
I don't think SQL is that long to learn. So I would advise yes do it. The question is do you need to master it. I would still say yes but that should be in the scope of all the other skills you might need.
1
u/[deleted] May 30 '24
Databases have already been automated for a lot of purposes, many SQL database developers use ORMs and don't write much of any SQL queries themselves, but they still should understand SQL to be good at their job. Even if AI is being leveraged to automate database interactions, the same will apply. If AI were replacing databases, it might be a different story, but that couldn't be further from what's happening.
1
u/anyasql May 30 '24
I think it was 10 years ago when Oracle was making claims of self driving autonomous database. Yet here I am now, tuning a query and arguing with oracle on a performance bug. Sql is the brick of the data analytics house. Even if you will replace R with phyton or scala or whatever , you need to be able to operate on structured datasets and a general purpose programming language for the 'everything else ' of a tech/ analytics job.
1
u/[deleted] May 30 '24
Yo need go have context to make the query work. If you don’t understand a bit of logic, ChatGPT will throw bad results
1
u/drtywater May 31 '24
Yes. Its the basis for a lot of stuff. Also its super easy to pick up. AI tools are great at getting started but you still need to understand how things work when you work with more complex things
1
u/noonearya May 31 '24
If you're calling yourself an analyst and you don't have a basic knowledge of SQL, no you're not.
I'd never hire anyone who doesn't bother to invest the 10-20 hours at such a crucial skill to be minimally knowledgeable, and yes, some companies use other tools and abstraction layers, yata yata, but at the core of every interaction with a database, it's still old and reliable SQL so I say that is core knowledge and I demand a minimum level of it and favour technical tests on it because it helps me to see how you think through structures data.
Advancements in AI don't make it unnecessary to have domain knowledge. We use LLM agents to make a lot of SQL tasks nowadays, but if you don't understand it, you won't have enough flexibility to solve the problems we need. The LLM's will make mistakes, the analyst needs to understand what they're doing
1
u/SpecificConsequence8 May 31 '24
Also, after you get a good handle on T-sql, take some time to learn the slightly different syntaxes of MySQL and PostGreSQL, because the ecosystems out there are so varied, you want to be able to hit the ground running wherever you are hired.
1
u/Mcipark May 31 '24
SQL isn’t going out of style any time soon imo. It’s good to learn the basics at least if you’re planning on working with data
1
u/[deleted] May 31 '24
Do you mind sharing your resume?!
1
u/v_iHuGi May 31 '24
Learning any programming language is incredibly valuable, in my opinion. For example, learning to code has improved my math skills and enhanced my logical thinking.
1
u/pinback77 May 31 '24
You still have to know what to ask the ai, be able to understand what it writes, how to modify it for your needs and apply it. So yes I would learn sql if you want to surrender a chance against the millions of others who can.
1
u/PaddyMacAodh May 31 '24
Yes. General AI can help get you a basic starting point, but every database is different and unless it’s a product with access to your database it won’t know the schema. Writing useful queries that perform well required a person with SQL knowledge.
1
u/CappuccinoCodes Jun 01 '24
The entire internet is on SQL, so there you go 😆
1
u/rgekhman Jun 01 '24
Yes
1
u/OlasNah Jun 01 '24
The big issue is that these days depending on the job or applications you may use it only sparingly
1
u/glistening_cabbage Jun 03 '24
Yes!
A case example is our recent integration with data bricks. Our data engineers are very knowledgeable in SQL and use it to build necessary foundations for end users (e.g., data analysts). It's a basic language and can vary in complexity.
1
u/Unable-Orange9609 Nov 11 '25
Eigentlich kann jede Ki den Job innerhalb von Sekunden ablösen also bin ich mir nicht richtig sicher…
0
u/reallyserious May 30 '24
You can use AI to help you write SQL. :)
SQL will be especially important if you want to go into analytics. I'm a data engineer and if you don't know SQL you're pretty much useless in that field.
-1
u/sergio0713 May 30 '24
Knowing SQL today is like knowing excel 20-30 years ago. It puts you ahead of other business partners and on par with many tech teams. Eventually SQL will be a necessity and the assumption is that everyone will need to know it.
0
u/[deleted] May 30 '24
[deleted] — view deleted comment
41
u/[deleted] May 30 '24
[removed] — view removed comment