+ Reply to Thread
Results 1 to 17 of 17
  1. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #1

    Default Are there any SQL certifications geared towards analyst level work, not development?

    I took the SQL developer certification and it was a little to much for me to handle. I could ramp up but I am thinking why be someone you aren't or don't need. I am looking for an SQL certification that is entry level, but indepth enough to show I can use SQL to create all sorts of queries and know the fundlementals of relational databases.

    All I can think of now is Access and that doesn't really talk to much about SQL, infact is uses ANSI 86 not 92 like most SQL database management systems.

    Thoughts? Maybe I am SOL
    Reply With Quote Quote  

  2. SS -->
  3. Junior Starcraft Engineer
    Join Date
    Mar 2007
    Location
    Twin Cities, Minnesota
    Posts
    2,777

    Certifications
    A+, Net+, Security+, MCSA 2003, MCTS Win 7, AD, Net Infrastructure
    #2
    MCSA: SQL Server 2012, especially the first exam, 70-461, are what you're really looking for from what I can tell.
    Last edited by ptilsen; 05-17-2012 at 04:04 PM.
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #3
    I found the 70-433 way to much for me to handle. I studied for only 3 weeks, but had some SQL 2008 developer knowledge and still bombed at 500+.

    Nevermind just looked it up. That looks very promising.

    Thanks PT serious rep for that!
    Last edited by N2IT; 05-17-2012 at 03:29 PM.
    Reply With Quote Quote  

  5. Senior Member aaronchristenson's Avatar
    Join Date
    Nov 2003
    Posts
    253

    Certifications
    MCSE Cloud Platform and Infrastructure, MCSA Windows Server 2012, MCSA SQL Server 2012/2014, MCSA Windows 10, MCITP Server Admin, Security+
    #4
    Once the SQL 2012 exams are released you should take this one.

    Querying Microsoft SQL Server 2012

    This would be a good entry level exam, not a developer exam but would help there also.
    Aaron
    MCSE Cloud Platform and Infrastructure, MCSA Windows Server 2012, MCSA SQL Server 2012/2014, MCSA Windows 10, MCITP Server Admin, Security+, Virtualization with Windows Server Hyper-V and System Center Specialist
    Reply With Quote Quote  

  6. Senior Member
    Join Date
    Jan 2006
    Location
    SoCal
    Posts
    1,501

    Certifications
    MCSE, MCSA, CNA, CCNA (expired), Project+, Linux+, CNE (expired), OCA MySQL 5, ITIL Foundation
    #5
    I wonder if maybe getting certified in reporting tools would help in this instance, e.g. Crystal Reports certification.
    Reply With Quote Quote  

  7. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #6
    Aaron thanks a lot! That is freaking perfect! About time they come out with one like this.

    I mean honestly I don't markup my SQL with XML and 433 was all about XML.

    I just saw XML in the description, hopefully it's a small percentage of the actual exam unlike 433.

    @ Petedude

    Do you know if you can get free trials of this application off hand? And if so is this something you can self lab? We have it in the environment but I would feel weird asking for access to learn how to report in Business Objects/Crystal Reports.
    Last edited by N2IT; 05-17-2012 at 04:04 PM.
    Reply With Quote Quote  

  8. Junior Starcraft Engineer
    Join Date
    Mar 2007
    Location
    Twin Cities, Minnesota
    Posts
    2,777

    Certifications
    A+, Net+, Security+, MCSA 2003, MCTS Win 7, AD, Net Infrastructure
    #7
    Aaron got the link to the correct test there. I inverted the 4 and 6 -- it's 461.
    Reply With Quote Quote  

  9. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #8
    Yeah it looks challenging but doable. The key point for me is it's not making me out to be something I am not or want to be.

    Thanks again for the great information. I am actually excited about this exam, it synchs up with what I am trying to convey to my employee or future ones.
    Reply With Quote Quote  

  10. Senior Member
    Join Date
    Jan 2006
    Location
    SoCal
    Posts
    1,501

    Certifications
    MCSE, MCSA, CNA, CCNA (expired), Project+, Linux+, CNE (expired), OCA MySQL 5, ITIL Foundation
    #9
    Quote Originally Posted by N2IT View Post
    @ Petedude

    Do you know if you can get free trials of this application off hand? And if so is this something you can self lab? We have it in the environment but I would feel weird asking for access to learn how to report in Business Objects/Crystal Reports.
    There's academic versions of Crystal out there. I would just see if you can build a SQL server at the office on some old clunky machine, install an academic version of Crystal at your desk and plug away.

    I understand the awkwardness bit, believe me. Some environments are politically or culturally that way; in others it's a matter of having licensing and/or security issues that would make it infeasible for them to provide you those capabilities.
    Reply With Quote Quote  

  11. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #10
    Pete building a SQL box is doable, I can download the student developer 2008 or 2012. The interesting part would be connecting the application to the data.
    Reply With Quote Quote  

  12. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #11
    FYI

    Pre ordered the book for queries.

    Looking at upgrading from 2008 express to 2012
    Last edited by N2IT; 06-13-2012 at 01:15 PM.
    Reply With Quote Quote  

  13. Go ping yourself... phoeneous's Avatar
    Join Date
    Dec 2008
    Location
    Console.WriteLine("Yo");
    Posts
    2,316

    Certifications
    Pimp status
    #12
    FYI, building reports in SSRS is completely different than building them in Crystal. I have both apps that I use at work and I much prefer SSRS over Crystal. They have so many differences like syntax, modules, layout, etc..

    But 461 does look good, I might consider it sometime next year after CCNP.
    Reply With Quote Quote  

  14. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #13
    Yeah I went ahead and just ordered 2012 developer. I am hoping this has the reporting feature I am looking for. I can't wait to get SQL 2008 express off of my box.
    Reply With Quote Quote  

  15. Go ping yourself... phoeneous's Avatar
    Join Date
    Dec 2008
    Location
    Console.WriteLine("Yo");
    Posts
    2,316

    Certifications
    Pimp status
    #14
    Quote Originally Posted by N2IT View Post
    Yeah I went ahead and just ordered 2012 developer. I am hoping this has the reporting feature I am looking for. I can't wait to get SQL 2008 express off of my box.
    If it makes you feel any better, I just moved from 05 to 08
    Reply With Quote Quote  

  16. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #15
    How has the transition been going so far?
    Reply With Quote Quote  

  17. Senior Member
    Join Date
    Mar 2012
    Posts
    123
    #16
    If you wish to learn a real database, then the 1Z0-047 "Oracle Database SQL Expert" exam is perfect for you. It's for analysts or entry level developers.
    Reply With Quote Quote  

  18. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #17
    Thanks for the heads up crash! Appreciate the suggestion.
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks