Know the Syntax.
There are many programs that will help you in creating the syntax
for a query or other tasks. Even the EM will do some of this for you, such as permissions,
create table, and build indexes. Things will be much easier to do in the GUI. I must admit
I started by using the GUI, but I cant stand to use it now. If you know the syntax
you may be able to do it faster, and easier. The syntax has a pattern to it. Once you
learn a few statements the rest are easier to learn.
I do not like to use the EM. I like to use the keyboard, not the mouse. I have
problems navigating through all the GUIs that are in the EM. Creating tables is slow
with keyboard to mouse movement, while building indexes is the whole nine yards! Every
thing can be done much quicker if you dont use the GUI.
I am not saying never use the GUI. I have found that it can help me. For example, I am
new at this and I want to create a table. I am not to sure on how this create table syntax
works. First I would check BOL. If that doesnt clear up the confusion in my mind
then I would try the GUI . I can create the table in the GUI and name it as Junk. To learn
the syntax for all the data types I simply script out the table. This sounds repetitive.
Why script it out if I already have it? I found that I script it out then use that script
so I can see a good example of how the Create table works. I also get an example to GRANT
and BUILD INDEX. I dont recommend this over BOL, but in some cases, when I
cant find exactly what I am looking for, I improvise.
There are some tools that can help in learning the syntax. I use Embarcadero's
I like the way that the product color codes your SQL statements. I will soon be posting a
on DBArtisan. You can check out a trial version of DBArtisan
on their home page.