T-SQL? Which keywords and clauses are necessary and not?

GoldmemberGoldmember Member Posts: 277
Going through the Beginning SQL 2005 book I have found quite a few clauses pertaining to the SELECT keyword which I think might be overkill for the MS exam.

So what do you think is unnecessary for the MS EXAM as far as keywords and clauses?

After going through the book there are many clauses which I think might be unnecessary for the exam, since most of the exam is going to be based on SQL Management Studio.


CCNA, A+. MCP(70-270. 70-290), Dell SoftSkills


  • BeaverC32BeaverC32 Member Posts: 671
    You will need to understand quite a bit of syntax to do well on the 70-431 exam. While it is true that the exam focuses on SSMS, you will need to understand T-SQL in order to answer many of the questions....especially in the simulation portion of the exam, which is 10+ questions.

    You don't need to be able to write elaborate queries, views, functions, etc. but you should be able to look at syntax and recognize what it does.
    MCSE 2003, MCSA 2003, LPIC-1, MCP, MCTS: Vista Config, MCTS: SQL Server 2005, CCNA, A+, Network+, Server+, Security+, Linux+, BSCS (Information Systems)
Sign In or Register to comment.