very reasonable video ........ he delivered it 100% .... good knowledge and worthy video . good work
@techTFQ3 жыл бұрын
Thank you so much for the feedback.. Much appreciated.. Glad you liked it..🙏🏼
@apamwamba2 ай бұрын
Truth is that both tools are powerful in their own ways and can be useful in different environments so its a matter of learning as much as you can and use the appropriate tool..
@krisyannuruha5147 Жыл бұрын
Just combine the two of it using power query and power pivot.. i'm using sql to store and clean up my data. Also to do heavy calculation with a lot of data then connect it to excel for data manipulation and data visualization and more complex calculation but with smaller data.
@Life-tech-hack-103 Жыл бұрын
This video is very clear and good for Excel users to appreciate SQL. Good job
@shaikusman536 Жыл бұрын
Very much needed Video....simple & clear comparision....It cleared my doubts on Ecxcell v/s SQL........Thanks a ton brother.....
@SystaneEA2 жыл бұрын
I've been looking / searching what sql can do better / more than excel and this is actually the best one I've seen so far. Thanks buddy :)
@fathimafarahna26333 жыл бұрын
Useful to many.. clear, concise and accurate. Keep doing your great work of helping people by sharing your knowledge.
@techTFQ3 жыл бұрын
Thank you for your support 🙏☺️
@CyberDame3 жыл бұрын
Sql reminded me to lotus 123 and excel. Thank you for clarifying.
@techTFQ2 жыл бұрын
Your welcome Dame :) Glad it helped..
2 жыл бұрын
Excellent comparing. Thanks!
@kajolmishra403011 ай бұрын
It's really helpful for me... Thanks
@techTFQ10 ай бұрын
You're welcome
@prajnamayadi17643 жыл бұрын
Hi Thoufiq! Thank for very clear explanation. very helpful! continue with the good work :)
@techTFQ3 жыл бұрын
Thank you so much 😊 Glad you liked it...
@dylanarmstrong93283 жыл бұрын
What are some examples of situations where it’s better to use SQL over excel and vice versa? From what I understand SQL seems to be more efficient when you want to access data whereas Excel is better for data visualization and table creation.
@techTFQ3 жыл бұрын
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..
@dylanarmstrong93283 жыл бұрын
@@techTFQ thanks!
@techTFQ3 жыл бұрын
Your welcome 🙏🏼
@mtalootera17813 жыл бұрын
Nice... Presentation Superb.. Clarity Superb.. Thanks for Sharing... Next time do show ua face while explaining...
@techTFQ3 жыл бұрын
Thank you.. Noted on your feedback 😊
@smithasmith1613 жыл бұрын
Good information
@techTFQ3 жыл бұрын
Thank you 😊
@shefeekbasheer75143 жыл бұрын
Nice, Please make more videos
@techTFQ3 жыл бұрын
Thanks a lot.. sure will do..🙏🏼
@Loedairy Жыл бұрын
Makes sense 😊
@mohammedshahil48983 жыл бұрын
Thank you for this informative video👍🏻 Indeed very useful👏🏻 Keep going
@techTFQ3 жыл бұрын
Thank you 😊 😊
@pnggreen52583 жыл бұрын
Hi al i have a burning questiob. I started using more sql instead of excel as an analyst within our organisation. However, everytime I provide colleagues with a power bi report or data from SQL, they want me to send an excel file of the data. They all want to be able to filter etc themselves in excel. So despite that i summarize lots of data using sql my coworkers hate it because they want theor data in excel. How to deal with this
@techTFQ3 жыл бұрын
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.
@pnggreen52583 жыл бұрын
@@techTFQ Thanks a lot! This really helps. Keep up the good work! ( Y )
@techTFQ3 жыл бұрын
Glad I could help.. all the best and thanks again for appreciating my work ☺️🙏🏼
@boqorcabdalla Жыл бұрын
Bravo❤... may i get the datasets of the two tables you are using.
@jenniferduffy4863 Жыл бұрын
What about when you want to delete rows in excel which have duplicate values in one column (out of for example 10 columns)…. In Excel I can press delete duplicate rows and unselect all columns except the one with the duplicates. This gives me just the first row for each unique value in the relevant column. I have tried to do this in sql using a combination of cte and row_num() over partition by but have not managed to imitate excel. I am relatively new to sql. Is this something you might cover in a video? 🙏
@shaneboaden50053 ай бұрын
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.
@monicaah24688 ай бұрын
What about SUMIFS?
@prosenjitshaw936 Жыл бұрын
Can I learn SQL without or No knowledge of MS Excel.. please guide..
@satindersingh25622 жыл бұрын
Great Efforts sir 👍
@BobyPathan-i3j4 ай бұрын
Means, I have no option except practicing SQL?
@dipalimahulkar419 Жыл бұрын
How to import Excel file in to SQL
@zaitunpeace4 ай бұрын
Hi. Convert the excel file into .csv format, and then load it into DB for querying using SQL.
@goombakiwi3 жыл бұрын
It would have been more comparable for Substr to be related to the excel "mid" function.
@techTFQ3 жыл бұрын
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 🙏🏼☺️
@denisbaranoff2 жыл бұрын
There is an inconvinience to work with regexp in excel ...
@techTFQ2 жыл бұрын
yeah thats true..
@ibrahimnourish8803 жыл бұрын
👍👍
@techTFQ3 жыл бұрын
Thank you Nourish.. 😊
@lani58012 жыл бұрын
Hi did you see my question?
@techTFQ2 жыл бұрын
Which question?
@sidiqdoang35422 жыл бұрын
anyone can tell me about the function of " , " at the first and " S " qt the end?
@pedrojulio19603 жыл бұрын
0:28 2:00
@techTFQ3 жыл бұрын
What’s this about Pedro ? 🤔
@pedrojulio19603 жыл бұрын
@@techTFQ I use this to review next time. Bookmark.
@techTFQ3 жыл бұрын
Ohh ok .. cool .. happy learning bro 🙏🏼🙂
@lifemanit24273 жыл бұрын
Waste of time...not useful ...both have their own perks...