+ Reply to Thread
Results 1 to 11 of 11
  1. Senior Member
    Join Date
    Jun 2008
    Posts
    213
    #1

    Default Has anyone passed 461, 462, 463 without work experience?

    I'm a software tester with 3-4 years of experience and touch sql server management studio once in a while to check data records but I don't really count this as experience. I also worked 1 year in application support but didn't really use SQL Server that much (only basic restore database, increase size).

    I'm curious if anyone passed these exams (461, 462, 463) through self-study by reading books and training videos?
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member
    Join Date
    Jul 2012
    Location
    Montreal,QC Canada
    Posts
    221

    Certifications
    P+, Cloud+, 74-409, CCNA R&S
    #2
    I'm studying for the 462 without any experience. Labbing a lot can help mitigate that you don't have much experience. However, I'm doing this exam in lieu of the 412 for the MCSA Windows Server, as I feel like having basic knowledge of how to Administer SQL Server could be useful
    Last edited by nster; 04-16-2015 at 06:50 PM.
    Reply With Quote Quote  

  4. Member
    Join Date
    Feb 2015
    Location
    South Africa
    Posts
    60

    Certifications
    , SAP Business One, ITIL, MCSA SQL 2012
    #3
    Define software tester,

    Have you done any Visual Studio Work

    462 I would say if you have half a clue about computers, domains, file systems you can wing it, no problem
    461 Is a bit of a different beast, and you can do it without any experience, but your going to need to work hard at it, as there is a lot of cognitive links you wont have without experience,

    The exam querying on 461 is basic, but you need to be able to visualize data, tables, have reporting experience ect. THis has to be in minds view, you need to understand all of this. Example, if I talk about a common table expression, your not going to get why it rocks if you have not sat there for hours and hours and have written queries that have 10 or more L/R joins, or why use views, your aggregate functions.

    463, I will let ya know how it goes, as I have just started, but this looks to be largely based in visual studio...
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    Jun 2008
    Posts
    213
    #4
    Quote Originally Posted by nster View Post
    I'm studying for the 462 without any experience. Labbing a lot can help mitigate that you don't have much experience. However, I'm doing this exam in lieu of the 412 for the MCSA Windows Server, as I feel like having basic knowledge of how to Administer SQL Server could be useful

    Thanks. I'll probably study 462 first then 461.
    Reply With Quote Quote  

  6. Senior Member
    Join Date
    Jun 2008
    Posts
    213
    #5
    Quote Originally Posted by zaleonardz View Post
    Define software tester,

    Have you done any Visual Studio Work

    462 I would say if you have half a clue about computers, domains, file systems you can wing it, no problem
    461 Is a bit of a different beast, and you can do it without any experience, but your going to need to work hard at it, as there is a lot of cognitive links you wont have without experience,

    The exam querying on 461 is basic, but you need to be able to visualize data, tables, have reporting experience ect. THis has to be in minds view, you need to understand all of this. Example, if I talk about a common table expression, your not going to get why it rocks if you have not sat there for hours and hours and have written queries that have 10 or more L/R joins, or why use views, your aggregate functions.

    463, I will let ya know how it goes, as I have just started, but this looks to be largely based in visual studio...
    I haven't done Visual Studio work. Programmers uses it everyday and we only use visual studio for automation once in a while. Based on your comment, I think I'll study for 462 first. I took a SQL query course a long time ago (select statements, left and right inner/outer joins, order by, etc) but it's most likely not enough to master the exam.

    I'm looking at the 463 exam objectives. It talks about "Design and implement dimensions" and "Design and implement fact tables". The software I test at work is related to Fact Tables, Analysis Services, Dimensions, Attributes. I'm more interested in this exam though: https://www.microsoft.com/learning/e...am-70-448.aspx
    ,

    Thanks
    Reply With Quote Quote  

  7. Senior Member
    Join Date
    Jul 2012
    Location
    Montreal,QC Canada
    Posts
    221

    Certifications
    P+, Cloud+, 74-409, CCNA R&S
    #6
    BTW, you can substitute the 463 by the 411 412 or 483
    Reply With Quote Quote  

  8. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #7
    Man if you can do this without experience hats off. I failed 461 twice and I write SQL everyday for over 2 years and not just selects, but SP, triggers, CTE, Windowing, advanced aggregates etc. I eventually backed off due my career progression plan, (mapped out by my bosses).

    I think it would be great to get but I just don't see how someone with 0 SQL skills can pass 461.
    Reply With Quote Quote  

  9. Junior Member Registered Member
    Join Date
    Apr 2015
    Location
    South Africa, Johannesburg
    Posts
    3

    Certifications
    ICDL, A+, N+, MCTS Vista, MCP Windows 2008 Server Administration, SCSA, SCNA
    #8
    Well it's a bit two folded. On the one side, you need to study and cover all the exam objectives, this you can achieve by reading books and watching Nuggets, Trainsignal videos etc. While on the other hand, if you're working with the technology this makes it easier for you to relate to some of the scenario questions during the exam.

    The sad part about all these certifications is that not everyone that's certified really has a clue how to implement everything in real-world production/Development environments. So 8 times out of 10, companies tend to be more lenient towards experience than certification accolades
    Reply With Quote Quote  

  10. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #9
    From what I have seen database is all experience.
    Reply With Quote Quote  

  11. Junior Member
    Join Date
    Feb 2015
    Location
    Richmond, VA
    Posts
    10

    Certifications
    MTA
    #10
    Good points @N2IT and MohauMoorosi. I just started using SQL in 2013 and haven't used it much day to day in about 10 months. I passed the 98-364 no problems and can't really gauge how I did on my first attempt at the 70-461 because I didn't really study for it as I needed. However, in studying for it properly this go around (utilized Free Second Shot) using the Itzik Ben-Gan MS Training Kit and then PluralSight it is a lot better knowing your way around SQL and then using the study materials to just add and fill in the knowledge. The 70-461 is definitely difficult and the scenarios where it has you sometimes write code means you have to understand the concepts.
    Reply With Quote Quote  

  12. Senior Member
    Join Date
    Jun 2008
    Posts
    213
    #11
    Thanks for the feedback so far. Now, I backed out and not planning to go for MCSA (461, 462, and 463).

    Anyone know if MCTS (individual exam) worth getting?
    MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
    MCTS: Microsoft SQL Server 2008, Implementation and Maintenance
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks