sql-ecology-lesson icon indicating copy to clipboard operation
sql-ecology-lesson copied to clipboard

Objectives for the "Basic Queries" lesson do not match the content.

Open V-Sher opened this issue 6 years ago • 2 comments

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)

V-Sher avatar Oct 20 '18 18:10 V-Sher