SQL Unix commands vs. GUI interface compilers

Experts,

I have a question about manipulating data in a database.  I was looking at a job posting for a Data Warehouse analyst.  I noticed it mentioned unix scripting is a must.  Now I have worked with engineers and watched them modify/retrieve data using unix and SQL, but when I showed them that you can easily access the data using Aqua data studio, oracle SQL plus, they seem to think it is a lot easier that way.

My question, what is the advantage of using unix to drill into the data?  If I don't learn unix will I never be a DBA that management needs?  

Thanks!
Maliki HassaniAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
You should know scripting as a DBA.

For most DBAs the duties are sooooo much more than just the data.

Many administration duties require you at the command prompt.


If you don't have basic knowledge of the OS commands and how to do simple scripts, you will not be as effective as you could be.

Things like managing the backups on disk,  Monitoring disk space, etc...

Also:
Command line is always faster than a GUI!  Many times I can open sqlplus and have the command typed in before any GUI even opens.
0
 
Maliki HassaniAuthor Commented:
Thanks slightwv!  

Your insight is valued
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.