Thank you so much for the feedback.. Much appreciated.. Glad you liked it..🙏🏼

Thank you for your support 🙏☺️

Your welcome Dame :) Glad it helped..

You're welcome

Thank you so much 😊 Glad you liked it...

SQL can be used to extract data, analyze data and load data to any other source. Whereas, Excel is primarily used to view and analyze data (ofcourse you can do other things as well like visualization but there are better tools for visualization). Loading large dataset in excel will make it very slow (almost unusable) whereas SQL can easily handle huge amounts of data. Excel can be great tool when you want to share small data with your team members but if you need to share large dataset with team member then better share SQL queries. There are so many more differences btw these 2 which I may not be able to explain in this comment here but in general both have their own use case..

@@techTFQ thanks!

Your welcome 🙏🏼

Thank you.. Noted on your feedback 😊

Thanks a lot.. sure will do..🙏🏼

Thank you 😊

Hi, i think this happens in many companies.. More people are familiar and comfortable with Excel rather than SQL. And not everyone realizes the advantages of using SQL. Having said that, SQL is very useful for data analysis, extracting and loading data but when it comes to presenting your report to other colleagues or business users (who may or may not have access to SQL or who may just not be comfortable in SQL), it's better you provide them both the options of using Excel as well as SQL (share SQL query and also the steps to regenerate it) Also may be add a single line at the end of your email stating the advantages of SQL. I believe if you do this over a period of time, people will gradually start noticing SQL and perhaps start using it over Excel. But I also believe that both SQL and Excel are here to stay so both will be used. Just that for some scenarios, it's better to use SQL and in some scenarios using Excel would be more efficient.

@@techTFQ Thanks a lot! This really helps. Keep up the good work! ( Y )

Glad I could help.. all the best and thanks again for appreciating my work ☺️🙏🏼

Bravo❤... may i get the datasets of the two tables you are using.

Thank you 😊 😊

Hi there, I just pasted your question into chat gpt and the following. Yes, it's possible to delete rows with duplicate values in one column using SQL, similar to how you would in Excel. Here's a basic example of how you can achieve this using a Common Table Expression (CTE) and the `ROW_NUMBER()` function: ```sql WITH CTE AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY your_column ORDER BY (SELECT NULL)) AS row_num FROM your_table ) DELETE FROM CTE WHERE row_num > 1; ``` In this example: - Replace `your_table` with the name of your table. - Replace `your_column` with the column that contains duplicate values. This code assigns a unique row number to each row within each partition of the specified column. Rows with a `row_num` greater than 1 are considered duplicates and are deleted.

Hi. Convert the excel file into .csv format, and then load it into DB for querying using SQL.

Yes right but then I wanted to keep the video as short as possible and cover the most widely used functions in excel as per my research.. but definitely a point to remember for any future video’s Thanks for the feedback 🙏🏼☺️

yeah thats true..

Thank you Nourish.. 😊

What’s this about Pedro ? 🤔

@@techTFQ I use this to review next time. Bookmark.

Ohh ok .. cool .. happy learning bro 🙏🏼🙂

Which question?