Developers' SQL Proficiency

This cluster discusses the widespread lack of SQL proficiency among developers, including web devs and analysts, often due to reliance on ORMs or infrequent use, with surprise, calls for better training, and emphasis on SQL's importance.

📉 Falling 0.3x Databases
3,166
Comments
20
Years Active
5
Top Authors
#9049
Topic ID

Activity Over Time

2007
2
2008
24
2009
67
2010
79
2011
81
2012
86
2013
145
2014
92
2015
105
2016
138
2017
177
2018
193
2019
301
2020
256
2021
268
2022
329
2023
371
2024
242
2025
200
2026
10

Keywords

PHP REPL DBA SSD IDE SME SQL NoSql FWIW SUM sql database dba developers learn databases db join lineage devs

Sample Comments

tacker2000 Sep 14, 2023 View on HN

Not all devs are proficient in SQL. Its another skill that is required.

not_knuth Mar 8, 2021 View on HN

Tell me more about these developers that don't know SQL. How is that possible? What line of work is this in?

politician May 13, 2019 View on HN

Speaking as a technical development manager, I can say that many people have far less than adequate exposure to SQL, and that training people to use SQL effectively and safely is all too often a common requirement before letting them loose on the database.There are so many ways people misunderstand and misuse SQL and relational databases, it's honestly staggering.So, I second the OP. Learn SQL, and you'll stand out.

tomelders Oct 25, 2014 View on HN

Having worked with journalists, I'm still shocked that don't know SQL. It seems like a perfect fit.

berkle4455 Jan 25, 2023 View on HN

You just described most SQL analysts I've worked with

Ididntdothis Apr 22, 2020 View on HN

SQL feels to me like bash or regular expressions. You can do amazing things if you do it full time. But if you do it only a few times per month or year you quickly forget all the subtleties and it gets hard to understand even the stuff you wrote half a year ago. I guess in the end things have become so complex that as a dev you can’t be good at everything. I often wish there were dedicated database guys but if you have one usually that person is sysadmin and won’t help much with coding against

machiaweliczny Mar 7, 2023 View on HN

Yeah, I guess devs first will need to learn better SQL before it will start to matter.

7thaccount Jul 9, 2024 View on HN

Surprised and not surprised. There's a lot of devs that know a little SQL, but I think it's different when you're mostly using ORMs to abstract away the DB. For business users, you pull up a GUI like this or the one that comes with the DB and sometimes spend hours writing queries and exploring the schema, so you get used to these kinds of tools... especially if you have to move between several databases. I'm sure plenty of devs, do as well, but probably a smaller proportion.

boredemployee May 24, 2024 View on HN

you wouldnt believe the amount of developers that don't know how to write sql

frithsun Jul 8, 2024 View on HN

Programmers would be better served by learning nothing except SQL instead of their current strategy of trying to learn everything except SQL.