+ Reply to Thread
Results 1 to 16 of 16
  1. Junior Member Registered Member
    Join Date
    May 2013
    Posts
    3
    #1

    Default Passed the 70-461 today. So happy

    Hi guys,

    I passed 70-461 exam today with 9**. Most of the questions are multiply choice.

    I am a .net programmer with 30% of my working time on sql server for 5 years. I also spent 2 weeks studying sql server 2012.

    Next will be 70-483 and 70-480.

    Wish you guys do well in 461 as well!

    Cheers
    Reply With Quote Quote  

  2. SS
  3. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,425

    Certifications
    CISSP
    #2
    Congrats!
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  4. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    330

    Certifications
    OCA MySQL, ITIL-F (2012),MCITP: SQL 2008 DB Dev.
    #3
    Congrats. What material(s) did you use ?
    Reply With Quote Quote  

  5. Junior Member Registered Member
    Join Date
    May 2013
    Posts
    3
    #4
    Mainly Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012
    Reply With Quote Quote  

  6. Junior Member Registered Member
    Join Date
    May 2013
    Posts
    3
    #5
    Do you think its possible for a novice to pass this exam by just reading the training kit book in a month ? I have almost no experience with SQL server. The only SQL I have written is simple joins and subqueries.
    Reply With Quote Quote  

  7. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #6
    Well done on the pass!
    Reply With Quote Quote  

  8. Senior Member
    Join Date
    Jul 2011
    Posts
    102

    Certifications
    A+, Net+, Sec+, MCITP:SQL Server 2008 DBA, MCITP: SQL 2008 BI Developer, MCSA SQL 2008 & 2012, MSCE SQL 2012
    #7
    Quote Originally Posted by aks86 View Post
    Do you think its possible for a novice to pass this exam by just reading the training kit book in a month ? I have almost no experience with SQL server. The only SQL I have written is simple joins and subqueries.
    Without any experience, the training kit is far from sufficient material to pass this exam. I took the upgrade version of this exam (457) and the questions will test all the major sections of querying.
    Reply With Quote Quote  

  9. Gaming Tech Expert Dakinggamer87's Avatar
    Join Date
    May 2008
    Location
    Silicon Valley,CA
    Posts
    3,956

    Certifications
    A+, Net+, Stor+, Proj+, Lin+, LPIC-1, CLA, MCP, MCSA, MCSE, CCENT, CCNA, CCNA:Sec, VCA-DCV/Cloud/WM, VCP, VCP-Cloud, CIW, vExpert '16/17, SSBBP, ITIL
    #8
    Congrats on pass!!
    *Associate's of Applied Sciences degree in Information Technology-Network Systems Administration
    *Bachelor's of Science: Information Technology - Security, Master's of Science: Information Technology - Management
    Matthew 6:33 - "Seek the Kingdom of God above all else, and live righteously, and he will give you everything you need."
    Reply With Quote Quote  

  10. Senior Member
    Join Date
    Feb 2011
    Location
    Wisconsin
    Posts
    143

    Certifications
    A+
    #9
    Good job!

    Reply With Quote Quote  

  11. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,425

    Certifications
    CISSP
    #10
    Quote Originally Posted by aks86 View Post
    Do you think its possible for a novice to pass this exam by just reading the training kit book in a month ? I have almost no experience with SQL server. The only SQL I have written is simple joins and subqueries.

    Sorry, I don't think so.
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  12. Junior Member Registered Member
    Join Date
    May 2013
    Posts
    3
    #11
    If as you said that you only know simple joins and subqueries, I would say it's not enough to pass the exam by just reading that book. The fact is in the actual exam, there are lot of questions that are not even covered by that book.

    I suggest that you need to check the skills measured part in Exam 70-461: Querying Microsoft SQL Server 2012.

    Remember that the exam is more about knowing concept rather than writing queris.

    Hope this will be helping you.
    Reply With Quote Quote  

  13. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #12
    Han is right. I failed the exam and I had basic knowledge. In my new role that is starting to grow and grow etc. I am going to wait a few months and revisit this exam. I really really want this lol
    Reply With Quote Quote  

  14. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,425

    Certifications
    CISSP
    #13
    Syntax is a killer on this exam. A colleague of mine recently failed this exam and he felt that syntax was one of the reasons he didn't pass. It's a tough exam but it is passable. If you have experience with SQL Server, likely the 70-461 book is all you need. If not, I would start with Iztik's beginner's book and then work through the 70-461. In either case, lots of practice is warranted.
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  15. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #14
    Yeah I grabbed Iztik's just to make sure my foundation is solid. I started off taking SQL design, foundation, and two other SQL courses, but never really used it. About 3 years ago I took another SQL course and started using it very lightly. Until my last 3 month contract and this new position I didn't have the chance to use it. Now I am getting a lot better at it. You start to learn quickly the book is dreamland scenarios. In real life you have to create a 3 level joined with 3 subqueries and several case statements imbedded into your code. Then you have to look at the data and see if it make sense. Then of course you have different layers of data and you have to make sure you are joining on data at the same level or it won't produce meaningful results. It gets tricky but I figure if I can keep hammering away for a few months and read Itzik book Ill start to seriously consider the exam. I really want this exam for several of reason. To prove to myself I can do it. To be able to list it in my professional summary. I like my certifications but none would be more meaningful for my line of work than this one. SQL certification professional has a nice ring to it.
    Reply With Quote Quote  

  16. Junior Member Registered Member
    Join Date
    Jul 2013
    Posts
    1

    Certifications
    MCP,MCTS
    #15
    Congrats! gladly im using Training Kit Querying Microsoft SQL Server 2012. hope to pass also
    Reply With Quote Quote  

  17. Senior Member aaronchristenson's Avatar
    Join Date
    Nov 2003
    Posts
    260

    Certifications
    MCSE Cloud Platform & Infrastructure MCSE Data Managment & Analytics, MCSA Windows Server 2012, MCSA SQL Server 2012/2014, MCSA Windows 10, Security+
    #16
    I need to get busy on this exam, I have been stuck on chapter 4 of the Training Kit for about a week. I have already passed the SQL Server Administrating 462 exam, so I have this one and the Data Warehouse one to take for the MCSA. I was thinking about taking the 2 upgrade exams thinking it might be easier (fewer questions on query) but my guess is that it will be like 417 where you have to get 700 in each section.
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks