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

N2ITN2IT Posts: 7,483Inactive Imported Users
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

Comments

  • ptilsenptilsen ■■■■■■■■■■ Posts: 2,835Member ■■■■■■■■■■
    MCSA: SQL Server 2012, especially the first exam, 70-461, are what you're really looking for from what I can tell.
    Working B.S., Computer Science
    Complete: 55/120 credits SPAN 201, LIT 100, ETHS 200, AP Lang, MATH 120, WRIT 231, ICS 140, MATH 215, ECON 202, ECON 201, ICS 141, MATH 210, LING 111, ICS 240
    In progress: CLEP US GOV,
    Next up: MATH 211, ECON 352, ICS 340
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    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!
  • aaronchristensonaaronchristenson ■■■■□□□□□□ Posts: 261Member ■■■■□□□□□□
    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
  • petedudepetedude Posts: 1,510Member
    I wonder if maybe getting certified in reporting tools would help in this instance, e.g. Crystal Reports certification.
    Even if you're on the right track, you'll get run over if you just sit there.
    --Will Rogers
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    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.
  • ptilsenptilsen ■■■■■■■■■■ Posts: 2,835Member ■■■■■■■■■■
    Aaron got the link to the correct test there. I inverted the 4 and 6 -- it's 461.
    Working B.S., Computer Science
    Complete: 55/120 credits SPAN 201, LIT 100, ETHS 200, AP Lang, MATH 120, WRIT 231, ICS 140, MATH 215, ECON 202, ECON 201, ICS 141, MATH 210, LING 111, ICS 240
    In progress: CLEP US GOV,
    Next up: MATH 211, ECON 352, ICS 340
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    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.
  • petedudepetedude Posts: 1,510Member
    N2IT wrote: »
    @ 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.
    Even if you're on the right track, you'll get run over if you just sit there.
    --Will Rogers
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    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.
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    FYI

    Pre ordered the book for queries.

    Looking at upgrading from 2008 express to 2012
  • phoeneousphoeneous Go ping yourself... Posts: 2,333Member ■■■■■■■□□□
    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.
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    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.
  • phoeneousphoeneous Go ping yourself... Posts: 2,333Member ■■■■■■■□□□
    N2IT wrote: »
    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 icon_sad.gif
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    How has the transition been going so far?
  • crashdumpcrashdump Posts: 134Banned
    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.
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    Thanks for the heads up crash! Appreciate the suggestion.
Sign In or Register to comment.