SQL

How much SQL is really necessary nowadays?

I’ve heard variants of this question every year of my professional career from aspiring developers and students of computer science. Unfortunately, the real answer is the most common in all software development.

It depends.

SQL and database technologies it powers is a tool that can be (mis)applied in many places in some careers and never in others. There are developers whose whole career is in SQL as database developers, and others who never touch any database, writing algorithms, to files or APIs. Full stack web developers like myself have two additional issues to conflate and confuse the issue.

ORMs (Object Relational Mapper) and NoSQL databases. While ORMs can effectively be used to do both all of the queries and migrations, the scripts you create to upgrade a database schema from one version to the next, they often are not used in professional settings, or at least not for all purposes, requiring hand crafted queries or schema change scripts. NoSQL is a valid technology for some problems, particularly when the consistency or relationships between data points are not as important as the speed of retrieval or writing. However in enterprise settings that often is not the case, since financial data must be both consistent and be stored in a way for a business to gain relational insights.

Case Study: Me

I’ve written line-of-business, software-as-a-service, web applications in C#. I took a single SQL course in college. I thought it was well worth my time in my career.

Project 1

We wrote a lot of SQL. Stored Procedures were the preferred data access method, in part because we needed our SQL queries to be blindingly fast (large volume e-commerce) and in part because our SQL stack was very cutting edge and we wanted to leverage it. Almost every query to show the results of a page load required a join across 3 tables with an aggregate result, as every page was basically functioned as some form of on demand reporting. Database migrations were usually, but not always automatically generated by a third party application.

Project 2

I almost never write a SQL query that goes into production, although I do write schema changes since we handcraft all our migrations. I do write relatively simple SQL queries during development to get an overview of the database. Twice a year I’ll write a view that does actual on demand reporting with multiple joins and an aggregate, but I still need as much knowledge to do so as I did when I was writing them every week during project #1.

But what about your career?

What do you want to do? If you’ve stumbled across this blog because you are in or are looking to pursue a full stack web development career, I’d say some investment in learning SQL is well worth the time. There is some chance you’ll not use it, but a much larger chance you will. More importantly you’ll understand better when to use it and the other tools and techniques you learn across your career.

If you’re looking into joining a different part of the programming field, ask developers in those industries what tools they use. Game programmers might be writing things in different tools than finance algorithm developers. If you don’t know what part of the field you’re interested in, start trying hobby projects in as many as you can. It is going to be a large part of your career experience, so don’t take the question lightly.

Good luck and as always, leave any questions in the comments.