SQL query writing
-
I teach computer classes at a State Penitentiary and have a student that has been doing some great programming. He has been learning SQL Server, VB.net and database design and development. He gets out in one year and looking for some direction for his final year of study and does not have access to the internet. His question is:
"Has the skill of writing SQL queries by hand become virtually unneeded because of GUI query builders?"
I know this might be an odd question to be asking here but I have not found anywhere else to post and not found any info regarding his question. Thanks for the help.
-
The need for this skill will always be there. GUI build queries tend to have to much overhead in some cases and if you know how to write the queries you can also use this skill to analyse them in case of performance issues.
I also think that GUI builders don't have enouph functionality to create complex queries. I've seen a lot of SQL developers and none of them ever said to me that they preferred a GUI builder.
-
I think that skill of writing queries is always going to be important by hand, However for simple CRUD procedures (INSERTS, UPDATES, DELETES) we generate all our code. This is not to say that we do not know how to write this code, it simply speeds up our development time when we can point a tool to our databae and it will generate uniform simple code for all the tables.
Anything that requires more complex SQL we will write from scratch.
fyi. the application we use to generate our CRUD procs is;
http://www.mygenerationsoftware.com/portal/default.aspx"> http://www.mygenerationsoftware.com/portal/default.aspx
It is free and supports a wide number of databases.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply