Looking for some advice. I have been told by someone in my development team that they are looking for a junior sql developer and that I should go for it. I have done sql in the past in school and recently did an intro to sql course where I knew most of the things it just took me a second to remember them but I have no clue what a Junior SQL developer job would entail…
Does anyone have any insight to what this would be like? Courses I could take to prepare me for this?
a google search for “junior sql developer” turns up a few hits - btw google job search is pretty nifty
You’d probably spend a lot of time writing Stored Procedures, investigating where slow downs are happening and what to do to fix it (index tuning, creating new indexes, etc) and database maintenance procedures (shrinking log files, backups, import, export to/from different formats)
I know 1,2 and 3 but not the rest. I have some PowerBI knowledge that I know the company is moving towards but it is very very limited. I have tried googling “How to” on SSRS and SSIS but not really finding anything.
Yeah, I am sure if a performance issue were traced back to an actual DB issue, you would work with a DBA to get it resolved. That’s how it works at my company anyway. Devs identify things that would make our code run more efficiently and we assign a ticket to a DBA to get it done.