Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SQL DDL & DML RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    I am now taking the MCAS Access 2007 exam. I have database design (diagramming) training and experience. The last couple interviews people ask me about my SQL statement skills. Most of the time I use SQL with studio management express or within other internal applications for queries. I have no SQL "server" experience yet. I have taken two SQL query courses on campus.

    Are there any certifications or reputable tests to demonstrate my SQL DDL & DML skills?

    What would be a good training course for the next level as a DBA? I really enjoy the problem solving tasks of taking requirements and business rules to create an efficient database design.

    Any comments would be appreciated.

    Tina Maria

    Wednesday, August 4, 2010 2:38 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    There are a few SQl Server Exams.

    I took the 70-433 SQL Server 2008, Database Developer exam and it covered all the DDL & DML stuff (And other topics also of course).

    When studying for that exam, I used the Self-Paced Training Kit, but my skills wasn't good enough when I started it, so I used another book to get some stuff with more details. (I used "Inside Microsoft SQL Server 2008: T-SQL Programming" from MSPress as 2nd book)

    But maybe you want to look at the different available SQL Server Exams at
    http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab2

    With kind regards,

    Konrad

    • Proposed as answer by Andrey Korshikov Wednesday, August 4, 2010 5:19 PM
    • Marked as answer by Rubel Khan Sunday, August 15, 2010 8:24 PM
    Wednesday, August 4, 2010 3:03 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote
    I'd definitely look at going for the MCITP level,
     
     
    SQL Server 2008 is the newest, but SQL Server 2005 is also still widely
    used.
     
    -- Mike Burr
    • Marked as answer by Rubel Khan Sunday, August 15, 2010 8:24 PM
    Wednesday, August 4, 2010 9:18 PM

All replies