oreilly_getting_started_with_sql
oreilly_getting_started_with_sql copied to clipboard
Database files for the O'Reilly book "Getting Started with SQL: A hands on approach for beginners" http://goo.gl/z3zG54
After installing sqlite studio and downloading the sample databases, I try to open any of them as illustrated on page 13. They all return the error messages such as could...
Kk @ > `  `
Small nit: the book recommends setting the default value of ATTENDEE's VIP column to `0` but the sample database sets it to `1`.
The Slide for Exercise 4.1 is repeated twice in the file sqlfundamentalslides.pdf. (pg 37 & 38)
On page 51 the author introduces an example of _COALESCE()_ function. But it doesn't work. I mean, there are still NULL fields. Here is the statement: SELECT * FROM station_data...