Reading the final words is really moving. So much suffering.
Show HN: Select Star SQL, an interactive SQL book
71–80 of 121 posts
Re: Show HN: Select Star SQL, an interactive SQL book
#72Genuinely enjoyed the book. A couple of notes:
1. In The Long Tail > Nested Queries, the first example contains the function LEN, which gives an error as LENGTH is expected.
2. On the questions with multiple answers, when showing hints, I would use different font colors for correct/incorrect statements as it will be easier to check your results.
Wonderful website!
Re: Show HN: Select Star SQL, an interactive SQL book
#73Glad to see that the Creative Commons license is used!
I used the MIT license for the interactive SQL tutorial I built ( https://www.sqlteaching.com/ )
Re: Show HN: Select Star SQL, an interactive SQL book
#74Why did you use death sentence cases as data? I've spent around 20 minutes just reading the last words of various executed people. It's... disturbing and distracting.
Why did you continue for 20 minutes if it disturbs you so much, little snow flake?
Re: Show HN: Select Star SQL, an interactive SQL book
#75I have picked up SQL and statements from my time in industry. I really like how this book provides not only interaction but a dataset that actually means something. Also, interactive systems like this for teaching are amazing! I learned about how "_" is a wildcard for one character (I have been making do with % for LIKE statements).
I only recently learned that LIKE also supports something vaguely similar to regex character classes:
SELECT * FROM customers
WHERE company_name LIKE 'foo[lt]'
SELECT * FROM customers
WHERE zipcode LIKE '12[^30]45'
Re: Show HN: Select Star SQL, an interactive SQL book
#76Why did you use death sentence cases as data? I've spent around 20 minutes just reading the last words of various executed people. It's... disturbing and distracting.
Why did you continue for 20 minutes if it disturbs you so much, little snow flake?
Why did you choose executions over something mundane like blogs or comments? Reading last statements isn't exactly something I want to be distracted by. The data is interesting sure and if this just happened to be based on something you did recently, I get it. It's not something I'd recommend to students doing data science or getting acquainted with SQL when there's less morbid source material out there. The interactivity provided is cool though, no doubt.
Re: Show HN: Select Star SQL, an interactive SQL book
#77Congratulations! I love this kind of interactive tutorials as their helping more and more people learning stuff without a boring book and no exercises. That said: Doesn't work in Firefox and Edge? Common, are we back in 1998? Sorry for the rant, but please don't do that.
It works pretty fine on FF. However, you have to enable `dom.webcomponents.customelements.enabled` manually...
Re: Show HN: Select Star SQL, an interactive SQL book
#78Why did you use death sentence cases as data? I've spent around 20 minutes just reading the last words of various executed people. It's... disturbing and distracting.
The reason is explained in the front matter: “On one level, the data is simply a part of a mundane programming book. On another, each row represents immense suffering, lives lost, and in some cases amazing redemption and acceptance. In preparing for this dataset, I was deeply moved by a number of the statements and found myself re-evaluting my position on capital punishment. I hope that as we examine the data, you too will contemplate the deeper issues at play.”
Re: Show HN: Select Star SQL, an interactive SQL book
#79I can only imagine how much work this must have been (and not very accurately, I think). I did not have time to look over it in great detail, but I like what I have seen.
Thank you for creating and sharing this!
Re: Show HN: Select Star SQL, an interactive SQL book
#80It’s a lovely product and you can tell a lot of work went into making this course. But I fail to understand the author’s logic behind “a good course has to be free”. Why though? What’s wrong with creating value (like The OP) and then extracting it from the people that benefit from it? In fact, there’s tons of anecdotal evidence that free MOOCS haven’t faired well in terms of retention precisely because of a lack of a…
Is it possible that value can be generated without a financial transaction?