How do I get a job in sql with no prior coding experience as I was in the mechanical field and what other skills do I need ?

Question

sql job

Answer 1

🤔sql knowledge would help.

Answer 2

I mean I've done an online course in sql and have been practicing

Answer 3

Get connected with an insider to help you get in I guess?

Answer 4

jules pereira Are you comfortable with design practices such as writing ERDs, normalisation etc.? Have you deployed or maintained any servers for personal projects? Are you comfortable with stored functions, triggers, indices etc.? If yes to the above maybe look at putting some projects together for a portfolio whilst working towards some kind of certification for your preferred RDBMS. These things may go some way to establishing a level of credibility when seeking interviews if you are coming from a different industry area. If not then it should be obvious that you need to spend more time studying and writing SQL before you consider seeking a role that requires these skills.

There is a lot more to SQL centric roles than simply being able to understand the code, work on design and optimisation skills is always going to be time well spent.

Answer 5

James pink I've been doing this course online from udemy and been practicing as while and I've learnt functions, triggered, joins, queries, subqueries, creation of tables, insert, update, replace, delete etc...... I've not come across erd and normalisation in depth .... Also how do I build personal projects in sql for my portfolio?

Answer 6

As well*

Answer 7

James pink.... Would you say an online certification from udemy holds any value?

Answer 8

jules pereira This is all good stuff, I would seriously recommend getting into ERDs for design (Visual Paradigm has a free community edition that's very useful for making diagrams for non-commercial use), even if you're more interested in admin/optimisation it will serve you well to be comfortable and familiar with how ERDs work and they can be very useful for design and initial refinements before you move on to implementation.

As for a portfolio databases can be tricky as they aren't exactly user facing in a way that is generally eye catching. I would recommend maybe some simple programs that integrate databases of yours in a way that meets a common enough use case; maybe some statistical reports that use databases that you've designed. As an SQL specialist you will want to take extra care to create strong documentation with some graphical content to support (ERDs, charts etc.).

Answer 9

jules pereira As far as certifications go. I'm not very up on what Udemy offer, however it is to my understanding that their certifications are considered largely worthless unless they are accredited by an authorive organisation. That doesn't mean that they're worthless, they can even be used to pad a CV to show that you're dedicated to your education, but a Udemy certificate doesn't hold the same weight as a roughly equivalent (in terms of expertise ) one from say IBM. I hear Oracle database certifications are held in some level of esteem, though this is may be my subjective perception.

Feel it's worth noting that I'm in no way an expert in SQL databases or careers in the IT industry. Just came across the post and thought it worth chipping in.

Best of luck dude :)