Books

Sams Teach Yourself SQL in 10 Minutes - Fourth Edition

  • ISBN: 0672336073
  • Pages: 276
  • Publisher: Sams - November 4, 2012

As much as I'd like to be able to produce completely error free books, the reality of the computer publishing industry is that the pace at which books must be written and released makes this very difficult. And regretfully, my own books do have sporadic mistakes and typos scattered throughout them.

For the benefit of my readers, here is a current errata for Sams Teach Yourself SQL in 10 Minutes - Fourth Edition. Feel free to print this page for future reference.

And as always, if you come across errors that I do not know about, please let me know. I'll make sure they are added to this list, and will try to have them corrected in future reprints.

Page 19

Location: Paragraph following the OUTPUT block: 14 rows
Error: Should be: 9 rows
Location: Paragraph following the OUTPUT block: 14 products
Error: Should be: 9 products

Page 20

Location: First paragraph, "only four rows"
Error: Should be: only three rows
Location: Caution block, words: "unless both"
Error: Should be: "because both"

Page 22

Location: Second ANALYSIS block, second sentance
Error: Should be: The first number is the number of rows to retrieve, and the second number is where to start.

Page 23

Location: TIP
Error: This TIP applies to SQLite as well
Location: Tip, second sentence
Error: Should be: "Using this syntax, the value before the , is the OFFSET and the value after the , is the LIMIT."

Page 24

Location: Second bullet, words "so that MariaDB"
Error: Should be: "so that the DBMS"

Page 41

Location: Second INPUT block, "FROM CUSTOMERS"
Error: Should be: FROM Customers

Page 56

Location: TIP, closing WHERE clause
Error: Should be: WHERE email LIKE 'b%@forta.com'

Page 58

Location: Note, first line: describes
Error: Should be: described

Page 79

Location: Input block at top of page, 2012 in WHERE clause.
Error: Should be: '2012'

Page 83

Location: Caution block.
Error: Add the following to the caution. "The exception to this is when returning a single value that is calculated from multiple columns, as will be explained later in this lesson."

Page 107

Location: INPUT block, middle SELECT statement: FROM Order
Error: Should be: FROM Orders

Page 111

Location: CAUTION block, 5th line, text "if you"
Error: Should be: if your

Page 131

Location: CAUTION block, first line, words LEFT OUT JOIN
Error: Should be: LEFT OUTER JOIN

Page 143

Location: NOTE block, first line
Error: Missing a . after word UNION

Page 205

Location: NOTE block, first line, words "does support"
Error: Should be: does not support

Page 210

Location: INPUT block
Error: ANALYSIS refers to a ... placeholder, but it is missing from the code snippet.

Page 215

Location: First INPUT block, line beginning vend_zip
Error: This line is missing its trailing , character

Page 221

Location: INPUT block: ON PRODUCTS
Error: Should be: ON Products

Page 241

Location: Using Oracle section, item 2, words "Before you can any"
Error: Should be: Before you can use any

Back to Book Information