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.
Original printing (276 pages, published November 4, 2012)
Page | Location | Correction |
---|---|---|
19 | Paragraph following the OUTPUT block: 14 rows | Should be: 9 rows |
19 | Paragraph following the OUTPUT block: 14 products | Should be: 9 products |
20 | First paragraph, “only four rows” | Should be: only three rows |
20 | Caution block, words: “unless both” | Should be: “because both” |
22 | Second ANALYSIS block, second sentance | Should be: The first number is the number of rows to retrieve, and the second number is where to start. |
23 | TIP | This TIP applies to SQLite as well |
23 | Tip, second sentence | Should be: “Using this syntax, the value before the , is the OFFSET and the value after the , is the LIMIT.” |
23 | Bullet at bottom of page, “SQL statement grow” | Should be: SQL statements grow |
24 | First bullet, “at the top of SQL file” | Should be “at the top of the SQL file” |
24 | First paragraph after bullets, “We’ll Start” | Should be: We’ll start |
24 | Second bullet, words “so that MariaDB” | Should be: “so that the DBMS” |
41 | Second INPUT block, “FROM CUSTOMERS” | Should be: FROM Customers |
56 | TIP, closing WHERE clause | Should be: WHERE email LIKE ‘b%@forta.com’ |
58 | Note, first line: describes | Should be: described |
62 | Final paragraph, “The reports wants” | Should be: The report wants |
63 | First paragraph, “the three columns” | Should be: the two columns |
64 | Third bullet, “state stored” | Should be: country stored |
79 | Input block at top of page, 2012 in WHERE clause. | Should be: ‘2012’ |
83 | Caution block. | 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.” |
107 | INPUT block, middle SELECT statement: FROM Order | Should be: FROM Orders |
109 | Paragraph beginning, “The WHERE clause”, words “column names, instead of” | Should be: column names; instead of |
111 | CAUTION block, 5th line, text “if you” | Should be: if your |
120 | First paragraph, “as the preceding example” | Should be: as an earlier example |
126 | Paragraph beginning “So far”, “You’ll Now take a look at” | Should be: You’ll now look at |
127 | Analysis section, last line: “Subqeries” | Should be: Subqueries |
131 | CAUTION block, first line, words LEFT OUT JOIN | Should be: LEFT OUTER JOIN |
143 | NOTE block, first line | Missing a . after word UNION |
164 | First paragraph, third line. “that You” | Should be: that you |
183 | Note, “was a rather” | Should be: is rather |
199 | Last paragraph, “what transactions processing is” | Should be: what transaction processing is |
201 | First paragraph, last line, “undo then” | Should be: undo them |
205 | NOTE block, first line, words “does support” | Should be: does not support |
210 | INPUT block | ANALYSIS refers to a … placeholder, but it is missing from the code snippet. |
215 | First INPUT block, line beginning vend_zip | This line is missing its trailing , character |
221 | INPUT block: ON PRODUCTS | Should be: ON Products |
230 | Paragraph beginning “The SQL statements”, words “these file” | Should be: these files |
235 | Step 2, “available database” | Should be: available databases |
241 | “Using Oracle” step 1, “using provided” | Should be: using the provided |
241 | Using Oracle section, item 2, words “Before you can any” | Should be: Before you can use any |
242 | Using Oracle Express Step 4, “enter and text SQL” | Should be: enter any SQL text |
254 | Paragraph beginning “Fixed length”, words “padded with spaces or nulls” | Should be: padded with spaces |
263 | TAPE | Should be: TYPE |