SQL Knowledge{1}


by Jasmine C
My article was about how auditors can use SQL and also just some basic fundamentals statements that users should know. For auditors, SQL contains all the features that they will ever need to work with a database.  Basic statements allow for auditors to easily gather and process data relevant to their needs and display it in a way that is appropriate for their purpose.  As we all know, the basic statements of SQL are SELECT, INSERT, DELETE, and UPDATE.  The article discusses the need for each of these statements and also provides a few examples of how they are each used.  SELECT is the first statement with the purpose of extracting data.  Within the SELECT statement, you can have specific commands or functions that you will like to use to to manipulate your data.  For example, you can use the ORDER BY command to sort the data, you can use string functions to perform string expressions, and you can also use arithmetic expressions in a SELECT statement.  With the other statements, UPDATE, DELETE and INSERT, their purpose is to modify a database.  The other good thing about this article was that it listed some sites where people could go to learn more about SQL.  Some of the sites will even allow you to run statements and see the results.

This article helps a lot because it is very informative.  I would advise to anyone who would like to learn more about SQL to visit this site because it provides you with the majority of information that you will need to start using SQL. The list of free online sites at the end of the article is also a big help.   This is a great reference for the class to use.  As far as auditors are concerned, it only makes sense that they will be able to benefit from this type of database.  Their job is made so much easier because they do not have to search everywhere for their required information.  All they have to do is create a few queries and all their answers should be answered in a timely fashion.

 

Bodnar, G. (2004). Sql: An internal audit technology. Internal Auditing,19(1), 34-38. Retrieved February 17, 2012, from http://search.proquest.com/docview/214189497/fulltextPDF?source=fedsrch&accountid=10357#