certification for SQL 2016

Posted on 2016-10-13
Last Modified: 2016-10-28
What would you recommend for someone wanting to get certification for SQL Server 2016, (courses? books? online?) ?
Question by:Jess31
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
LVL 65

Expert Comment

by:Jim Horn
ID: 41842752
For starters, you need the on-the-job experience.  In my opinion it is not a realistic expectation for a programmer or student to study this without any experience with an expectation to pass the certification exams.

Once you have that, buy the MS Press book off of eBay.  Why eBay?  Because chances are you'll be buying from someone that just passed the exam and doesn't need the book anymore so it's already highlighted, maybe will include a cheat sheet for you, and will be pretty cheap.  Then when you pass the exam you can sell the book on eBay yourself.

Outside of the certification part of your question, check out SQL Server Training.
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 41843194
To be honest anybody minimal intelligent can get a MS Certification in any field if he or she is really work hard during the course and especially make a lot of tests. Many of those tests can be found in the internet with the solutions. Having those tests done dozens of times it will show you the kind of questions that the real certification test has and will make you able to get the certification.

That's the main reason I don't give importance on MS Certifications. I know already many people that are certificated and doesn't know almost nothing about the field where he or she is certificated for.
LVL 28

Expert Comment

by:Pawan Kumar
ID: 41843414
Agree with the above comments given by the experts. Certifications will not help. People use dump to clear their certifications.

I would suggest study the subject and do lot of practicals on it. Solve queries, write lot of queries, do practical on all the topics like CTE, Temptable, tablevariables, Cursors,function, storedprocedures, recursion,isolation levels, etc.. then only you will have a in depth knowledge of the subject.

If you still want to go ahead with certification then below is the URL for you..

Also note that certification will depend on your track. - DBA / DEV?

Also note that this will only help you in your resume getting selected by recruiters all the time.
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.


Author Comment

ID: 41844102
Jim, the eBay idea sounds interesting but at leas in this case as its for SQL 2016 which is new there is nothing available on eBay. I have not found any books on Amazon either.
LVL 65

Expert Comment

by:Jim Horn
ID: 41844120
Looks like it's only out for 2012/2014.  Last I remember the only jobs where current version certification is critical are consultants and trainers.  According to Microsoft's own SQL Server 2016 certification path some of these exams are still in development, and there's usually a lag between the exam being public and when training books are available.  

So if anyone is pressuring you about 2016 certification, I'd push back and ask them why, if nothing else to assess whether they know what they're talking about.
LVL 28

Expert Comment

by:Pawan Kumar
ID: 41844591
Below is the URL where you can find SQL Server books on Amazon..

If you only wants SQL Server 2016 books below is the URL..

SQL 2016 is still in CTP version so I think you can choose SQL 2012 version for certifications. Below URL will help.

Amazon also has certification material at below

Also let me know are you a dev / dba and which certification you want to go ahead with. I can help with that.

Hope it helps.

Author Comment

ID: 41845331
It is for Dev and 20016 (all the books I see on Amazon that relate to MCSA is not for 2016),
LVL 28

Accepted Solution

Pawan Kumar earned 250 total points
ID: 41845360
Okies great that you are looking for DEV.

For Dev below are the options

MCSA: SQL 2016 Database Development

1      Querying Data with Transact-SQL [761]
2      Developing SQL Databases [762]

MCSA: SQL 2016 Business Intelligence Development

1      Implementing an SQL Data Warehouse [767]
2      Developing SQL Data Models [768]

The books are not available as 2016 is very new in still in CTP version. You may find books for 2016 in future.

Also read -- How valuable are certification?

Hope it helps !!
LVL 50

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 total points
ID: 41846212
SQL 2016 is still in CTP version
What do you mean CTP? Last CTP version (3.3) was released on February and after that MS released 4 RC versions. RTM version is available since 1st of June and an Evaluation version is available for use full features for 180 days.
LVL 65

Expert Comment

by:Jim Horn
ID: 41863982
Jess - Please explain why you accepted the answers you did, as your question reads 'What is your recommendation for SQL Server 2016 Certification?', I gave a lot of helpful advice, and the first answer you accepted looks like a copy-paste of Microsoft's certification exam path.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
semaphore timeout period has expired 1 31
Begin Transaction 12 26
Report 8 27
how to use ROW_NUMBER() correctly 8 44
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question