Using SQL in Database{5}


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