issues
search
gvwilson
/
sql-tutorial
The Querynomicon: An Introduction to SQL for Wary Data Scientists
https://gvwilson.github.io/sql-tutorial/
Other
432
stars
43
forks
source link
issues
Newest
Newest
Most commented
Recently updated
Oldest
Least commented
Least recently updated
- Added makefile for generating .out files for psql
#50
kitsiosk
closed
4 months ago
0
question: one page or many?
#49
gvwilson
closed
4 months ago
6
rewrite Makefile to reflect restructuring
#48
gvwilson
closed
4 months ago
0
Added instructions on how to setup PostgreSQL in macOS
#47
kitsiosk
closed
4 months ago
3
Missing content
#46
kejcao
closed
6 months ago
0
Interactive code examples
#45
nalgeon
closed
6 months ago
2
Clarify table names
#44
zkdan
closed
6 months ago
0
Clarifying admin commands
#43
zkdan
closed
6 months ago
0
Adding quit command for sqlite
#42
zkdan
closed
6 months ago
0
changing data to db
#41
zkdan
closed
6 months ago
1
Change data to db
#40
zkdan
closed
6 months ago
0
addressed issues 36, 37, 38
#39
2x2xplz
closed
6 months ago
1
progress might be miscalculated?
#38
2x2xplz
closed
6 months ago
0
generated series too short
#37
2x2xplz
closed
6 months ago
1
unspecified null handling
#36
2x2xplz
closed
6 months ago
1
53. Intersection
#35
KipperBush
closed
6 months ago
1
Fix Typo in Update Rows (row(w) -> row(s))
#34
conor-f
closed
6 months ago
2
Show ibis-framework example
#33
cpcloud
closed
6 months ago
3
Example 22 arbitrary choice in aggregation is very specific to sqlite
#32
cpcloud
closed
6 months ago
1
Example 31 statement about full outer joins being the same as cross joins is incorrect
#31
cpcloud
closed
6 months ago
0
blob section is missing the SELECT query
#30
simonw
closed
6 months ago
2
docs: typo
#29
dpprdan
closed
6 months ago
0
introduce & utilize duckdb
#28
jenna-jordan
opened
6 months ago
7
Removing primary key from 040
#27
defuneste
closed
6 months ago
3
count distinct
#26
Hasnabruzzn
closed
6 months ago
3
feat: configure sqlfluff to check SQL code samples
#25
gvwilson
closed
6 months ago
0
feat: add GIS examples in appendix
#24
gvwilson
opened
6 months ago
0
fix: improve keyword detection
#23
gvwilson
closed
4 months ago
0
feat: explain .command data import from CSV
#22
APHawkes
closed
6 months ago
2
feat: replace use of head with custom script to add ellipses
#21
gvwilson
closed
6 months ago
0
feat: create downloadable starting point
#20
gvwilson
closed
6 months ago
0
feat: show examples of permissions in PostgreSQL
#19
gvwilson
closed
4 months ago
1
feat: explain difference between database and database manager
#18
gvwilson
closed
6 months ago
0
reconcile missing/unexpected SQL scripts
#17
gvwilson
closed
6 months ago
0
feat: use file inclusions + Makefile to regenerate/check examples
#16
gvwilson
closed
6 months ago
0
refactor: move scripts into subsidiary files
#15
gvwilson
closed
6 months ago
0
feat: example of calculating weighted quantiles
#14
zaneselvans
opened
7 months ago
0
feedback: add SQL best practices
#13
MSlobody
closed
3 months ago
0
feat: creating and using indexes
#12
gvwilson
closed
6 months ago
0
feat: explain upsert
#11
gvwilson
closed
6 months ago
0
feat: use "explain query plan" instead of "explain"
#10
SamHames
closed
7 months ago
1
feat: explain aliases can be used for tables
#9
gvwilson
closed
6 months ago
0
feat: explain different possible behaviors of count()
#8
gvwilson
closed
6 months ago
0
feat: apply condition to update and delete
#7
gvwilson
closed
6 months ago
0
feat: confusing aliases for table in comparison of individual and aggregate values
#6
gvwilson
closed
6 months ago
0
feat: autoincrement and primary key does not prevent person being duplicated
#5
gvwilson
closed
6 months ago
0
refactor: cover inner and outer joins before cross join
#4
gvwilson
closed
6 months ago
1
feat: modify query to show paging more clearly
#3
gvwilson
closed
6 months ago
0
Fix typo typo
#2
rkern
closed
7 months ago
0
feat: add ways to interact with the database from tidyverse / pandas / polars
#1
tomsing1
closed
7 months ago
0
Next