70-461 - SQL Server 2012 Querying a Datbase

  • Just started to look at the certs for 2012 and it looks like this needs to be taken before you really get going. Cant seem to find any resources on web to assist. Any idea when the beta tests will be out for this or what you need to do to get on one.

    Might leave this for a bit and try and squeeze in SQL 2008 BI certs first

    M

    😀

  • I doubt you'll find any resources until the exams are released. I think June/July has been mentioned.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Many thanks. I did a quick search on Amazon etc and found no books at all so that would suggest it is a fair way off.

    Cheers

    Mark

  • Just reading through 70-461 Skills Measured and came across this

    •Design views.

    ?This objective may include but is not limited to: ensure code non regression by keeping consistent signature for procedure, views, and function (interfaces); security implications

    Any suggestions as to what this means (I have tried googling but to no avail)

    Any pages with info would be fabulous.

    Cheers

    Mark

  • A procedure's signature is its parameters and output. So say I have a procedure that accepts an int parameter and returns a single resultset of a particular form. I can change the contents of the procedure (optimisation) and the front end app won't notice if I keep the procedure's signature the same, so it must still accept that int and return the same resultset

    Make a bit more sense? (no, I don't really understand what its asking either)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Many thanks. Makes perfect sense now.

    Cheers

    Mark

  • Ells (4/2/2012)


    There also appears to be a slight time lag in getting the cert track going. Very few books available and learning providers muttering that courses may be a little delayed.

    No idea about late, but the exams are still in beta and are still been tweaked and polished (and fixed) before release.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Sorry, I am new to SQL and I am still not very sure what it means. what is the front end app you mention in the sp?? Could you please provide a simple example?

    Many thanks

    Howie:-)

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply