I am STUDYING engineering and I want to know what certifications I need to take to start a neww database career.
Is it OCP, OCA, MCDBA or some other certification?
Is certification essential for a Database Developer?
What are the other things I must focus on to develop a career in databases?
Starting My Career On Database Certifications
- We live in a world where easy management of information and fast sharing information draws the thin line between the success and failure of a company.
- Managing mission-critical data has become an essential part of every business in this technology-driven world.
- E-commerce just compounds this situation. Hence, every company has specialized people who manage databases of company or who write scripts/develops databases.
- This brings us to the point that being Database Administrator or Database Developer are two main career options in the database industry.
How To Become A Database Administrator (DBA)
A Database Administrator maintains and oversees database technology in a large organization.
He performs tasks such as disaster recovery, backups of databases, tests on backup data, and analysis of performance of network and systems.
DBA Roles also include determining the needs of users, planning data-flows, categorizing data, securing databases, etc.
How To Become A Database Developer
A Database Developer manages a company\'s databases, organizes data, controls and implements security measures.
Designing new database structures, writing the required applications, testing scripts and technical documentation, setting and defining access controls to databases are some of the responsibilities of a Database Developer.
Some of the skills that a database specialist may include:
- Knowledge of logical database design
- Skills in SQL data definition and SQL data manipulation
- Knowledge of entity-relationship (ER) modeling
- Knowledge of indexing, performance tuning and optimization
- Strong skills in SQL/data analysis
- Knowledge of querying data using SQL
Qualifications of Database Administrators (DBAs)
There are no required college degrees for Database Administrators.
IT colleges for BE, BTech, MCA, and BCA degrees are good enough for you to be eligible to make an entry into this field.
It is not necessary to have a certification to break into the industry if you have the right qualifications, skills, and experience. However, having a certification may increase your chances.
Let me remind you that having a certification alone will not get you the job unless you have the right skills and hands-on experience.
Having said that, let me tell you about the different database certifications
that are available today.
Microsoft Office User Specialist Certification
If you are going to work in a small-scale company where data is managed using Microsoft Access, acquiring your Microsoft Office User Specialist program is enough.
If your plans are bigger than just being an Access Specialist and want to be a specialist in Microsoft SQL server or Oracle, you can choose to do one of the following:
The MCDBA Certification Path
If you complete this program successfully, you will be a certified Database Administrator. You need to complete the following four examinations:
- One Microsoft SQL Server Administration exam
- One SQL Server Design exam
- One Microsoft Windows 2000 Server or Windows Server 2003 exam
- One elective exam
The Microsoft Certified Technology Specialist (MCTS)
This is the most widely accepted certification today in the industry when compared to MCDBA.
You can select any of the programs such as SQL Server 2008, Database Development and Microsoft SQL Server 2005 under Microsoft SQL Server technologies category.
The Oracle Certification Associate (OCA)
This is an Oracle certification for those who want to be specialized in Oracle Database and technologies. You have to complete the following exams.
- 1Z0-001 Introduction to Oracle: SQL and PL/SQL (retired) or 1Z0-007Introduction to Oracle9i SQLÂ® or 1Z0-047Oracle Database SQL Expert or 1Z0-051Oracle Database 11g: SQL Fundamentals I
- Oracle Database 11g: Administration I 1Z0-052
Once you complete OCA, you take OCP, which is an advanced level certification.
Before you choose to do any certification, you must first decide which database track you want to specialize in. If you want to specialize in Microsoft Technologies, then you must go for the Microsoft certifications.
Besides having certifications, you must have very good skills in databases. So focus on developing these skills. Try to take up an internship with organizations that want fresh database administrators or developers.
All the best. . .