sql-novice-survey
sql-novice-survey copied to clipboard
swcarpentry
Databases and SQL
07-join.md had a typo in one of the commands that yielded the wrong output 09-create.md had some clunky language that I re-wrote. Also, the bash command wasn't clearly labeled as...
This PR identifies what appears to be an error in Chapter 7 of the SQL Novice Lesson. As written, the two JOIN examples were identical. The first one should be...
There is a nice diagram in http://www.datacarpentry.org/R-ecology-lesson/02-starting-with-data.html showing a dataframe. In http://swcarpentry.github.io/sql-novice-survey/01-select/ a similar schematic diagram might help students to "Explain the difference between [a database,] a table, a record,...
The removes a small oversight in the current explanation, that columns with NULL values are not counted. It also teases the fuller explanation of NULL and aggregation that comes later....
The [opening page of the Databases and SQL lesson](http://swcarpentry.github.io/sql-novice-survey/) lists the option for using [DB Browser for SQLite](https://sqlitebrowser.org/). However, to my knowledge, none of the subsequent content provides instructions on...
A couple of changes to bring this chapter in line with R {DBI} best practices: * Updated text to reflect use of DBI package as uniform API for DB's from...
In episode 6 it is implied in the paragraph about count() that you would get the same result whatever field you counted, i.e. count(*) is the same as count(quant) is...
In Episode 4 "Calculating New values" the exercise "Major Site Identifiers" could be improved by a brief example of what substr() and instr() do as there has been no previous...
SQL's set-based syntax is different for those who have only been exposed to iterative programming languages, particularly those reading and writing to delimited text files. SQL creates more concise, self-describing...
Is there interest in adding [Binder ](https://mybinder.org) buttons to the README? I have already added a Binder button to the [Software Carpentry Python lesson](https://github.com/swcarpentry/python-novice-gapminder) and am [in the progress](https://github.com/swcarpentry/r-novice-gapminder/pull/532) of...
