Start Data Career in 2025 (Best Course) 💼 Google Cybersecurity Professional Certificate imp.i384100.net/kO4n6L 💼 Microsoft Business Analyst Professional Certificate imp.i384100.net/NkOArq 💼 IBM Data Engineering Professional Certificate imp.i384100.net/Bn5Wv9 💼 Google Advanced Data Analytics Professional Certificate imp.i384100.net/6ykaYN 💼 Meta Data Analyst Professional Certificate imp.i384100.net/4Gakv1
Hi for the last question that is show genre or show information if the genre rating is greater than the avg rating I think we can write in this way like. Select * from Netflix where rating => (select avg(rating)from Netflix) ;
We cannot alter view you need to recreate view! Alter means adding adding new col or changing data types which is only done in actual table as views as not real table but it is sql statements which run once you fire the query!
@@zero_analyst We can use alter statement in view but it works differently. We can alter an existing View without dropping and recreating it. and mention the columns which we want from the table .. Alter View excitingview as select columns from table_name So we can use alter in view without dropping or recreating it We must specify all the desired columns from the table
Get datasets here
github.com/najirh/SQL-Mock-Interview-Series/blob/main/vid%205.md
My interview schedule on Sunday..❤
Start Data Career in 2025 (Best Course)
💼 Google Cybersecurity Professional Certificate imp.i384100.net/kO4n6L
💼 Microsoft Business Analyst Professional Certificate imp.i384100.net/NkOArq
💼 IBM Data Engineering Professional Certificate imp.i384100.net/Bn5Wv9
💼 Google Advanced Data Analytics Professional Certificate imp.i384100.net/6ykaYN
💼 Meta Data Analyst Professional Certificate imp.i384100.net/4Gakv1
Thank you bhaiya for this amazing interview. I am learning a lot from you.
Please also share the data that you have used in the video for the interview, thanks
Hi for the last question that is show genre or show information if the genre rating is greater than the avg rating I think we can write in this way like. Select * from Netflix where rating => (select avg(rating)from Netflix) ;
Keep going Bhai
It was a good a practice. I solved all the questions. I think I'm ready to face an interview. Fingers crossed 🤞
All the best
Could you please send the community link as well to learn from SQL Bot, thanks for such an informative videos
Create view [Name] as
Select column_1,column_2
From T1
Where first_name = "John Albert";
Select * from Name;
Not able to join discord community. It is showing invalid link or expired link. Can you provide me link to join the community
discord.com/invite/qtRt2HWew7
Hello bro M bhi data analysis banna chahta hu sekha raha hu python,SQL, power bi, Excel but now I want a job any type. I have master degree. Help me
sir kya agar mai tech background se nahi hu per mai DA sika hu kya esme muje job milega?
Not able to join discord community. It is showing invalid link or expired link. Can you provide me link to join the community
discord.gg/3Ks8QbKQ
We can alter view
We cannot alter view you need to recreate view!
Alter means adding adding new col or changing data types which is only done in actual table as views as not real table but it is sql statements which run once you fire the query!
@@zero_analyst We can use alter statement in view but it works differently.
We can alter an existing View without dropping and recreating it.
and mention the columns which we want from the table ..
Alter View excitingview as select columns from table_name
So we can use alter in view without dropping or recreating it
We must specify all the desired columns from the table