Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

SQL Server 2008 vs SQL Server 2012 course

Options
  • 09-03-2016 5:07pm
    #1
    sheroman01
    Registered Users Posts: 4,669 ✭✭✭


    I've tried looking online for an answer to this but is proving difficult.

    I'm applying for a DBA role in my current job. Vast majority of our clients use SQL Server 2008r2, the other minority being SQL Server 2012. So I primarily work with 2008r2.

    I see that there are 2 routes to go down:

    --SQL Server 2008 Course/Exam--
    2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
    6231 Maintaining a Microsoft SQL Server 2008 R2 Database
    6232 Implementing a Microsoft SQL Server 2008 R2 Database

    --SQL Server 2012 Course/Exam--
    20461 Querying Microsoft SQL Server
    20462 Administering Microsoft SQL Server Databases
    20463 Implementing a Data Warehouse with Microsoft SQL Server

    Which course am I best off doing?

    SQL Server 2008 makes sense as we deal mainly with it. But, long term 2012 will be better as it's future proof and people could upgrade.

    Would the 2012 Course/Exam cover most of what's involved in 2008?

    I could do 2008 Course/Exam and then do the Upgrade to 2012 exam (457 and 458) - but - how much knowledge will I need to make this transition? Can't find any transition courses around.

    Thanks!


Comments

  • Options
    #2
    Lazairus
    Registered Users Posts: 303 ✭✭Lazairus


    sheroman01 wrote: »
    I've tried looking online for an answer to this but is proving difficult.

    I'm applying for a DBA role in my current job. Vast majority of our clients use SQL Server 2008r2, the other minority being SQL Server 2012. So I primarily work with 2008r2.

    I see that there are 2 routes to go down:

    --SQL Server 2008 Course/Exam--
    2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
    6231 Maintaining a Microsoft SQL Server 2008 R2 Database
    6232 Implementing a Microsoft SQL Server 2008 R2 Database

    --SQL Server 2012 Course/Exam--
    20461 Querying Microsoft SQL Server"



    I thought that you could do 2008 and upgrade throught a path.
    20462 Administering Microsoft SQL Server Databases
    20463 Implementing a Data Warehouse with Microsoft SQL Server

    Which course am I best off doing?

    SQL Server 2008 makes sense as we deal mainly with it. But, long term 2012 will be better as it's future proof and people could upgrade.

    Would the 2012 Course/Exam cover most of what's involved in 2008?

    I could do 2008 Course/Exam and then do the Upgrade to 2012 exam (457 and 458) - but - how much knowledge will I need to make this transition? Can't find any transition courses around.

    Thanks!

    Which did you end up doing in the end. Im intersted in doing this also.


  • Options
    #3
    L1011
    Registered Users Posts: 68,898 ✭✭✭✭L1011


    Most 2008 exams have been retired - 2008R2 may be the start of what I'd consider the current generation (proper 64 bit support, modern reporting services etc) but it is rather old.

    Some of them were still available in March and gone now. If there's any left I'd still go straight for 2012.


  • Options
    #4
    sheroman01
    Registered Users Posts: 4,669 ✭✭✭sheroman01


    Thanks for getting back to me. Yeah, I noticed that. I'm going with "20461 Querying Microsoft SQL Server 2012/4" and "Administering Microsoft® SQL Server 2012/4 Databases", especially as they cater for 2012 and 2014 versions.

    Can someone recommend me the best training company to choose from? I'm stuck between New Horizons, SureSkills and GlobalKnowledge. My preference is to have a classroom and lecturer based - i.e. the lecturer going everything first, then we work on it on the labs.


Advertisement