SQL-resources

Resources to learn SQL

intro

Lecture shamelessly plagiarized from...
http://www.math.ucla.edu/~virtanen/40a.1.15s/schedule/lec21.pdf
miageprojet2.unice.fr/@api/deki/files/1830/=Intro_to_MySQL.ppt
With minor edits
Lukas wrote last slide: very useful links to explain “JOIN”.
Murach’s MySQL textbook & MySQL Workbench good for learning https://www.murach.com/shop/murach-s-mysql-detail

JOINs

Don’t trust Venn diagrams of JOINs. Better explanations:
https://blog.jooq.org/2016/07/05/say-no-to-venn-diagrams-when-explaining-joins/ http://datavirtualizer.com/sql-joins-visualized-in-a-surprising-way/