SQL: Back to the Basics

by Evin C
This week I have ventured into a peer-reviewed article by Craig S Mullins who speaks on how users can hinder performance of applications through the use of inefficient SQL commands. From the proper way to use SELECT or even the command WHERE, this article shows users how they can make simple query mistakes by misusing these SQL commands. One of the major inefficiencies found with users and their work in DBMS software is the unnecessary queries performed and the scope of the queries, whether it be adding to many columns or not refining your search enough. The article continues to speak on the simple ways one can get around these simple mistakes and make their SQL even better.

Considering our work in class is revolving around SQL and the use of it, I found this article to be quite interesting. Although it wasn’t as detailed as I had hoped for it definitely gave me some oversight to how to structure my commands for the future. With Project 2 on the way, I figure we all will be looking for ways to better improve our code and relations. Using this article or any of the others throughout our classes blog site can hopefully improve our chances at doing well.

Couldn’t hurt!

Reference:

Mullins, C. S. (2010, December). Sql performance basics. Retrieved from http://web.ebscohost.com/ehost/detail?sid=d7577d59-e873-4cbf-8880-13a53cd970a7@sessionmgr115&vid=3&hid=19&bdata=JnNpdGU9ZWhvc3QtbGl2ZQ==

3 thoughts on “SQL: Back to the Basics”

  1. It looks like a very interesting article to look at. If not for the information, then for the fact that it would make our lives easier learning it for the ease of use if nothing else.

  2. Seems like using SQL isn’t that hard after reading all these articles about it. I guess we just have to make sure that we understand the general concept and how to retrive and organize data. Good article!

  3. Learn from the basic concept and then build up the knowledge of SQL. This article gives readers a very easy concept to understand the SQL basic stuffs. Thanks

Comments are closed.