41–50 of 121 posts
Earlier quoted context omitted.
https://selectstarsql.com/frontmatter.html Scroll down to Dataset. After "I’ve prepared for this book:" There is a little interactive code editor you can type in and run the query.
I was confused too. It appears the page does not work on Firefox. I get a "customElements is not defined" error in the console in Firefox and none of the interactive sections render. The page works fine on Chrome.
Earlier quoted context omitted.
Tbh I usually see teachers worried about joins but its the group by/having clauses that I always watched people struggle with (at least, writing it). Ofc that might just be the emphasis on joins makes group by the next lowest hanging fruit
What do your abbreviations mean?
Urban Dictionary (https://www.urbandictionary.com) or even just typing something like "what does tbh mean?" into your preferred search engine will often help you find likely interpretations of unknown abbreviations, in my experience.
Sorry for being dense, or maybe there are pop ups that I'm not seeing? I'm missing how is this "interactive". Sorry
Slightly embarrassing -- but the problem may be that the site isn't compatible with FireFox (at least pre-v63 FireFox). The site makes use of custom HTML elements which are not supported by default in pre-v63 FireFox ( https://developer.mozilla.org/en-US/docs/Web/Web_Components/... ). The good news is that all you need to do is to turn on a flag as set forth in the link provided. The bad news is that many other less…
Earlier quoted context omitted.
What do your abbreviations mean?
tbh = to be honest, ofc = of course Urban Dictionary ( https://www.urbandictionary.com ) or even just typing something like "what does tbh mean?" into your preferred search engine will often help you find likely interpretations of unknown abbreviations, in my experience.
I mean, that's what they did.
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 buy-in from the people taking those courses.
This is good intiative. We need to simplify pedagogy. On a related note, I always found the syntax of SQL to be great. Someone told me that simplicity of SQL made relational databases even more popular. It is one of the best designed language where even someone new to the field won't feel intimidated. I'm surprised designers of SQL haven't won the Turing Award yet.
I teach SQL to financial people and, for the most part, it isn't too bad. When I get to joins, I teach a subset of SQL where all joins are done through INNER JOIN / LEFT JOIN syntax and that helps a lot. Joins are the part that everyone has trouble with.
Nice job, this is a great way to teach something like SQL. Any plans to add more chapters? Would love to see something around window functions AND CTEs as this format would go a long way in showing when and how to use them.
I also discovered the ability to select from multiple tables and do joins using where clauses instead, which to me is a lot more intuitive than explicit/imperative join statements. I didn’t see anything covering queries like those (maybe because there’s only one table in the dataset, idk i’m on mobile).
"Now you have the tools you need to complete our project."
Where is this quiz and this project? Am I missing something?
This is good intiative. We need to simplify pedagogy. On a related note, I always found the syntax of SQL to be great. Someone told me that simplicity of SQL made relational databases even more popular. It is one of the best designed language where even someone new to the field won't feel intimidated. I'm surprised designers of SQL haven't won the Turing Award yet.
Codd wrote a couple of query languages before, but they apparently weren't usable by mere mortals.
SQL is over 40 years old, and still dominates. The most recent contenders had to position themselves in terms of SQL (NoSQL).
Earlier quoted context omitted.
Slightly embarrassing -- but the problem may be that the site isn't compatible with FireFox (at least pre-v63 FireFox). The site makes use of custom HTML elements which are not supported by default in pre-v63 FireFox ( https://developer.mozilla.org/en-US/docs/Web/Web_Components/... ). The good news is that all you need to do is to turn on a flag as set forth in the link provided. The bad news is that many other less…
It's 2018 and we're back in 1998 where website proudly showed "Optimized for Internet Explorer".