datacarpentry
Objectives for the "Basic Queries" lesson do not match the content.
This is referring to the material in Episode 2 http://datacarpentry.org/sql-ecology-lesson/01-sql-basic-queries/index.html
Problem - For this chapter - Basic Queries, its objectives (including the title) do not match the content therein. There are some complex queries in the latter half of the lesson (in the section 'Building more complex queries') which can be intimidating for novice learners. Solution - It would be better to make a new chapter focused on these 'complex' queries. Also, useful to have a flowchart showing how the queries are built on top of each other. For example, SELECT and FROM are the most essential ones without which a query won't run, followed by WHERE, GROUP BY, HAVING, ORDER BY in that particular order. (a flow chart visualization would be even better and more engaging)
Hi @V-Sher! Thanks for the feedback.
I don't know how I feel about this. The queries are still "simple", in that they don't use subqueries, joins, aggregations, or unions, which are introduced later.
The lesson could use more episodes for sure, but I don't know if the title is such a bad match. If you want to take a crack at making such a flowchart, or some reorganization of episode 1, we will certainly consider it!
hi @remram44 , Thank you for your comment.
For me, the section heading "Building more complex queries" was a bit offputting. Until later I learned that it simply meant 'building more complex WHERE conditions' which, as you rightly said' is still part of basic queries. Having said that, I would still put those in new episodes to ease off information overload for a novice like myself.
The flowchart to introduce beginners to the sequence of sql commands would go something like this.
