DBA Diaries

Thoughts and experiences of a DBA working with SQL Server and MySQL

SQL Server Certification – 2 for 1 exam offer

Posted on April 29, 2012 Written by Andy Hayes Leave a Comment

I came across this today and wanted to share it with you. If you are interested in SQL Server certification then for a limited time, Microsoft are offering “2 for 1” on SQL Server exams.

Between April 11 2012 and June 30 2012, you can purchase a SQL Server exam at full price and then once you have taken it you will be emailed a voucher for the second exam at no additional cost.

Please note that the voucher is for the exam in the next version of your chosen technology.

So for example, you can purchase an exam in SQL Server 2008 and once you have sat the exam, you will be emailed a voucher for an exam in SQL Server 2012 once the new exams have been released.

MCSE SQL Server 2012

The voucher code will be valid for 90 days after the availability of the next version certification.

If you sign up and sit one of the following exams, then the voucher will be available to you.

Exam 70-432 : TS: Microsoft SQL Server 2008, Installation and Maintenance
Exam 70-433 : TS: Microsoft SQL Server 2008, Database Development
Exam 70-448 : TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
Exam 70-450 : PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008
Exam 70-451 : PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
Exam 70-452 : PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

You can purchase up to five “2 for 1” exam vouchers per technology path and on the sign up page, there are other technologies to choose from.

The link to the sign up page is here

Filed Under: All Articles, Career Development Tagged With: certification, mcitp, mcsa, mcse, mcts, sql server 2008, sql server 2012

SQL Server 2012 certification

Posted on March 18, 2012 Written by Andy Hayes 4 Comments

sql server 2012 certificationSo SQL Server 2012 has gone RTM and I am considering studying for a SQL Server 2012 certification.

At the time of writing this post, the exams are not yet available but are due in June 2012 with the beta exams happening in March 2012.

For this release, in order to attain a SQL Server 2012 certification you must pass five exams but if you are already SQL Server 2008 MCITP certified, then you need take only three to upgrade.

The information on the Microsoft site seems to indicate that the new qualifications will not be called MCITP. It refers to them as “Professional Level Certifications” There are two categories “Data Platform” and “Business Intelligence” of which three of the exams are the same, with the last two making the difference.

So somewhat different to the previous version whereby, you could go down three different paths to become either a MCITP Database Administrator, Database Developer or a Business Intelligence Developer for SQL Server 2008 and each one had only two exams to pass.

The lists are as follows.

“Data Platform”

  • Exam 70-461: Querying Microsoft SQL Server 2012
  • Exam 70-462: Administering Microsoft SQL Server 2012 Databases
  • Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
  • Exam 70-464: Developing Microsoft SQL Server 2012 Databases
  • Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012

“Business Intelligence”

  • Exam 70-461: Querying Microsoft SQL Server 2012
  • Exam 70-462: Administering Microsoft SQL Server 2012 Databases
  • Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
  • Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
  • Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

If you want an outline of what you will be expected to study for each exam, then you can view the Microsoft site and click into each exam for a breakdown. The link is here – SQL Server 2012 certification

My first thought when I read this and compared it with the SQL Server 2008 certification exams was why so many when you consider that in order to be qualified in SQL 2008, you had to pass one exam to get accredited with an MCTS and one more for the MCITP qualification. There are now five exams for one qualification.

When you consider that the options have been reduced in terms of what you can qualify as, then the number of exams involved seems logical because there is more cross over with the new qualifications compared with the old ones.

Of course this does mean that if you going for a SQL Server 2012 certification and you are not already certified, then you have a lot of work to do to get there.

For those upgrading the path is a little easier but the others will have to sit the five exams. At the time of writing this post I could not find anywhere which mentioned what you achieve after passing an exam. With the MCITP program, you attained an MCTS, a great incentive to sit an exam knowing that you had a chance of coming away with something at the end. Hopefully this will be the case with the SQL Server 2012 certification program.

If you want to go for both the Data Platform and Business Intelligence certs then it looks like you will have to sit all seven exams.

The professional level certs will also require re-certification every three years.

SQL Server 2012 certification benefits

  • Helps to make your CV stand out from the rest and could help get you an interview.
  • Demonstrates that you have spent time studying the product in depth.
  • Helps prove you are an expert in the field, although I would always say that there is no substitute for experience.
  • It’s a great way to learn about the features of the product.
  • Can help towards a promotion or get you more leverage for that pay increase you are after.

What costs are involved?

There will be a wealth of books available and Microsoft amongst others will usually supply dedicated reference material for at least some of the exams which you can purchase.

For each exam you sit, there will be a fee. Exams can be booked through Prometric and you can get an up to date price list from them on their site.

Consider using Books Online because it is a comprehensive reference tool and should provide a wealth of material which will be of use and could save you buying books.

Try and convince your employer to help contribute towards the costs illustrating the benefits that a SQL Server 2012 certification can bring to the business.

How I would study for SQL Server 2012 certification

I can’t tell you what method works best as I simply don’t know. Everyone is different and if you have studied for a sql server certification in the past, you will probably already have a method and routine which works.

This may sound obvious but organization will be key. I have to come up with a plan and stick to it. My life outside of work needs to have more structure if I am to achieve my goals and be ready to sit the exams.

Inside of work I like to be organized. Outside of work, I am more relaxed about things and I tend to “go with the flow”. I’ve got to change that. I want to draw up a schedule whereby each week, I have a plan to follow. I’m going to have to treat this as a project, break it down into chunks of study and tick them off when I have completed them.

As with any project, goal posts may have to be moved to accommodate change. I might have a week when I have had to work more hours in the office to get things done. This will set me back but I have to ensure that I get those study hours in somewhere else in order to catch-up. So sacrifices may have to be made.

There will be many other DBA’s out there who have already studied for a MCTS or MCITP. They may have their own blogs or they may contribute to discussions on forums. I will look for any advice that they can provide.

At the time of writing this post, the books which are due to be released on the exams are not yet available. However it doesn’t stop me from learning about the product. I am using the SQL Server 2012 RC0 download but SQL Server RTM is also now available to download on a 6 month evaluation if you wanted to use that.

I highly recommend that you create yourself a virtual environment in which to play in. Windows 2008 R2 is also available on a evaluation basis so if you have the capacity, set up some virtual machines, install one of the SQL Server versions I have mentioned and start learning using the Microsoft exam outlines and SQL Server 2012 Books Online to support your training.

For virtual clients, I use VirtualBox from Oracle and below are the links for Windows 2008 R2 and SQL Server 2012 RTM

SQL Server 2012 RTM Evaluation

Windows 2008 R2 Evaluation

And finally…

I’m still undecided. I am definitely tempted to sit the SQL Server 2012 certification exams. I know they will be of great benefit in my career and the feeling of achievement in becoming a recognized SQL Server professional will I am sure be a great one.

Update…

You can read more on this topic in this post

Filed Under: All Articles, Career Development Tagged With: certification, mcitp, mcts, sql server 2012

Categories

  • All Articles (82)
  • Career Development (8)
  • MySQL Administration (18)
  • MySQL Performance (2)
  • SQL Server Administration (24)
  • SQL Server News (3)
  • SQL Server Performance (14)
  • SQL Server Security (3)
  • SQL Tips and Tricks (19)

Top 10 Popular Posts

  • Using sp_change_users_login to fix SQL Server orphaned users
  • How to shrink tempdb
  • MySQL SHOW USERS? – How to List All MySQL Users and Privileges
  • How to Transfer Logins to Another SQL Server or Instance
  • How to Delete Millions of Rows using T-SQL with Reduced Impact
  • T-SQL – How to Select Top N Rows for Each Group Using ROW_NUMBER()
  • New T-SQL features in SQL Server 2012 – OFFSET and FETCH
  • How to Kill All MySQL Processes For a Specific User
  • Using exec sp_who2 to help with SQL Server troubleshooting
  • How to move tempdb

Recent Posts

  • How to Setup MySQL Master Master Replication
  • How To Use SQL to Convert a STRING to an INT
  • How to set up MySQL Replication Tutorial
  • How to Use SQL CASE for Conditional Logic in Your SQL Queries
  • Using ISNULL in SQL Server to Replace NULL Values

Search

Connect

  • Twitter
  • Facebook
  • Google+
  • RSS

About

  • Cookie Policy
  • Disclaimer
  • About
Copyright © ‘2021’ DBA Diaries built on the Genesis Framework

This site uses cookies. We assume you are happy with cookies but click the link if you are not. Close