Errata for Sams Teach Yourself SQL in 10 Minutes (Fifth Edition)
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 (Fifth 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 (306 pages, published December 20, 2019)
| Page | Location | Correction |
|---|---|---|
| 31 | 1st challenge: (cust_names) | Should be: (cust_name) |
| 43 | Output block | Should include column prod_id |
| 53 | Tip, 'LIKE b%@forta.com' | Should be: LIKE 'b%@forta.com' |
| 72 | Table 8.2, Function column, first entry | Missing closing ) |
| 78 | Challenge 1, text “customer name (customer_name)” | Should be: customer name (cust_name) |
| 88 | Challenge 2, text "of product item(prod_item)" | Should be: of products with an id (prod_id) |
| 106 | Challenge 3, final words "from Customers" | Should be: from Orders |
| 129 | Second INPUT block | Should be: SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state IN ('IL','IN','MI') OR cust_name='Fun4All'; |