I am learning SQL lately, could you walk me through what does a SQL dev do everyday?
What kind of software I need to learn how to use? (aside from of course I have to know how to write in SQL language)
I am pretty confused when it comes to this, and I don’t get the big picture…
For example, if I am a SQL dev that works with data bases all day, what do I do every day?
I just open Sequel Pro and connect it to data base then open the file in VS Code and edit it then re-upload the file or???
If that were the case (you were to just work on databases), you’d more than likely be a business analyst rather than a developer.
Most businesses store their data on databases, and most of those databases use SQL, so someone who knows SQL can just grab/manipulate/add data to/from those DBs.
Say I want reports on orders that fit a certain pattern over the last 2 weeks, I can just run a query and get that data. Then I pipe that data into some other tool, and say get it to spit out spreadsheets and/or graphs for management
Normally you would avoid editing the database directly, they normally back some application. If you’re a developer, you’d normally be working on that application rather than the DB directly: working on the database would be part of your job, not your whole job.
So as a correction to my previous post, it looks like SQL Server is now supported on Linux and Docker. I suspect that the video posted earlier uses SQL Server in a Docker container (which I’m guessing is the recommended method to use it on macOS).
Yeeeeah I suppose but I’d say the job of DBA is a highly specialised these days, just knowing some SQL is not going to cut it. I may be off base on this, but I would hazard a guess that SQL is the most commonly known (as in number of people who can write basic queries) “programming” language by a pretty long way (though it isnt really a programming language). It’s a bit like HTML - it’s something it is assumed you would know in addition to actual programming languages for certain programming roles. It only does one specific thing, it’s not a multi-purpose tool. You can query relational databases, that’s it.
Btw I’m not trying to put you off: if you want to be something like a Microsoft-certified DBA, working on SQLServer stuff for enterprise companies, it won’t be too difficult to learn.