Hi krish, As i have taken big data in ineuron plat form. I came to know that sql also required to know for big data, Later i confirmed with saurav. For big data fresher role your MySQL playlist sufficient for interview?
Sir , Doubt create view student_info as -> select first_name,last_name,age from student inner join department using (studentid); what is the need of doing above line if below code is doing the same create view student_info_temp as -> select first_name,last_name,age from student;
Aap Mahan ho sirji... Kya badhiya sikhate ho...🙏🙏🙏🙏
I always found views confusing, thanks for this!
Thanks for this valuable video! I found your channel by coincidence and subscribed after this video! great channel !!
Waiting for this. Thanks
Just a request please put interview questions for data analysis with their answers as previously there were just questions and not answers
yes a lot are coming
Interview questions on joins will be helpful
Very useful sir. Could u please try to show the syllabus that u have designed to cover in this playlist in the next video..if possible.
Thank you!
Just like SQL, can we get DSA in python playlist? It will be really helpful for college freshers like us. It's a request 🙏
yaa
Can you please create a video explaining Stored Procedures and CTE?
One video on your channel how to prepare sql for data analyst
Hi sir
if you query select* for two tables result is coming for 1 table only??
Hi krish, As i have taken big data in ineuron plat form. I came to know that sql also required to know for big data, Later i confirmed with saurav. For big data fresher role your MySQL playlist sufficient for interview?
this is it or more videos wil come in this playlist
Please can clear my confusion cloud computing or data analyst which is better career?
Sir , Doubt
create view student_info as
-> select first_name,last_name,age from student inner join department using (studentid);
what is the need of doing above line if below code is doing the same
create view student_info_temp as
-> select first_name,last_name,age from student;
he just wanted to give an example.
concept of view is clear but the query part is not that much clear 😢
And DSA from basic like from theory part of it. Starting from 0
so after creating view and inner join , id will not show in the table?
You like mechanical Krish, because of there is no girls😂😂😂😂I can't stop laughing 🤣🤣
Cleared view concept.. Thank you Krish 👍
Simply , view is like a variable in other languages m right??
why i cant write these complex queries in a view? what will happen?
But sir sql views are working with aggregate queries as well. Even google says so.
What is difference between view and store procedure
Sir is this similar to temp table in MSSQL?
Also if anyone in the chat can help It'll be really great
can we use view as duplicate of table
Actually i face one issue in this query .(foreign key)
sir please upload video faster...4 days gone already
SQL ke video dalo Hindi me
Write a query to print index of all the occurrences of A in a name.
can anybody help please.