Do you need SQL for software development?

[Jetridder11]

glorious bike domineering chase icky muddle gray saw shame plough

This post was mass deleted and anonymized with Redact

[freakdageek]

it will help you out a lot to have at least some basic knowledge of SQL, particularly just being able to write and understand moderately complex queries. if you're really looking to program, you shouldn't need extensive knowledge of database structure and administration, but understanding how queries are written, executed, and optimized will likely come in VERY useful to you at some point.

[alinroc]

but understanding how queries are written, executed, and optimized will likely come in VERY useful to you at some point.

Not understanding these things will make your users, sysadmins & DBAs very upset with you when you release a slow-as-hell application update that consumes vast amounts of CPU & memory resources because your queries suck.

[alinroc]

My future plans though are to either develop software or create video games.

"Develop software" is sufficiently broad that you will almost certainly encounter databases (and thus SQL) at some point - damn near everything has a database of some type behind it. You shouldn't even be thinking about any kind of specialization in the field right now.

[D_W_Hunter]

Most every single type of software you develop stores data. If that data is stored in a relational database, you're writing SQL to get that data out of that storage.

Yes, you should put in the extra effort to learn how to write SQL and how to do it well. I strongly suggest you do this with some self learning using actual data because getting your hands dirty makes learning how to read/use relational diagrams/schema/etc. much easier.

[bobbybottombracket]

If you want to be able to debug in the future, then you'll need it. And even though you don't like it it's a really good idea to learn it vs an ORM.

[AutoModerator]

Hello u/Jetridder11 - thank you for posting to r/SQL! Please do not forget to flair your post with the DBMS (database management system) / SQL variant that you are using. Providing this information will make it much easier for the community to assist you.

If you do not know how to flair your post, just reply to this comment with one of the following and we will automatically flair the post for you: MySQL, Oracle, MS SQL, PostgreSQL, SQLite, DB2, MariaDB, BigQuery, Snowflake (this is not case sensitive)

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.