October 29, 2015 at 4:33 am
Hi all
I've been an accidental DBA for a few years before now but there's an opportunity where I now work to become a "fully-fledged" DBA.
I've said that I am willing to do the job but I'd need some training courses so fine-tune/fill in the gaps in my knowledge.
We've got instances ranging from SQL2005 up to SQL2012.
What training courses/exams would people recommend?
We've got some MS vouchers to use so courses offered by MS would be preferable.
October 29, 2015 at 4:51 am
Where are you based and what will you mostly be doing, admin, development, bit of both?
October 29, 2015 at 5:55 am
I'm in the UK (not sure if you need anything more specific than that).
I'll be doing mostly DBA work probably with a bit of development thrown in to keep occupied in the quiet times.
October 29, 2015 at 6:07 am
Yeah thats all I needed to know.
Firebrand would be my first choice (you will get a heavy discount on their courses with vouchers), failing that QA who also accept vouchers
I have used Firebrand now for a couple of courses and cannot fault their setup. Yes its an intensive process, usually 12 hours a day training so its pretty solid and jam packed, but you get 461,462 and 463 training done in 9 days with exams to try and get the cert (option to take the vouchers and use them at a different time if your not ready to do the exams there and then), hotel, meals, drinks all included in the price.
QA is more relaxed, to do all three courses your looking 15 days, but no exams.
Just really depends on what you want and how you want to do it.
October 29, 2015 at 6:16 am
While certification course are great to stand out; there is no assurance they will help with all the scenarios you are going to face or explain in details those that you will face.
It might be better to read Tom Carpenters book on SQL server administration and follow that up with SQL Server Internals from Kalen Delaney
Just to round things off you might also want to read dissecting sql server execution plans grant fritchey.
For the rest MSDN is always there to fill the gaps, being a DA is really learning on the Job and a crash course can only go so far
October 29, 2015 at 6:22 am
Jayanth_Kurup (10/29/2015)
While certification course are great to stand out; there is no assurance they will help with all the scenarios you are going to face or explain in details those that you will face.It might be better to read Tom Carpenters book on SQL server administration and follow that up with SQL Server Internals from Kalen Delaney
Just to round things off you might also want to read dissecting sql server execution plans grant fritchey.
For the rest MSDN is always there to fill the gaps, being a DA is really learning on the Job and a crash course can only go so far
I agree, there is no better learning than doing it in your environment, but the courses provided by MS do give a grounding for further development.
But as the OP wanted to know about available training courses, I have passed on companies I have used in the past for official Microsoft training on the topics.
October 29, 2015 at 6:47 am
Thanks folks.
I've been thrown in at the deep end before and (just about) managed to swim..... well, most of the time.
I'm just looking for something reasonably formal to fill in some of the basic gaps.
October 29, 2015 at 6:54 am
The MS courses, do touch on the basic things.
https://www.microsoft.com/en-gb/learning/exam-70-461.aspx
https://www.microsoft.com/en-gb/learning/exam-70-462.aspx
https://www.microsoft.com/en-gb/learning/exam-70-463.aspx
Take a look at the skills measured areas to see if these are any of the skills you would like to develop more, going to say 70-462/20462C is the course that may be most beneficial.
Just all really depends on what topics you want to touch on
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply