Learning MySQL - INNER JOINs

preview_player
Показать описание
When you want to retrieve data with a SELECT statement and that data come from multiple tables then you should always be using an INNER JOIN.
This video covers some best practices for working with INNER JOINs.

  1. Steve Griffith - Prof3ssorSt3v3
  2. MAD9022
  3. web development
  4. mad9135
  5. mad9145
  6. mad9023
Рекомендации по теме
MySQL: JOINS are 0:05:04

MySQL: JOINS are easy (INNER, LEFT, RIGHT)

Learning MySQL - 0:10:18

Learning MySQL - INNER JOINs

MySQL Inner Join 0:03:26

MySQL Inner Join Tutorial | Beginner Tutorial with examples

Joins in MySQL 0:17:11

Joins in MySQL | Intermediate MySQL

12 MySQL Tutorial 0:06:38

12 MySQL Tutorial for Beginners: Inner Joins

SQL Inner, Left, 0:06:59

SQL Inner, Left, and Right Joins - MySQL Tutorial #5

MySQL Tutorial for 0:07:27

MySQL Tutorial for Beginners 35 - MySQL INNER JOIN

SQL JOINS Tutorial 0:35:23

SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 1

Tansy SQL Course 0:07:10

Tansy SQL Course UPDATE Chapter 6 Lesson 3

Intermediate SQL Tutorial 0:15:53

Intermediate SQL Tutorial | Inner/Outer Joins | Use Cases

SQL Joins Explained 0:10:26

SQL Joins Explained |¦| Joins in SQL |¦| SQL Tutorial

SQL INNER JOIN 0:02:54

SQL INNER JOIN Syntax Tutorial PHP MySQL Database

MYSQL Inner Join 0:09:03

MYSQL Inner Join Tutorial | MYSQL Joins Tutorial for Beginners

What are Joins 0:07:03

What are Joins in MySQL - Inner, Left, Right, Full

SQL Joins: Difference 0:10:52

SQL Joins: Difference Between Inner/Left/Right/Outer Joins

INNER JOIN in 0:06:54

INNER JOIN in SQL

Episode-029 - Using 0:02:40

Episode-029 - Using Inner Joins in MySQL

Working with MySQL 0:04:52

Working with MySQL and INNER JOIN

MySQL - INNER 0:05:37

MySQL - INNER JOIN, LEFT JOIN and RIGHT JOIN

32-How to Join 0:11:10

32-How to Join 3 or more tables in SQL | Join Multiple Tables | Using Inner Join | Interview Topic

Inner Join, Left 0:08:11

Inner Join, Left Join, Right Join and Full Outer Join in SQL Server | SQL Server Joins

Databases: MySQL Inner 0:07:04

Databases: MySQL Inner Join - Traditional method (Where clause)

Select statement with 0:04:31

Select statement with Inner joins left join right join in mysql

14 SQL Server 0:00:20

14 SQL Server - Inner Join in SQL Server

Комментарии
Автор

It is a real shame that this channel doesn't have many subscribers! You are very talented at explaining concepts, Steve. You are the first person I am going to search for if I have a question about JS or mySQL and probably many other things in the future.

Thanks a lot for your great content!

ShinjuiroX
Автор

Man I was so scared of these mysql joins.
I watched some video and the person was making them seem like so out of the world!
I just used your video to solve a work issue.
Thanks a lot man. May the heavens bless you!


I have subscribed and liked. Keep going

smiley
Автор

2 years later and this video still helps people! Thank you so much!!!

amyoshea
Автор

Very good lessons. Steve you've a talent!

bobaoustin
Автор

Whew. Thank you so much. Huge asset for people that don't have a mentor to break this stuff down.

HangingGarden
Автор

This SQL videos are excellent, forgot a ton and this is an excellent reminder, clear and straight to the point.

peloponeso
Автор

Steve is a great teacher I am always watching his videos to get quick info when I work in PHP and javascript

raspberry-digital
Автор

thank you for the explanation. It was very confusing before but now, clear as day

begadmorsi
Автор

You earned a sub. Well done. Quick and straight to the point.

hollengrhen
Автор

HI Steve, I loved your teaching style- very clear, simple to understand.
I have a question- Why is it not a good practice like you mentioned in the video above, to use 'WHERE' to call out the connectivity between the two tables?

jazzu
Автор

Thank you so much for explaining the concepts in a simple n clear manner.

rupisadhra
Автор

amazing video! you're super clear and easy to listen to! thanks!!

labochi
Автор

this is a very well made and informative lesson. Thanks

davidclark
Автор

Hello, first of all I would like to thank you for videos, secondly I would like to know whats the purpose of the "ON m.gener_id =g.gener_id" is it like the "where"?

marvindaisabel
Автор

Thank you very much. Very easy explained. :)

markusGone
Автор

You learning is awesome, Thanks very much

AhmedKhaled-hemf
Автор

Thanks very much, helped me out of a hole.

lonewolfhamradio
Автор

I did not quite get how exactly each movie was multiplied by every genre. You mentioned something about the "Square product" But I am not understanding it.

LucianoClassicalGuitar
Автор

I'm a bit late but I have a question,
I don't know if you made a video about this already, I don't even know what to look for, but if you wanted to see how many movies every genre has, how would that be done? so the result would be

horror | 8
romance | 0
science fiction | 2

etc.

Martin-kvth
Автор

Thanks a lot
great and clear explanation

shbita