Using SQL in Database

by Penny P
This article discusses how Structured Query Language (SQL) is used for databases. Within the database, there are tables where the information or data are being stored. With the use of SQL, it allows users to manipulate the tables, which in turn, could manipulate the data. SQL has been established by the American National Standards Institute (ANSI) to be the standard language to access and manipulate database because of its “non-procedural programming language” (Bodnar). Some basics of SQL include four statement types: Select (retrieve rows), Update (modify rows), Delete (remove rows), and Insert (add new rows). There are also internet resources available to those who want to learn more about SQL. These resources commonly fall into two categories: text only sites or interactive sites that actually let the user run the SQL statement and see the result. SQL has become a standard tool for working with databases and it has become an important part of auditing information systems. With SQL, auditors have the ability “to retrieve and process client data” (Bodnar) and use it during their audit. Knowledge of SQL is very attractive for companies looking for people to hire as auditors.

I think this article was interesting because it gives some information about how SQL is used for databases. Being an English Major and Minoring in CIS, my knowledge of database is not up to par with others. But after reading this article, I feel I learned a little bit more about what SQL is.

In addition, I also liked the part where the authors mentioned that there are internet resources out there that can help people learn more about SQL. The interactive site sounds really interesting. I’m definitely looking forward to learn more in this class.

 

Reference:

Bodnar, G. (2004). SQL: An Internal Audit Technology. Internal Auditing. V. 19 (Jan/Feb 2004) P. 34-38. Retrieved from http://0-search.proquest.com.opac.library.csupomona.edu/docview/214189497?accountid=10357

5 thoughts on “Using SQL in Database”

  1. Hi Penny thanks for your reply to my blog. I didn’t know that SQL could be used in auditting but after reading your blog I can see why or how that would make sense to use SQL. I too am very interested in those sites that are interactive and allow users to run there SQL statements. Hopefully SQL won’t be as specific as Java, for example when messing up on one single line of code or a variable is misspelled the program won’t work. But aside from that I do look foward to working with this new language and learning what databases have to offer.

  2. This was a very interesting article Penny. Last quarter, I was introduced to SQL in CIS 304 and it was interesting to see how this query language could be used to manipulate the data. I am also minoring in CIS and I’m excited to know that there are internet sources available for those who want to learn more about SQL. As far as auditing, I can agree with Antonio about how using using SQL would make sense. Auditors can perform their duties more efficiently by using SQL because it would only make sense that the retrieval and processing time of data is quicker, allowing the auditors to spend more time on their audit.

  3. Great article. I am also new to database and I found your article good for a quick intro into what SQL and somethings we can do with it. Did you happen to find those internet resources that help people learn more about SQL?

  4. I agree that SQL has become a very integral part of certain business aspects of a job. I think it is a skill, but must be learned with hard work and hard work pays off in the end. I’ve had some experience with databases, but to know that it is used in auditing is a big plus to know because it’ll be a great heads up in the job market. For SQL to be a standard, it must mean that this class will only help us in the future.

  5. Willen, the author listed these three interactive sites in his article: Jupitermedia Corporation’s “Interactive Online SQL Training” at http://sqlcourse.com, Refsnes Data’s WSSchools “SQL Tutorial” at http://www. w3schools.com/sql, and Andrew Cumming’s “A Gentle Introduction to SQL” at http://sqlzoo.net. Hopefully they can help us as we learn about databases 🙂

Comments are closed.