SQL Training{4}

by Eric H
In this scholar journal it talks about SQL(Structured Query Language). SQL is what we use to retrieve information from databases. ANSI (American National Standard Institute) chose SQL as the standard language for accessing and manipulating relational database management system (Bodnar H, 2005). Some of the function of SQL statements are such as selecting data for a report, selecting data as an answer from a query, or updating data in a database (Bodnar H, 2005).

For those that want to learn about SQL, there are many resources available to the users. These resources fall into two categories. The first one is web sites that offer only text(Bodnar H, 2005). and the second category is web site that provide an interactive SQL processor that allows the user to actually run and test the SQL statements on the site to see the resulting output(Bodnar H, 2005).

Websites in the text only category usually provide lengthy, more detailed discussion of SQL statements than those sites that belongs in the interactive SQL processor category(Bodnar H, 2005). Some of the the text only sites even provide illustrate queries along with lengthy text. And in the article the author provided links to two excellent text-only sites, http://www.1keydata.com/sql/sql.html and http://philip.greenspun.com/sql/

And for the interactive processor websites, the author also provided links to such sites.
First one is http://sqlcourse.com/intro.html, this site is offered as a trial, and if the users wish to learn more than that free trial offer they can enroll in their for-fee training courses. The next two is free to use, http://www.w3schools.com/sql/default.asp, http://sqlzoo.net/

I find this article relates to this week’s lecture. In class we started learning about SQL statements, such as Select, Insert, From, Having, and etc. and in the article it talks about the how important SQL is for database, and it also points to sites where i can learn more about SQL statements. I feel combining and learning from both text-only site and interactive sites will help me learn SQL much easier.

Bodnar, G. H. (2005). An active X SQL resource. Journal of Information Systems Education, 16(4), 385-386. Retrieved from http://search.proquest.com/docview/200132678?accountid=10357