All About Microsoft Certifications

Early this morning Microsoft released Windows 7 RC for download for those with TechNet and MSDN accounts.  Let the download games begin! Since the Windows 7 Ultimate 64bit is a little 3 gig in size rumor has it that there is a...

And growing…and this is a good thing.  There are those who thrive on having a huge number of certifications and then there are those who only take tests if they are “encouraged” to do such and even then they will only enter the test...

I found this information on the Born to Learn site: If you’re a developer headed to TechEd, Trika ( as in "So, a booth babe and a geek walk in to a bar...") is passing along an invite to a party on Tuesday night. Bowling, drinks,...

Microsoft Tidbits: Windows 7 Beta Exam The 71-680 (Configuring Windows 7) beta exam opened and closed in a very short period of time (in one day I believe) - in fact it closed so quickly that a few extra slots were opened later on...

Here is something interesting with Windows 7: XPM ( Windows XP Mode).  This will be a fully licensed copy of Windows XP with Service Pack 3 in a virtual machine in a virtualization solution akin to Virtual PC.  What is key here is...

Office professionals, you say? Unless you’ve worked in or been involved with someone with an office assistance or support staff position, you probably are not aware that companies, like staffing agencies, use Office certification...

If you are one of the thousands who have been Beta testing Windows 7 for the past 4 months and have been patiently waiting for the Release Candidate and RTM versions....your patience will be rewarded shortly.  It is almost time for...

I came across these two interesting offers on the Born to Learn site today - well worth the read if you haven't taken a certification test lately. Certified, but not lately? Here’s your chance to get back in the game: Watch for an...

The budget ax strikes - The Certification Testing Center is the latest casualty and will not be at TechEd this year. You will not be able to take any tests at TechEd at 50% off.   In an effort to keep costs under control, the...

Well, it is here.  You have waited long enough and the suspense has been building.  The first Windows 7 Beta exam - 71-680: TS Windows 7, Configuring will be available in a week for Beta testing.  If you pass this test it will be...

Microsoft has  just released an enhancement to their exams that they hope you never need to notice!The new exam item “plug-ins” are used by Prometric test centers worldwide to support the onscreen appearance and functionality of...

I bet that got your attention.  Now, I can't tell you when any of the Windows 7 Exams will be released - as I really don't know. Microsoft Learning will announce them in due course, when they are ready. But I can tell you a little...

I can just hear you now. “Why should I enter? I never win anything.”Well, this could be your chance to change your luck. If you’ve been thinking it’d be nice to win a FREE TRIP TO TECHED, let me say that again, A…FREE…TRIP…TO…TECHED,...

We all want our children to succeed and we want to help them achieve their career goals.  If your child (or children) are interested in programming (I have one who is studying software engineering), then Microsoft has a program for...

 Then here is chance!  If you are an MCP and you want to attend TechEd, but the cost is a bit high, then this is your day!  Saving money is always nice given the costs of attending TechEd.  Having an opportunity to save on the show...

Microsoft Learning recently released several new courses - covering Windows Server 2008, and the much anticipated Windows 7.  These new course help roundout the latest instructor-led courses, especially for those of you who like to...

Last week I posted about this great opportunity to attend TechEd.  The fine folks at Born to Learn have provided more details on this contest.  Remember, the Bus is going to stop in the following cities:  Tampa, Atlanta, Charlotte,...

On the Road to TechEdNow here is an interesting opportunity to not only TRAVEL to TechEd, but also ATTEND TechEd - all by simply riding a bus. The Born to Learn site announced the Get on the Bus! – an eleven-day odyssey across...

I had an interesting class recently - where all of the students were in the midst of a career change.  A military career change.  The members of this State's National Guard  had gone through a very intense multi-week IT training...

Prices for goods and services are rising and this is expected, but as of today's truth, the price for a Microsoft Exam is NOT going to increase.  In an article from Michael Domingo he thought that the price for Microsoft exams were...

Microsoft Azure Fundamentals AZ-900 Exam Prep

Best Database (DBA) and SQL Certifications for 2023

While database platforms have come and gone through the decades, database technology is still critical for multiple applications and computing tasks. IT professionals often seek database certifications to demonstrate their knowledge and expertise as they navigate their career paths and pursue professional growth. 

While database certifications may not be as bleeding edge as Google cloud certifications, cybersecurity certifications, storage certifications or digital forensics certifications, database professionals at all levels possess in-demand career skills — and a plethora of database-related jobs are waiting to be filled.

We’ll look at some of the most in-demand certifications for database administrators, database developers and anyone else who works with databases.

To get a better grasp of available database certifications, it’s helpful to group these certs around job responsibilities. This reflects the maturity of database technology and its integration into most aspects of commercial, scientific and academic computing. As you read about the various database certification programs, keep these job roles in mind: 

These database job roles highlight two critical issues to consider if you want to be a database professional:

NoSQL databases — called “not only SQL” or “non-relational” databases — are increasingly used in big data applications associated with some of the best big data certifications for data scientists, data mining and warehousing, and business intelligence.

Here are details on our five best database certification picks for 2023.

IBM is one of the leaders in the worldwide database market by any objective measure. The company’s database portfolio includes industry-standard DB2, as well as the following:

IBM also has a long-standing and well-populated IT certification program that has been around for more than 30 years and encompasses hundreds of individual credentials. 

After redesigning its certification programs and categories, IBM now has a primary data-centric certification category called IBM Data and AI. It includes a range of database credentials: 

IBM’s is a big and complex certification space, but one where particular platform allegiances are likely to guide readers toward the handful of items most relevant to their interests and needs. 

Database professionals who support DB2 (or aspire to) on IBM’s z/OS should check out the IBM Associate Certified DBA — Db2 12 certification. It’s an entry-level exam that addresses routine planning, working with SQL and XML, security, operations, data concurrency, application design, and concepts around database objects.

This certification requires candidates to pass one exam. Pre-exam training and familiarity with concepts, or hands-on experience, are recommended but not required. 

Certification name

IBM Certified Database Administrator — Db2 12 (z/OS)

Prerequisites and required courses

None required; recommended courses are available.

Number of exams

One: C1000-122: Db2 12 for z/OS DBA Fundamentals (63 questions, 90 minutes)

Cost per exam

$200 (or local currency equivalent) per exam. Sign up for exams at Pearson VUE.

URL

https://www.ibm.com/training/certification/C8003803

Self-study materials

The certification page includes self-study materials, including a study guide and a learning path. 

Did you know? IBM’s certification offerings are among the best system administrator certifications IT professionals can achieve.

Microsoft Azure offers a broad range of tools and add-ons for business intelligence. Azure is a cloud computing platform for application management and Microsoft-managed data centers. Microsoft certifications include various Azure offerings based on job role and experience level.

Microsoft’s certification program is role-centric, centered on the skills you need to succeed in specific technology jobs. Because Azure has such a broad scope, Azure certifications span multiple job roles. However, specific certifications exist for the following positions:

There are also certifications for learners at different experience levels. 

For those looking to take their Azure knowledge to the next level, the Microsoft Certified: Azure Data Fundamentals certification is the perfect place to start. This certification is for beginner database administrators interested in using Azure and mastering data in the cloud. It offers foundational knowledge of core concepts while reinforcing concepts for later use in other Azure role-based certifications, such as those listed below: 

Certification name

Microsoft Certified: Azure Data Fundamentals

Prerequisites and required courses 

This certification does not have any prerequisites. However, for absolute beginners, Microsoft offers an Azure Fundamentals certification. 

Number of exams

One exam, DP-900, which is administered via Pearson VUE or Certiport.

Cost per exam

The exam costs $99 in the United States, though the cost changes based on where it is proctored. 

URL

https://learn.microsoft.com/en-us/certifications/exams/dp-900

Self-study materials

Microsoft offers one of the world’s largest and best-known IT certification programs, so the exam is well supported with books, study guides, study groups, practice tests and other materials. Microsoft also offers a free online learning path.

Oracle runs its certifications under the auspices of Oracle University. The Oracle Database Certifications page lists separate tracks depending on job role and product. MySQL is perhaps the leading open-source relational database management system (RDBMS). Since acquiring Sun Microsystems in 2010 (which had previously acquired MySQL AB), Oracle has rolled out a paid version of MySQL and developed certifications to support the product. 

If you’re interested in pursuing an Oracle MySQL certification, you can choose between MySQL Database Administration and MySQL Developer. 

The Oracle Certified Professional, MySQL 5.7 Database Administrator (OCP) credential recognizes professionals who can accomplish the following tasks:

The certification requires candidates to pass a single exam (the same exam can be taken to upgrade a prior certification). Oracle recommends training and on-the-job experience before taking the exam.

Did you know? According to Oracle, approximately 1.8 million Oracle Certified professionals globally hold certifications to advance their networking careers and professions to validate their IT expertise. 

For individuals interested in working in the Oracle environment who have the necessary experience to become a database administrator, Oracle’s Database SQL Certified Associate Certification is another top Oracle certification and an excellent starting point. This exam encompasses an understanding of fundamental SQL concepts that individuals must grasp for database projects. 

By earning the certification, individuals demonstrate that they have a range of knowledge in core SQL concepts:

This certification also requires candidates to pass a single exam. While Oracle does not specify any prerequisites, the company does state candidates should have familiarity working with the command line. 

SAP SE has an extensive portfolio of business applications and analytics software, including cloud infrastructure, applications and storage. The SAP HANA platform’s foundation is an enterprise-grade relational database management system that can be run as an appliance on-premises or in the cloud. The cloud platform lets customers build and run applications and services based on SAP HANA. 

SAP offers a comprehensive certification program built to support its various platforms and products. We’re featuring the SAP Certified Technology Associate — SAP HANA cert because it aligns closely with other certifications we’ve highlighted and is in high demand among employers, according to job board surveys. 

This certification ensures database professionals can install, manage, monitor, migrate and troubleshoot SAP HANA systems. It covers the following skills:

SAP recommends that certification candidates get hands-on practice through formal training or on-the-job experience before attempting this exam. The SAP Learning Hub is a subscription service that gives certification candidates access to a library of learning materials, including e-learning courses and course handbooks. 

The annual subscription rate for individual users on the Professional certification track is $2,760. This online training program is designed for those who run, support, or implement SAP software solutions. Though this may seem like a steep price for online training, you will likely be able to pass any SAP certification exams you put your mind to by leveraging all the learning resources available to SAP Learning Hub Professional subscribers. 

Typically, SAP certifications achieved on one of the two most recent SAP solutions are considered current and valid. SAP contacts professionals whose certifications are nearing end-of-life status and provides information on maintaining their credentials.

Certification name

SAP Certified Technology Associate — SAP HANA 2.0 SPS05

Prerequisites and required courses    

None required.

Recommended: Hands-on experience and the following courses: 

Number of exams

One exam: SAP Certified Technology Associate — SAP HANA 2.0 SPS05, exam code C_HANATEC_17 (80 questions, 180 minutes)

Cost per exam

$500

URL

https://training.sap.com/certification/c_hanatec_17-sap-certified-technology-associate—sap-hana-20-sps05-g/

Self-study materials

The certification web page includes a link to sample questions. SAP HANA trade books and certification guides are available on Amazon. The SAP Help Center offers product documentation and a training and certification FAQs page. The SAP Learning Hub (available on a subscription basis) provides access to online learning content.

Tip: To broaden your skill set, consider pursuing the best sales certifications to better sell and implement various IT solutions, including databases.

Additional database certification programs can further the careers of IT professionals who work with database management systems. 

While most colleges with computer science programs offer database tracks at the undergraduate, master and Ph.D. levels, well-known vendor-neutral database certifications exist, including the following: 

These are some additional certifications: 

These credentials represent opportunities for database professionals to expand their skill sets — and salaries. However, such niches in the database certification arena are generally only worth pursuing if you already work with these platforms or plan to work for an organization that uses them.

Key takeaway: Pursuing additional database certifications can be helpful for professional development if you already work with these platforms or plan to work with them in the future. 

Before pursuing certifications, consider their popularity with employers to gain a helpful perspective on current database certification demand. Here’s a job board snapshot to give you an idea of what’s trending.

Certification

SimplyHired

Indeed

LinkedIn Jobs

LinkUp

Total

IBM Certified Database Administrator — DB2

867

1,337

1,911

753

4,868

Azure Data Fundamentals

2,052

4,154

283

2,322

8,811

Oracle Certified Professional, MySQL Database Administrator

339

473

143

23

978

Oracle Database SQL Certified Associate Certification

138

177

10

273

598

SAP HANA

32

37

57

466

592

If the sheer number of available database-related positions isn’t enough motivation to pursue a certification, consider average salaries for database administrators. SimplyHired reports $91,949 as the national average in the U.S., ranging from $64,171 to over $131,753. Glassdoor’s reported average is somewhat lower at $84,161, with a top rung for experienced senior DBAs right around $134,000.

Choosing the best IT certifications to enhance your skills and boost your career can be overwhelming, especially as many available certifications are for proprietary technologies. While picking a database certification can feel like locking yourself into a single technology family, it is worth remembering that many database skills are transferable. Additionally, pursuing any certification shows your willingness to learn and demonstrates competence to current and future employers. 

Ultimately, choosing which certification to pursue depends on the technologies you use at work or would like to use at a future employer.

Jeremy Bender contributed to the reporting and writing in this article.