+ Reply to Thread
Page 1 of 2 1 2 Last
Results 1 to 25 of 32
  1. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    2,046

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #1

    Default Failed 70-461..will try again in 2 weeks

    UGH, hate failing tests. Will regroup and take in 2 weeks.
    Never let your fear decide your fate....
    Reply With Quote Quote  

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

    Certifications
    CISSP
    #2
    Great attitude! Where were you weak? This exam is known to be tough!
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  4. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    2,046

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #3
    Just about everything..LOL. XML was the worst.
    Never let your fear decide your fate....
    Reply With Quote Quote  

  5. Junior Member Registered Member
    Join Date
    Feb 2016
    Posts
    1
    #4
    i have also taken the 70-461 exams and xml was the worst
    Reply With Quote Quote  

  6. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    2,046

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #5
    Did you pass @RonaldVDW?
    Never let your fear decide your fate....
    Reply With Quote Quote  

  7. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #6
    XML is the worst. Auto, Raw - Hmmmmm what's on TV......
    Reply With Quote Quote  

  8. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    2,046

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #7
    and don't forget the Elements! Yes, what is on tv?
    Never let your fear decide your fate....
    Reply With Quote Quote  

  9. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,379

    Certifications
    CISSP
    #8
    This test is totally passable just has a lot of information. Keep at it, you can do it!
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  10. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #9
    Quote Originally Posted by scaredoftests View Post
    and don't forget the Elements! Yes, what is on tv?
    Ahh yes the lovely elements. SP, Triggers, Merge statements no problem. GOOD FORMED XML. Night night!

    Keep on us Carl, I need it. I really want to get the MCSA SQL. I literally can call it a certification career if I completed those 3 test. Okay truth be told I have a strong desire to get the MCSE BI.
    Last edited by DatabaseHead; 06-16-2016 at 06:32 PM.
    Reply With Quote Quote  

  11. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    2,046

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #10
    what is maddening, is the week-long class I went to, hardly covered XML.
    Never let your fear decide your fate....
    Reply With Quote Quote  

  12. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #11
    Who was it through? Transcender?
    Reply With Quote Quote  

  13. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    2,046

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #12
    It was local (Columbia md)
    Never let your fear decide your fate....
    Reply With Quote Quote  

  14. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #13
    How's Transcender treating you in regards to XML?
    Reply With Quote Quote  

  15. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    2,046

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #14
    It is hard (which I like). I am also reading SQL Queries 2012 Joes 2 Pros Vol 5, which covers XML and in a great way!
    Never let your fear decide your fate....
    Reply With Quote Quote  

  16. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #15
    Just to be safe can you send me a link to the book on amazon or the ISBN? Last thing I want to do is blow it and get the wrong book. Thanks!
    Reply With Quote Quote  

  17. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #16
    Reply With Quote Quote  

  18. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    2,046

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #17
    Quote Originally Posted by DatabaseHead View Post
    Also Part 5 is the book that has XML, explained really well.
    Never let your fear decide your fate....
    Reply With Quote Quote  

  19. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #18
    I tried to watch some of the free training and now they are blowing up my email. That was a mistake, Sarah from Joes to Pros.

    Side note.... I did see that they have a course for landing a job outside of the data / business analyst scope of work. Along the lines of advanced queries and ETL / Upsert type functions. Pretty interesting stuff, I was close to pulling the trigger but with Lynda being free for me the cheap in me won out.

    At the end of the day I just want to improve my skills and make more money.
    Reply With Quote Quote  

  20. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #19
    Updates?

    I'm going through the data querying modules on youtube, saving cash..... Learned NTILE today, of course I had heard of it and I am very familiar with windowing functions, but this could be very help with sales data, since I work in procurement. Not really an "IT guy", more of a technical procurement analyst / master data analyst. Anyway...... How goes it SoT?! I'm still working towards this bad boy.

    Sad thing is once I complete this I have to take the admin exam 462, which I have 0 knowledge about. We have a senior .net developer who takes care of all of that stuff......
    Reply With Quote Quote  

  21. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #20
    select *, NTILE(10) OVER (ORDER BY (SUM_PO) DESC)
    FROM qryActivity AS A
    JOIN (SELECT SUM(PO_VALUE_CALCULATED) AS SUM_PO, INV_YEAR_MO, SUPPLIER_ID
    FROM qryActivity as Q1
    GROUP BY INV_YEAR_MO, SUPPLIER_ID
    ) X ON X.INV_YEAR_MO = A.INV_YEAR_MO AND X.SUPPLIER_ID = A.SUPPLIER_ID
    ORDER BY A.INV_YEAR_MO

    Putting NTILE to work!

    Sorry I used a Derived Table, I usually prefer the modular approach with CTE's. But with 60 million records what difference does it make, I should of insert into #temp that's the best for large sets IMO.
    Last edited by DatabaseHead; 06-28-2016 at 01:35 AM.
    Reply With Quote Quote  

  22. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #21
    Just started my free trial of CBT Nuggets for 70-461. Made it through the first chapter, I am feeling really motivated hopefully this will lead to a pass.
    Reply With Quote Quote  

  23. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    2,046

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #22
    Quote Originally Posted by DatabaseHead View Post
    Just started my free trial of CBT Nuggets for 70-461. Made it through the first chapter, I am feeling really motivated hopefully this will lead to a pass.
    Let me know how it goes.
    Never let your fear decide your fate....
    Reply With Quote Quote  

  24. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #23
    Went through module 1 and 2. 1 was an introduction probably the 9th one I went through since starting this exam 3 years ago. However the second create, alter drop tables etc was pretty comprehensive. Started on Views but burnt, I'll finish that up tonight. I am pacing myself, but I like the preset up labs and the instructor goes pretty quick and covers a lot of information. I'll keep you posted.

    Addl info

    There are 20 modules each ~40 minutes, some 25 and some 55.

    My strategy is to use my lunch break to run through ones that I already know well, like Views (in fact there are two modules on views so I'll finish up one at lunch and maybe the other. I will do hardly any coding since most of it is repetitive. Things like XML, Stored Procedures and some of the more complex windowing I'll do at home and will take my time going through those, maybe 3 - 4 days per module. End game is to spend more time on the material I am weak in and blaze through the easier stuff.
    Last edited by DatabaseHead; 07-13-2016 at 03:39 PM.
    Reply With Quote Quote  

  25. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #24
    2 more chapters done, both related to views. Creation, Alter, Delete etc. Worked on giving permissions at the schema level and the database level, just for a particular database. Really did a deep dive in chapter 4 well beyond what was required but I liked it. Did it all by command line, I have all the scripts saved so at work if I get some down time (ya right) I'll go ahead and review them.

    In all seriousness I am thinking about doing 463 next the data warehouse one, I have soooooo much more experience in that world than I do 462.


    I'm dead serious I build fact and dimension all day long, updating our cubes and tabular tables. It wouldn't be a breeze but I could get through it fairly quickly.

    I'm curious if I could skip 462 and jump into 466 and 467 after completing 461 and 463. Save the worse for last! It seems sooooo boring.
    Last edited by DatabaseHead; 07-14-2016 at 05:25 AM.
    Reply With Quote Quote  

  26. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #25
    5 minutes in and I was done, going to have to wait to get home to go through chapter 5. Reeling back to 1 module a night, but so far so good.

    Barely use the book anymore, only to review and fill in gaps that may have been missed.
    Reply With Quote Quote  

+ Reply to Thread
Page 1 of 2 1 2 Last

Social Networking & Bookmarks