Database Administration in SQL

Question

I have been trying to be a solid programmer, I have a little experience in database administration. However, I am not aware of everything and I am confused if having experience in database administration and maintenance is a useful add on to the standard skillset of an SQL programmer or not? Correct me if I am going wrong, looking for the best of suggestions.

Harsh Shah · Answer

Hi As a programmer, its not needed to have depth skills of sql programmer. But you should have the basic knowledge of sql. If you want to be a full stack developer then as a full stack developer you should have depth knowledge and skills of programming language as well as sql. And now a days, demand of Full stack developer is too high. So now its up to you, what you want to be and its depend on your interest. Hope this will help you. Thank you.

Vijay Khatri · Answer

SQL DEVELOPER A SQL Developer is a person who creates a database and writes SQL Developer Query with the use of SQL Programmes. The basic operation of the SQL Developer is to perform complex operations. Roles and Responsibilities of a SQL Developer- Creation of complex functions, scripts, stored procedures. Testing of Databases and fixing of bugs. Ensuring data quality and integrity in databases. Taking regular backups of databases. Here I am sharing some valuable resources that will help you to learn and improve your skills in the career of SQL https://www.oracle.com/database/technologies/appdev/sql-developer.html https://en.wikipedia.org/wiki/Oracle_SQL_Developer https://squareboat.com/blog/a-career-as-a-sql-developer https://www.thatjeffsmith.com/sql-developer/ If anybody wants to pursue his/her career as a PL/SQL developer. He needs to have knowledge in below skills Oracle: Basic SQL PL/SQL SQL SERVER: Analytical Skills .Reporting Skills Excel VBA Skills Basic Understanding of front end technologies SQL Performance Tuning Different Tools of SQL Different PL SQL Tools like SQL Developer as well as Toad Knowledge of ETL Tool is beneficial Keep yourself open to everything you come across and always learn and implement because your skills matter the most in your career enhancement.

Suraj Kumar · Answer

Try to learn different skills as a developer and programmer and also remember you have to be master of atleast one or two skills. You need to decide your short term as well as long term goal and worked accordingly. Also you have to remember and look into the current and future demanding skills for both programmer and the DBA. You need both database and programming skills for working in a small company where very few people do the tasks related to all the steps involved in the SDLC. In the last I want to say you should be very clear first about the basics of both programming and the DBA at the beginning level. Lots of resources are available now a days where you can test your skills. If you want to be an enterpreneur then also both skills are required as well as you need to do the maintenance related tasks. You can also do certifications for showcase your knowledge in the market.