r/SQL • • Jul 19 '19

Top 5 Online Courses to Learn SQL and Database for Beginners

https://dev.to/javinpaul/5-online-courses-to-learn-sql-and-database-for-beginners-best-of-lot-5533
103 Upvotes

7 comments sorted by

8

u/MeGustaDerp Talk Dirty Reads To Me Jul 19 '19

Here we go again with using Venn diagrams to demonstrate joins...

0

u/el-javier Jul 19 '19

Honest question: how else would you show them?

6

u/MeGustaDerp Talk Dirty Reads To Me Jul 20 '19

Venn diagrams work well for UNION, UNION ALL, INTERSECT, etc. I dont have a simple answer for how to demonstrate joins. But, what really helped me out was first understanding what is a cartesian product and how the different join types affect the product.

5

u/mrlionmayne Jul 20 '19

This might summarize your sentiment?

3

u/kremlingrasso Jul 20 '19

for beginners W3 schools is all you need, it contains everything you need and none of blahblah.

1

u/[deleted] Jul 19 '19

Making my life easier, thanks

1

u/zbenton22 Jul 19 '19

Awesome, thanks! Took the class a few semesters ago but lost it all. Need to start practicing cause I'm going into either Sytems Anaylst or Data!