@CheshtaBeniwal
Hey Ankit, Nice project! It was my first end to end one. Will definitely check out more of your content! Great to have you on YT!
@rahulrachhoya2716
Thanks so much @Ankit this valueable video for me. I have an interview with red hat in up coming 3 days as an associate data analysts. I learn lot from your Videos. You are litterly SQL king because you write in very simple manner so that every one can understand . You are my mentor with your videos I am able to solve questions like you . Salute you @Ankit 😎😎😎
@pavitrashailaja850
Great effort in putting the whole project together 🤟🏻
@vishalkhorwal4887
Excellent Video Ankit. Appreciate your effort.
@manuelmelendezebrat165
Hi Ankit, min 37:55 when we create Netflix clean table, you delete the WHERE clause rn =1, and then create the table. However was not this clause the one who keep the table away from the duplicated titles? If we execute : SELECT title,count(*) from netflix group by title HAVING COUNT(*) > 1 we will find the same duplicates. I think we should create the table with the WHERE clause. Maybe I'm making a mistake. Thanks for you effort.
@davidrenoux582
Hi Ankit, Very interesting video. I've learned a lot from it. I encourage people to give you more likes because you really deserve it. Unfortunately for you the "amateurish" videos get more likes than the "professionnal" ones like yours. Videos that pledge they will teach you complicated subject matters in less than 5 minutes and that skip any technical issue encountered in real life are more appealing. Marketing is based on making people believe that Santa Claus exists and that he will provide endlessly even for the laziest ones. AI is the last trick of Marketing even though it can be useful for tedious and repetitive tasks. The problem is that explaining to someone else what you really want is often more time consuming than doing it yourself in the first place. The perception of "quality" is often very personal and subjective. I guess that you've already experienced that when dealing with your clients. Have a good day ! 🙂
@kspatil001
37:09 You deleted the duplicating condition too alongwith date=NULL condition.
@CheshtaBeniwal
Ref to setup SQL Server: "SQL Basics Tutorial For Beginners | Installing SQL Server Management Studio and Create Tables " by Alex the Analyst was helpful and quick.
@spectator_247
It was a really nice project. Had a good hands on in sql.
@shahrizwan818
nice work sir Thanks for uploading ,please upload more videos like this
@vijayakanthanannamlai
love it Ankit... what an effort
@livelovelaugh4050
Thank you so much Sir 🙏 . Thank you for giving hope for people like me . Keep inspiring ✨
@kapilsharma-mo6ww
bdiya bhai .mast
@manishpal2937
thanks Ankit, the effort you put in your lectures is admirable, learned a lot of new things today from this video 💌
@ishmeenkaur8299
really good work, easy to understand.
@MiteshYadav
Awesome, can we have series on Python from basics that can be useful for analysis..
@giloooogiloooo
What is the link to the previous project you mentioned?
@davidrenoux582
HI Ankit, Wether it's on Prime Video or Netflix, Movies or TV Shows are added or removed or added one more time according to their audience rates so the same movie/tv show could logicaly appear with several values for "date_added" (in 2018, 2019, 2021), especially for TV Shows spanning on several seasons. It's not abnormal. What is abnormal is that there is not more "false" duplicates. This means that for other records provided we can assume that only the first time the movie/tv show was added on the plateform is recorded (otherwise it would be too much maintenance updating the old records). Since show_id does not follow any chronological order it would be best to "untie" these duplicates by the date_added column and to keep the record with the earliest value. Don't you think so ? Sorry for focusing on the meaning of the data. I know that on youtube only technical issues matter for most of the people.
@anikkumarbanik2127
Hi Ankit, please tell me how to separate multiple values from a column in my SQL and keep them in a new table.
@ankitbansal6