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
thanks for video,
please make the video for OOPs, OS, Computer network and linux that will be great help for us.
Thank you for share such good question.
you missed triggers and types of normalization forms sir
Select is not DML command
thanks for this basic concepts of SQL concepts
Great tutorial on SQL relevant conceptual issues
Glad you liked it. Share among your peers!
Because of subtitle can not see syntax
Disable CC
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!! :-)
6:27
Thank you!
Awesome video 😊😊😊 which I have ever seen before.❤❤❤
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
Useful 👏👏
Glad to hear that