SQL Crash Course

by Kevin S
This week I decided to read the article “SQL language crash course(just enough to be dangerous)”. The author covers things such as SELECT, FROM, WHERE, INSERT, UPDATE, DELETE, and several others. He ties each of these in with short examples and explanations of their implementations. These keywords work in all versions of SQL Servers and are important to know.

I chose this article since we are starting to learn about SQL and are going to have to start using it. Since I am unfamiliar with this language and I am very much a visual learner, simple examples like these are important. Especially for those pesky quotes and commas which will surely cause some errors when incorrectly placed.

The author covers the basics well and gives good examples. I do wish he would have gone into a few more things such as what the “*” and “|” imply in the examples he used. But from what I can tell after reading this, SQL is a lot like programming.

Jones, D. (2009, September). [Web log message]. Retrieved from http://searchsqlserver.techtarget.com/tip/SQL-language-crash-course-just-enough-to-be-dangerous?track=sy41

One thought on “SQL Crash Course

  • November 10, 2012 at 9:05 am
    Permalink

    Great post. SELECT, FROM, WHERE, INSERT, UPDATE, DELETE are basic SQL commands. The SELECT statement is probably the most common one we use for this course. SELECT is used to query the database and retrieve selected data that match the specific criteria that you specify. It’s often used with FROM (table name), WHERE (condition), and ORDER BY clause.

Comments are closed.