Tutorial 8- Discussing All Types Of Joins -MySQL Complete Playlist

  Рет қаралды 28,018

Krish Naik

Krish Naik

Күн бұрын

Пікірлер
@krishnajipandey6587
@krishnajipandey6587 3 жыл бұрын
Dear Sir Thanks sir. Please complete this series as soon as possible. Your way of teaching is awesome. Please add any project or uses of MySql in real world. Please give an example of real world
@kommabalaji4845
@kommabalaji4845 3 жыл бұрын
Sir kindly give more priority to this MySQL playlist sir, Sir kindly complete this Playlist as soon as possible
@mominizhar6760
@mominizhar6760 3 жыл бұрын
Great....
@sttauras
@sttauras 3 жыл бұрын
Thank you for the video :)
@rajbir_singh0517
@rajbir_singh0517 3 жыл бұрын
Natural join , joins data based on common Cols in both tables
@perumalbalachandranjj2358
@perumalbalachandranjj2358 2 жыл бұрын
Inner join and natural join both are same result, but natural join keep only one copy of each common column whereas Inner Join both the tables including duplicate columns also
@kranthikumarnagothu3056
@kranthikumarnagothu3056 3 жыл бұрын
By using subqueries concept, we can join multiple tables with the help of joins.
@narayanbabubharali9846
@narayanbabubharali9846 3 жыл бұрын
Nice
@AB-ik6bt
@AB-ik6bt 2 жыл бұрын
The SQL NATURAL JOIN is a type of EQUI JOIN and is structured in such a way that, columns with the same name of associated tables will appear once only.
@ShreyA-ms3pe
@ShreyA-ms3pe 3 жыл бұрын
Hi, Thanks for such videos. Could you please recommend us couple f Advanced SQL/MYSQL and Python books specific to Data/Business analyst roles? PS: I had commented on this video earlier, don't how it got deleted.
@balajikomma541
@balajikomma541 3 жыл бұрын
Sir make playlist in Microsoft SQL also
@kommabalaji4845
@kommabalaji4845 3 жыл бұрын
Sir at what stage of SQL project we use it? why do we use joins? Is to update the tables? or Any other reason?
@krishnaik06
@krishnaik06 3 жыл бұрын
I have explained in the video
@kommabalaji4845
@kommabalaji4845 3 жыл бұрын
Sir, What I understood is, it is used to update the missing values in the rows of one table wrt the rows in the other tables. After that we can use it for Data Modelling. Sir correct me if I'm wrong.
@asutoshnayak1391
@asutoshnayak1391 3 жыл бұрын
Sir please make a video upon how to do SQL projects please sir?
@tutorb6975
@tutorb6975 3 жыл бұрын
Hello Krish! Please pardon me for sending my request here, but I am in dire need of help. I am writing with an effort to get some advice on setting up tensorflow, opencv and keras on anaconda. My first attempt to use Jupyter in an environment failed. Jupyter works in 'base' but not in a created environment - 'kernel won't connect'. I have tried like a 'million' times even on different machines but no success.
@SandeepKumar-ym3yl
@SandeepKumar-ym3yl 3 жыл бұрын
Simple just add 3 table after join ends and join with 2nd
@tutorb6975
@tutorb6975 3 жыл бұрын
How does one become a member of your channel?
@souravnegi7766
@souravnegi7766 3 жыл бұрын
sir where is the video of retreiving data from more than 2 tables? yesterday it was there now its not there
@pavib5694
@pavib5694 3 жыл бұрын
At which time this live is going can anyone pls tell me
@krishnaik06
@krishnaik06 3 жыл бұрын
7pm
@technicalzone4387
@technicalzone4387 9 ай бұрын
natural join and cross join works same. its gives same resultset
@subhrajitsaha233
@subhrajitsaha233 2 жыл бұрын
Please provide the data sets used in the video
@nahidferdous8774
@nahidferdous8774 2 жыл бұрын
Natural join lookes like inner join.I think both joins are same.
@dhruvanand9773
@dhruvanand9773 3 жыл бұрын
First
@vigneshkr7391
@vigneshkr7391 2 жыл бұрын
Self join left!
@mominizhar6760
@mominizhar6760 3 жыл бұрын
It's am or pm 🤔
@PavanKumar26
@PavanKumar26 3 жыл бұрын
AM
Tutorial 9- MYSQL Stored Procedures -MySQL Complete Playlist
10:01
КОНЦЕРТЫ:  2 сезон | 1 выпуск | Камызяки
46:36
ТНТ Смотри еще!
Рет қаралды 3,7 МЛН
Their Boat Engine Fell Off
0:13
Newsflare
Рет қаралды 15 МЛН
БАБУШКА ШАРИТ #shorts
0:16
Паша Осадчий
Рет қаралды 4,1 МЛН
Learn 12 Basic SQL Concepts in 15 Minutes (project files included!)
16:48
Tutorial 4- SQL Constraints Part1 - My SQL Complete Playlist
21:45
SQL Joins: Difference Between Inner/Left/Right/Outer Joins
10:52
MySQL SELF JOINS are ... ughhh
10:03
Bro Code
Рет қаралды 80 М.
КОНЦЕРТЫ:  2 сезон | 1 выпуск | Камызяки
46:36
ТНТ Смотри еще!
Рет қаралды 3,7 МЛН