+ Reply to Thread
Results 1 to 15 of 15

Thread: Passed 70-451

  1. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    323

    Certifications
    A+,N+,OCA MySQL, ITIL-F (2012),MCTS: SQL 2008 DB Dev.
    #1

    Default Passed 70-451

    After constantly putting it off I finally bit the bullet and sat for the 70-451 SQL 2008 exam today and passed with score of 815. Exam was not as tricky as I feared - lot's of questions on transactions and locks\isolation levels and far less on XML than I expected.

    With this under my belt I am now an MCITP: SQL Database Developer

    Though I would like to sit the upgrade (457 and 457) exams for MCSA SQL 2012 I need to get PRINCE2 Foundations out of the way ASAP for work related purposes.....

    <TriesToSoundMysterious>watch the forum for upcoming updates hehehhee </TriesToSoundMysterious>
    Currently Pursuing:

    BSc Information Systems and Management (University of London International Programs)
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #2
    Congrats on the pass. I got my 2008 MCITP in DB Administration and looking back it would have served me well to go the developer route at the same time, instead of trying to learn it 3 years later.
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

  4. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    323

    Certifications
    A+,N+,OCA MySQL, ITIL-F (2012),MCTS: SQL 2008 DB Dev.
    #3
    Thanks. I do much more on the querying side than db admin so this seemed a good cert to pursue. At some point I'll have to look at getting my MCSA 2012 out of the way - seems this cert journey is never ending
    Currently Pursuing:

    BSc Information Systems and Management (University of London International Programs)
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #4
    Nice job! Well done!
    Reply With Quote Quote  

  6. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,380

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

  7. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    323

    Certifications
    A+,N+,OCA MySQL, ITIL-F (2012),MCTS: SQL 2008 DB Dev.
    #6
    Thanks guys....completely behind my schedule for 2014 certifications but really glad I finally did it.
    Currently Pursuing:

    BSc Information Systems and Management (University of London International Programs)
    Reply With Quote Quote  

  8. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #7
    I'm so far beyond I quit certifications LOL! I just don't have time anymore. I have 20 large scale exception reports to create that are very complex and a interactive dashboard (KPI's).

    After I am done with my managerial accounting refresher course and supply chain course (through work) I am going to hit ASP hard. Can't wait to get into Webmatrix!
    Reply With Quote Quote  

  9. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    323

    Certifications
    A+,N+,OCA MySQL, ITIL-F (2012),MCTS: SQL 2008 DB Dev.
    #8
    I think one shouldn't just certify for the sake of certifying......you seem to be learning a lot of stuff relevant to your role which, to me, is great
    Currently Pursuing:

    BSc Information Systems and Management (University of London International Programs)
    Reply With Quote Quote  

  10. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #9
    Both of us for sure are growing in the ways of data. My new favorite is SUM(Column) OVER ( PARTITION BY COLUMN) That with some CTE's or virtual tables really helps solve some of my metric dilemmas.
    Reply With Quote Quote  

  11. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    323

    Certifications
    A+,N+,OCA MySQL, ITIL-F (2012),MCTS: SQL 2008 DB Dev.
    #10
    I must admit I have a weak spot for CTEs. They have saved me creating a whole bunch of confusing temp tables on quite a few occasions....
    Currently Pursuing:

    BSc Information Systems and Management (University of London International Programs)
    Reply With Quote Quote  

  12. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #11
    I agree! I am starting to review cursors a lot more. Not sure how I feel about them yet. Thoughts?
    Reply With Quote Quote  

  13. ProEthicalHacker.com fuz1on's Avatar
    Join Date
    Dec 2014
    Location
    silicon valley, where we speak that bay area slang
    Posts
    938

    Certifications
    CCNA CCENT ITIL SSCA SSVVP WSQD WSQI Cloud+ Mobility+ Security+ Linux+ Network+ Server+ Project+ A+ HIT LPIC-1 CLA11 ACE ace/PACA SSBBP SSLP CMS SCP
    #12
    Congrats!
    Reply With Quote Quote  

  14. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    323

    Certifications
    A+,N+,OCA MySQL, ITIL-F (2012),MCTS: SQL 2008 DB Dev.
    #13
    @N2IT - I really don't like cursors. One of the guys at work rewrote a stored procedure we use for pulling up transaction histories and replaced cursors with set based logic; execution time during peak period literally down 60%
    Currently Pursuing:

    BSc Information Systems and Management (University of London International Programs)
    Reply With Quote Quote  

  15. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #14
    I'd like to see that execution plan. SQL, there is always a time and place.

    CTE large sets of data PUKE. Either way good information to know. Thanks!
    Reply With Quote Quote  

  16. Senior Member ccnpninja's Avatar
    Join Date
    Feb 2007
    Location
    Tunisia, North Africa
    Posts
    983

    Certifications
    a few
    #15
    Congrats
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks