|
Home > Archive > SQL server exams > May 2002 > SQL Syntax
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| jmantheiy 2002-05-06, 3:13 pm |
| I was planning to take 70-229 today. I have been working with SQL 7.0 & 2000 for about 2 years now. But I have this great fear of the questions pertaining to SQL syntax. I feel comfortable with everything else, but if I have to choose between 4 different statements on which will perform the best, I fear I will bomb out. I have put off this exam for 2 weeks now, just because of that.
Does anyone have any advice? | |
|
| Yeah, read up on SQL :-)
Seriously, this exam is heavy on SQL code - you really need to be able to read and understand TSQL.
So, first of all, play around with SQL statements in the query analyzer. There are plenty of sites with TSQL tutorials, and BOL has plenty of info two.
Second, create an application for yourself (maybe your own version of a practice exam app?), and implement plenty of stored procedures.
Third, when you take the exam - if you have four possible answers, focus on the differencies between them. Once you've identified the differencies, it should be easy to eliminate at least one or two incorrect answers.
Hope this helps... |
|
|
|
|