+ Reply to Thread
Results 1 to 18 of 18
  1. Senior Member
    Join Date
    Mar 2012
    Posts
    123
    #1

    Default questions about exam 98-364 (MTA Database Administration Fundamentals)

    I passed 1ZO-051 (SQL Fundamentals I). I have some limited experience with Oracle DB. To say the truth for me the exam SQL Fundamentals I was really complicated, I invested much sweat.

    I am not a school boy, work since 16 years in IT - 10 years in support. I read that "MTA Database Administration Fundamentals" is now open for all people. I don't have any experience with SQL server.

    Should I take this MTA exam? What's you thoughts? Anyone took it?

    Is the book ISBN-13: 978-0470889169 - Exam 98-364: MTA Database Administration Fundamentals (Microsoft Official Academic Course) good for preparation? There are bad reviews on Amazon.com
    Reply With Quote Quote  

  2. SS -->
  3. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #2
    Those look like legit bad reviews, so I would not bother.

    I am uncertain as to the value of the MTA exams for actual IT professionals. If I were you, I would consider just doing the 70-461 exam.

    Querying Microsoft SQL Server 2012

    There is an MS Press Training Kit for this test and I have taken the MeasureUp practice tests that come with it. If they reflect even 75% of the actual difficulty of the exam, I could take it today, with no study and pass in the 900s. But I have 3+ years of intense SQL Server experience in both administration and development. I would expect that it would be on a similar level with the SQL Fundamentals exam and that using the Training Kit would be all that you need to pass the exam having already prepped for the 1ZO-051 exam. It will probably be 80% review for you.
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    Mar 2012
    Posts
    123
    #3
    thank you. The objectives for "Exam 70-461: Querying Microsoft SQL Server 2012" and "1ZO-051 SQL Fundamentals I" are almost the same. Will try if 70-461 is an easy win for me

    What title/certificate do I receive when I will pass 70-461?
    Is SQL Sever 2012 available for free on Windows8? Is there a XE-edition for free?
    Do you recommend me a good SQL server forum?
    Reply With Quote Quote  

  5. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #4
    It's called SQL Server Express Edition.

    Download SQL Server 2012 Express with SP1

    You will also want to get the management tools which will allow you to compose an execute queries.

    I believe the title will be something like Microsoft Specialist: Querying SQL Server 2012.

    For non-certification questions the SQL Team forums are very good. For certification specific stuff, you are of course, always welcome to ask here.
    Reply With Quote Quote  

  6. Junior Member
    Join Date
    Dec 2008
    Location
    Egypt, Cairo
    Posts
    1
    #5
    can u help me plz .. i'm looking for this book
    Reply With Quote Quote  

  7. Banned
    Join Date
    Dec 2012
    Posts
    117
    #6
    search 70-461 sql
    Reply With Quote Quote  

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

    Certifications
    CISSP
    #7
    The MTA database administration fundamentals is a great starting exam. The book you linked from Amazon is actually pretty decent. I read that book and passed the MTA exam with a 100% score.

    Here's the 70-461 book

    Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012: Itzik Ben-Gan, Dejan Sarka, Ron Talmage: 9780735666054: Amazon.com: Books
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  9. Senior Member knownhero's Avatar
    Join Date
    Jul 2008
    Location
    UK
    Posts
    435

    Certifications
    MCSE: SharePoint 2013, Productivity
    #8
    I have these 3 books which I am reading on and off as I work with SQL daily (for a year).

    1. Fundamentals
    2. Teach yourself SQL
    3. 70-461 Microsoft Book

    Also I plan to use the CBT Nugget 24 hour access 2 days before my exam.

    Good luck on the SQL path. I've found it both annoying and rewarding
    70-410 [x] 70-411 [x] 70-462[x] 70-331[x] 70-332[x]
    MCSE - SharePoint 2013

    Road map 2017: JavaScript and modern web development

    Reply With Quote Quote  

  10. Junior Member
    Join Date
    Oct 2013
    Location
    Ireland
    Posts
    21

    Certifications
    A+, Network+, MTA-DBA (98-364), MCSA 70-461(passed), 70-462(pending)
    #9
    MTA 98-364 can be found on Pluralsight - Hardcore Dev and IT Training in a video format (you don't really need the book as the videos explain it very well !) I am currently doing this course as I have no experience whatsoever with SQL. I know this certificate may not be very important but it's a start and it gives you motivation to move on to 70-461, 70-462 & 70-463 which are the more important parts for your career But I honestly think every newbie interested in starting with SQL should start off with the fundamentals exam.
    Reply With Quote Quote  

  11. Senior Member LinuxRacr's Avatar
    Join Date
    Jul 2010
    Posts
    634

    Certifications
    B.S. IT Security, A.A.S. Electronics Engineering Technology, ITIL V.3, A+, Security+, Linux+, Project+, CCENT, CCNA (R&S, Security), MTA: 98-364
    #10
    So ClausIRL, how did the exam go for the 98-364 after only using the Plurasight videos? I'm currently going though the same video in preparation for my exam, and need to test in less than 10 days.
    My WGU B.S. IT - Security Progress : Transferred In|Remaining|In Progress|Completed
    AGC1, CLC1, GAC1, INC1, CTV1, INT1, BVC1, TBP1, TCP1, QLT1, HHT1, QBT1, BBC1 (39 CUs), (0 CUs) (0 CUs)
    WFV1, BNC1, EAV1, EBV1, COV1 | MGC1, IWC1 | CQV1, CNV1, IWT1, RIT1 | DRV1, DSV1, TPV1, CVV1 | EUP1, EUC1, DHV1| CUV1, C173 | BOV1, CJV1, TXP1, TXC1 | TYP1, TYC1, SBT1, RGT1 (84 CUs) DONE!
    Reply With Quote Quote  

  12. Senior Member Kinet1c's Avatar
    Join Date
    Dec 2012
    Location
    Ireland
    Posts
    581

    Certifications
    CCNA, ITIL-F, LPIC-1, AWS-Sysops, AWS-CSA
    #11
    For those who have taken the exam, which resources did you find most beneficial?
    2016 Goals - Code and Script all the things in python and bash

    Luck is what happens when preparation meets opportunity
    Reply With Quote Quote  

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

    Certifications
    CISSP
    #12
    The MS press book is what I used. It was good, but is overpriced IMO.
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  14. Senior Member LinuxRacr's Avatar
    Join Date
    Jul 2010
    Posts
    634

    Certifications
    B.S. IT Security, A.A.S. Electronics Engineering Technology, ITIL V.3, A+, Security+, Linux+, Project+, CCENT, CCNA (R&S, Security), MTA: 98-364
    #13
    I passed the exam today. I only used the Pluralsight course, working with SQL Server in my virtual lab (Win server 2008 R2), and going through the MeasureUp practice test one time (reviewing the material for any question I missed). The practice test was harder! I will say that I had minimal previous experience with MySQL at a prior job.
    My WGU B.S. IT - Security Progress : Transferred In|Remaining|In Progress|Completed
    AGC1, CLC1, GAC1, INC1, CTV1, INT1, BVC1, TBP1, TCP1, QLT1, HHT1, QBT1, BBC1 (39 CUs), (0 CUs) (0 CUs)
    WFV1, BNC1, EAV1, EBV1, COV1 | MGC1, IWC1 | CQV1, CNV1, IWT1, RIT1 | DRV1, DSV1, TPV1, CVV1 | EUP1, EUC1, DHV1| CUV1, C173 | BOV1, CJV1, TXP1, TXC1 | TYP1, TYC1, SBT1, RGT1 (84 CUs) DONE!
    Reply With Quote Quote  

  15. Junior Member Registered Member
    Join Date
    Jan 2014
    Posts
    1
    #14
    hey,
    i am a college passout fresher, I want to give microsoft 98-364 exam but i am unable to find out how to apply or enroll into
    please help me out
    Reply With Quote Quote  

  16. Junior Member
    Join Date
    Oct 2013
    Posts
    27
    #15
    I would rather skip the MTA exam and go directly to 70-461. If you are a beginner it might take a while to prepare for it but it would be well worth it.

    I took a MTA exam recently (98-365 - Windows server administration fundamentals) with zero study and yet passed by just using common sense and educated guesses. And trust me , I have zero knowledge of Windows server environment. I didn't even study for the exam for a minute as I was sick.

    CIW perl I passed without even knowing perl syntax and just applying my generic knowledge of programming (in PHP).

    I realize this may not hold true for all but my opinion is that both CIW and MTA exams are quite worthless and not worth the buck IMO even if you are a beginner. They don't really carry much weight anyway except making your resume more wordy.
    Last edited by aswebdev; 01-06-2014 at 04:00 PM.
    Reply With Quote Quote  

  17. Junior Member Registered Member
    Join Date
    Jan 2014
    Posts
    1
    #16
    can u help me plz ......
    I want to give the exam of microsoft 98-364. Icould not find preparation material for this......Can anyone guide me???
    Reply With Quote Quote  

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

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

  19. Junior Member
    Join Date
    Oct 2013
    Location
    Ireland
    Posts
    21

    Certifications
    A+, Network+, MTA-DBA (98-364), MCSA 70-461(passed), 70-462(pending)
    #18
    Learn the following well guys and you will pass the exam, you don't need to study from a book, just take notes from this course below for 2-4 weeks and you'll be fine for the pass ! it's just $29 for the month and about $120 for the exam, well worth it in my opinion and it will kick start you towards becoming a DBA or DB-Dev. Good luck !

    Microsoft MTA: Database Administration Fundamentals - Online Training Course for Developers
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks