+ Reply to Thread
Page 2 of 4 First 12 34 Last
Results 26 to 50 of 76

Thread: 70-461

  1. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #26
    I looked at the transcender and it's pretty pricey.

    How are you liking it so far?
    Reply With Quote Quote  

  2. SS -->
  3. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #27
    I just bought the training kit eBook.

    I'm enjoying it so far. I think I'm just going to use the training kit, the Sybex book, and the mva videos.

    Hopefully its enough.
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #28
    I personally thought the training kit was lame. I ended up getting SQL Server 2012 Programming book from Mike Murach, it's not aligned with the exam topics, but the techniques and coding suggestions are very helpful. I love the aggregation components in that book.

    The Training Kit is a fail IMO. But of course that is coming from a guy who failed the exam twice. Good news is management likes me and I have been promoted twice lol.

    I guess the saying you can't have it all is correct!

    I might end up going through the Lynda.com 70-461 training, but man 5+ hours! It's almost like they think you don't have a life.
    Last edited by DatabaseHead; 06-07-2016 at 05:55 PM.
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #29
    Thoughts about getting the MTA for database? Do you think this would give you some momentum to go into the 70-461? I'm seriously thinking about it, I want to get so MS database on my resume. It's the only database management system I use besides Access.
    Reply With Quote Quote  

  6. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #30
    yeah, i dont have a life haha

    i work full-time Mon-Fri, and then I have a second job on the weekend where I work 12hrs Sat and Sun.

    I basically stare at a screen all day at my weekend job, so I spend it studying for certs and watching youtube videos.

    @databasehead

    do you work as a DBA already?
    Reply With Quote Quote  

  7. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,339

    Certifications
    CISSP
    #31
    Quote Originally Posted by DatabaseHead View Post
    Thoughts about getting the MTA for database? Do you think this would give you some momentum to go into the 70-461? I'm seriously thinking about it, I want to get so MS database on my resume. It's the only database management system I use besides Access.
    MTA database official book is great. Your call on if the exam is worth the $150.
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  8. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #32
    Thanks for the heads up Carl. I think I might go for it, seems manageable.

    @ Daniel

    I work as a master data analyst, so I manage the data that comes into the database and build SQL scripts to review data, look for integrity issues etc. I do build tables, views and large queries. So not really but sort of
    Reply With Quote Quote  

  9. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #33
    @DatabaseHead

    That's still pretty cool man
    Reply With Quote Quote  

  10. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    1,940

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #34
    But, oh so worth it! Very close to the test questions.
    Never let your fear decide your fate....
    Reply With Quote Quote  

  11. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #35
    i might get it after I go through these books
    Reply With Quote Quote  

  12. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    1,940

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #36
    Plus you get flashcards. I know, you are excited now, right?
    Never let your fear decide your fate....
    Reply With Quote Quote  

  13. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #37
    Scared which book are you talking about? Sorry lost it....
    Reply With Quote Quote  

  14. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #38
    thats cool, making your own flashcards sucks
    Reply With Quote Quote  

  15. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #39
    Are you guys going to talk me into reading my training kit book again?! I literally have pages falling out of the dang thing, in fact it's hard to keep it in order now the binding has given way. Ugh....... For the life of me I can't stomach the XML section. Maybe I'll take some pills or something to help me focus.
    Reply With Quote Quote  

  16. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #40
    I think scared is talking about Transcender. The questions are similar to the actual test and it comes with flashcards..

    Training kit doesnt seem too bad. Working with XMLs in SQL is definitely a weakness of mine but we use them a lot at my job.
    Reply With Quote Quote  

  17. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #41
    269 just for the e training? Anyway to swing a package deal?
    Reply With Quote Quote  

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

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #42
    Quote Originally Posted by DatabaseHead View Post
    Scared which book are you talking about? Sorry lost it....
    Transcender, when you buy the test, it comes with flashcards
    Never let your fear decide your fate....
    Reply With Quote Quote  

  19. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    1,940

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #43
    But the Training Kit doesn't cover XML that much. Joe's Pro's Volume 5 covers that. With a much less complicated view. I love it.
    Never let your fear decide your fate....
    Reply With Quote Quote  

  20. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,339

    Certifications
    CISSP
    #44
    I found the Training kit to be pretty good, but the XML section was dry. Practice, practice, practice.
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  21. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #45
    I'm actually working on a query right now, I always seems to default to the virtual table aka Derived Table. Love them joins in the from......

    Just can't seem to get away from them.
    Reply With Quote Quote  

  22. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #46
    Derived tables are pretty cool. It made things so much easier when I figured out how to write subqueries. I used to select a column then copy the results and use them in a where clause. It was a pain having to format each element with single quotes...

    Good times...

    Then tried figuring out if I could store the select statment as an array.

    It blew my mind when I figured out you could select from a select statment.
    Reply With Quote Quote  

  23. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #47
    Blow my mind I am not sure I follow. Any white pages or sites in regards to this? I am familiar with Array's and Collections from VBA back in the day when Access was the thing lol. Not sure how you call them in your select. Are you talking about doing a distinct in a sub select and then referencing it in your outer select?
    Reply With Quote Quote  

  24. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #48
    Quote Originally Posted by DatabaseHead View Post
    Blow my mind I am not sure I follow. Any white pages or sites in regards to this? I am familiar with Array's and Collections from VBA back in the day when Access was the thing lol. Not sure how you call them in your select. Are you talking about doing a distinct in a sub select and then referencing it in your outer select?
    Select <select list>
    From (select <select list> from table_name where col = x)

    This is a basic select from a select. I thought this was what u meant by derived tables.

    My array idea didn't work.

    I'll post a link later
    Reply With Quote Quote  

  25. Senior Member
    Join Date
    May 2016
    Posts
    1,627

    Certifications
    ITIL V3 F, ITIL OSA, ITIL ST
    #49
    Yeah that's it for me.

    SELECT *
    FROM A LEFT OUTER JOIN ( SELECT * FROM B ) AS C ON C.UI = A.UI INNER JOIN
    Another table etc. Usually when I have to sum or max/min to a certain level and then join back into the table. Clear as mud?!
    Reply With Quote Quote  

  26. Junior Member
    Join Date
    Mar 2015
    Posts
    25

    Certifications
    CompTIA A+
    #50
    Lets say there are two tables: Person and Documents.

    Lets also say that the personid is an attribute in both tables but all I know is the peoples names.

    John
    Mark
    David

    I want all records from documents associated with these three people.

    So I need their IDs.

    I would write

    SELECT personid FROM dbo.person WHERE firstname in ('John','Mark','David')

    Results:
    personid
    1
    2
    3

    Now i have to write another query and use those results in the WHERE clause. I thought that maybe it was possible to store it as an array or something. This is before I knew about JOINS or subqueries. I was thinking that I could store 1, 2, 3 as a variable.
    Reply With Quote Quote  

+ Reply to Thread
Page 2 of 4 First 12 34 Last

Social Networking & Bookmarks