We Learn SQL #3 | SQL JOIN Basics

Find out what SQL JOINs are and what they can do for you in your daily work with databases.
If you want to learn or practice SQL, check out learnsql.com/.
It’s another video in the series about SQL. In previous episodes, we talked about what SQL and databases are. Now it's time for querying more than one table using SQL JOINs. This video assumes that you can already write simple SQL queries. All good? Then let’s get started!
👌 Subscribe to our channel and leave a comment!
👌 Join us on Facebook: / welearnsql
🔊 Music: www.bensound.com/

[@Tonkoo]

Now this is what i call a banger video, short to the point and clear visuals to show what is happening +1

[@MarioCapurso]

This book could help ... Data Science and Engineering - A learning path - Volume 4 Relational and non-relational databases and SQL: with applications in MySQL, SQLite and Orange Data Mining

[@liliia9995]

The presentation and layout are thought to the smallest detail - content, colours, pictures, music. Everything looks very professional. Thanks for creating this course. I really enjoy it!

[@argonaut119]

Turn off the music. It detracts from your instruction -- or let the viewer choose whether to have the same repeating tune play or not play. Bad choice on the video production. Remove or greatly lower the volume of this background track. Not possible to get through more than 2 or 3 of your videos.

[@aamnasayyed]

I agree

[@anilarkay]

Just wanted to get a brush up on some SQL topics, and your video was really helpful. But please, please do not put music on such a lecture video. It is really disturbing the purpose of the instructor, most of the words were not audible.

[@user-hm7xe5xt9l]

An awesome tutorial! Thanks a lot for your commitment: D

[@humane123]

It was a good video but it could have been long and included the concept of how to avoid columns of same name in both the tables and that we can use column names without table name if there are different names of columns.

[@simplemente_humano]

very good videos!

[@phiphongnguyen3352]

thank you verry much

[@DaPashtoSazAwaz]

Your videos are great. Not sure why included this background music. You just ruined your efforts.

[@maryannemuthoninduhiu4331]

When providing the matching columns does the order matter?

[@0wnSecret]

(This course is very technical to listen in english (because i'm french) it looks very interesting but really the music in the background is really disturbing .. i can't listen)

[@diogobueno176]

Great Video! Thanks. Could you tell me the difference between use the "join" and make a Query like: Select x, y From TableX, TableY Where TableX.X=TableY.X

[@jeffreycounts]

That will have the same result as using the join.

[@diraneserges6076]

Great but i have question , i would like to retrieve the name of person in Table Person who hast the maximum age and minimum age using the group by ? please how i can do it

[@tyronefrielinghaus3467]

AARGH.......whats with the super intrusive music? overshadows what you're saying. NOt watching anymore.