Regarding the first question: It's my understanding that you can normalize a RDBMS. In the strictess sence you have to reference other data in an RDBMS, but I think if you say that you cannot normalize a RDBMS in an interview it would imply that normalization is not an optimization process. Analytics Vidhya has an article "How to Normalize Relational Databases With SQL Code?"
Thanks for bringing this up!! For the community, here's the link to the article: www.analyticsvidhya.com/blog/2023/02/how-to-normalize-relational-databases-with-sql-code/
Book FREE 1:1 Mentorship for Gen AI / Data Science
Link 🔗 bit.ly/3wlIIGz
Great tutorial on SQL relevant conceptual issues
Glad you liked it. Share among your peers!
Thank you for share such good question.
thanks for this basic concepts of SQL concepts
Awesome video 😊😊😊 which I have ever seen before.❤❤❤
thanks for video,
please make the video for OOPs, OS, Computer network and linux that will be great help for us.
Thank you!
sir i have a question do they ask simple sql queries to fresher or hard sql queries toa fresher in data analytics roles
thank you for your valuable video can you please one more video for SQL coding interview questions
For sure!!
Please make video on condition based sql query question.
Sure thing!! :-)
you missed triggers and types of normalization forms sir
Useful 👏👏
Glad to hear that
thank you sir
6:27
Regarding the first question: It's my understanding that you can normalize a RDBMS. In the strictess sence you have to reference other data in an RDBMS, but I think if you say that you cannot normalize a RDBMS in an interview it would imply that normalization is not an optimization process. Analytics Vidhya has an article "How to Normalize Relational Databases With SQL Code?"
Thanks for bringing this up!! For the community, here's the link to the article: www.analyticsvidhya.com/blog/2023/02/how-to-normalize-relational-databases-with-sql-code/
You are making a valid point there
Because of subtitle can not see syntax
Disable CC
Select is not DML command
SELECT is a DQL(Data Query Language) command