Tuesday, October 29, 2013

SQL Guide Chapter 4

Chapter 4 deals with SQL Commands like
  • Search Statements:
    • Wild Cards allow a user to search for data that starts or end with a certain character (%n or _t)
    • Comparisons like less than or equal to (x>=y, x=y, x<>y means not equal to)
  • Input and Retrieve Data:
    • "Insert" obviously inserts data
    • "Select" chooses a column
    •  "Where" can be used to specify certain data (WHERE x=y)
    • "From" can be used to specify a table
    • "And", "Or", "Between", and "Not" can be used to make more complex statements with more restrictions
I still don't understand some things so I will probably have to review some of the book because I think it was fairly simple and then it got a bit complex quickly.

1 comment:

  1. That's what happens. Simple, elegant, and powerful ideas quickly become very difficult to wrap your head around as complexity of implementation grows. I think that's where the expression, "the devil is in the details" comes from ;-)

    ReplyDelete