HOME / Posts Tagged: SQL
SQL joins explained as Venn diagrams
A handy illustration explaining how left and right joins work in SQL, presented as Venn diagrams. For some examples with actual data, check also this article by Jeff Atwood h/t Ilya Grigorik, Data Visualization (on G+)
Free eBook: Introduction to SQL
// If you are new to programming and looking for a way to start learning about databases, here is a free #eBook on #SQL by Rahul Batra Contents1) An Introduction to SQL2) Getting your Database ready3) Constraints4) Operations on Tables5) Writing Basic Queries6) Manipulating Data7) Organizing your Data8) Doing more with Queries9) Aggregation and Grouping10) Understanding [Continue reading]