Which course or certification should I do for becoming a database administrator?
Since you already have SQL server knowledge I’d explore the SQL Server certification track at MS.Here’s the thing; every db system of repute now is or has had a cert program. You just have to pick the lowest tier of the one or ones you want to live with.OCA is the base Oracle cert, MongoDB has a cert, Datastax has a cert for Cassandra.The more of these you have the better, as you can imagine, but at some point you sort of need to stop since the people hiring sometimes think if you have too many you are a paper tiger.Easiest to find jobs: SQL ServerMost money per job: Oracle (probably still true)Most cutting edge: any NoSQL certThe jobs on NoSQL are good paying but tend to focus currently on coastal locations. They tend to require Linux knowledge as well and you should ideally get a development language going if you want to do that.
I want to be a system administrator. How do I start?
I’ll answer this with a rhetorical question: Is my version of Quora broken, or did you not provide details? Typically when I come across posts like these inquiring for help, people will provide information, albeit lacking, of their current predicament, skill sets & experience: I want to be a Sysadmin, what do I need to learn to get in the door? • r/sysadminFor those that don’t provide much info, we need that info: What do you do now? How old are you? What are getting out of that is so horrible? Are you into technology, willing to face the possibility of burn out and/or other, unsavory things?I’ve been given this question a lot in a variety of forms over time. I’ve written to an extent about it & I think these posts will help quite a bit. If you find they don’t, come back here & let me know what questions are unanswered & I can try to write something up for you.I recommend reading these posts in order:/r/Sysadmin Frequently Asked Questions, an ongoing series …The Training Landscape - Airborne, MOOC, Self & Virtual/r/Sysadmin Frequently Asked Questions - Naming ServersIf these posts make sense to you & you understand what I’m getting at with how I describe things & my thought processes, being a System Administrator will be very straight forward for you, especially if you are willing to learn what you are talking about & care about what goes on underneath everything.Goodluck.
What credentials are needed to get a position as a database administrator?
As a former DBA, I must stress that good DBA's are now basically Data Architects, report smiths, and optimization wizards(not automated of course, but people who can dagnostically improve database throughput and resources). Most DBA's must show 2-4 years of experience as a Data Developer or as a Senior Developer. An excellent resume for a DBA would include bullets like this: --Provided short interval and incremental backups for a Database for swift seamless restores --Experience with the following Cluster technologies for high availability(list some) --Plan level experience in high volume, 100,000 plus query per minute system --Data warehousing schema implementations using some DataModeler Software --Command mastery of PLSQL, TSQL, and/or PostGres SQL --Implemented security procedures to resist SQL injection routines Certifications are nice for foundation concepts, but they've become so commercialized, they're absolutely no replacement for experience in the field. I'd urge you to transition your current job into a DBA 2 or 3 position, and then use your time on the job to implement a few resource and warehousing strategies.
What basic knowlege and qualification required for sql server and oracle?
The MCITP certs are being retired - I'd consider upgrading to MCSE if I were you. http://www.microsoft.com/learning/en/us/... That qualification isn't relevant to Oracle - get a (free) local copy of Oracle and start learning it yourself.
What course should I take to enter the software field being a mechanical engineering graduate?
Being a mechanical engineering student and aspiring to go in software field then you have two choices :Core companies.Non core companies.As you are pursuing you degree in mechanical engineering which is a core field and you don't want to leave that field totally then you can learn some designing softwares such as such as ptc creo, catia, solidworks, uni graphics, etc and analysis software such as ansys.And if you are pursuing this degree by mistake or someone has forced you into this field or now you are no more interested in core field and want to join some IT firms then you can surely learn coding languages such as C, C++, HTML, Java, python, Oracle, etc (you can get details about such software better from a CS or IT students).All the best and choose according to your interest.