Excel Alternative: How to use SQL to perform EXCEL tasks (SQL for Data Analysis)

Microsoft Excel Alternative: How to use SQL to perform EXCEL tasks and use SQL for Data Analysis.
Can we use SQL to perform Excel tasks? Is SQL better than Excel? How can we use SQL instead of Excel? Can we do Data Analysis using SQL?
If you’ve had these questions, then this video is for you. We look at the issues with Excel and how SQL can help overcome these issues.
We also cover on how to use SQL to perform Excel tasks and go through some of the most commonly used excel features such as VLOOKUP, PIVOT table, FILTER, SORT, CONCATENATE, LEFT, LEN, FIND, IF, SUMIF etc.

This video is not a comparison between Excel and SQL but is aimed at showing SQL as an alternative to Microsoft Excel or for that matter to any other spreadsheet applications such as Google Sheets etc.

We go through the SQL queries which can be written to perform Excel tasks. And also go through on how to load Excel data into SQL table.

We are using PostgreSQL database and PgAdmin tool to perform SQL operations.

Following things are covered in this video:
- Issues in Excel spreadsheet.
- How SQL overcomes the issues faced in Excel.
- How to load Excel data into SQL table.
- Alternate SQL functions to perform Excel tasks.
- SQL queries to perform Excel tasks.

Following Excel formulas and SQL queries are covered in the video:
1. SQL WHERE clause to filter data.
2. Order by clause to sort data.
3. CONCAT function to merge column values.
4. SUMIF to add column values based on certain criteria.
5. LEN function to count the string length.
6. SQL CASE statement to perform IF ELSE task in Excel.
7. POSITION function to FIND characters.
8. SUBSTR to search for a substring in the given text.
9. SQL JOINS to perform Excel VLOOKUP operations.
10. SQL PIVOT table similar to Excel PIVOT table.

🔴 WATCH MORE VIDEOS HERE 👇

✅ SQL Tutorial - Basic concepts:

✅ SQL Tutorial - Intermediate concepts:

✅ SQL Tutorial - Advance concepts:

✅ Practice Solving Basic SQL Queries:

✅ Practice Solving Intermediate SQL Queries:

✅ Practice Solving Complex SQL Queries:

✅ Data Analytics Career guidance:

✅ SQL Course, SQL Training Platform Recommendations:

✅ Python Tutorial:

✅ Git and GitHub Tutorial:

✅ Data Analytics Projects:

THANK YOU,
Thoufiq

[Hellokingworld]

very reasonable video he delivered it 100% .... good knowledge and worthy video . good work

[apamwamba]

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..

[SystaneEA]

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 :)

[Life-tech-hack-]

This video is very clear and good for Excel users to appreciate SQL. Good job

[krisyannuruha]

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.

[shaikusman]

Very much needed Video....simple & clear comparision....It cleared my doubts on Ecxcell v/s a ton

[fathimafarahna]

Useful to many.. clear, concise and accurate. Keep doing your great work of helping people by sharing your knowledge.

[prajnamayadi]

Hi Thoufiq! Thank for very clear explanation. very helpful! continue with the good work :)

[CyberDame]

Sql reminded me to lotus 123 and excel. Thank you for clarifying.

[kajolmishra]

It's really helpful for me... Thanks

[mohammedshahil]

Thank you for this informative video👍🏻 Indeed very useful👏🏻 Keep going

[mtalootera]

Nice... Presentation Superb.. Clarity Superb.. Thanks for Sharing... Next time do show ua face while explaining...

[dylanarmstrong]

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.

[sidiqdoang]

anyone can tell me about the function of ", " at the first and " S " qt the end?

[goombakiwi]

It would have been more comparable for Substr to be related to the excel "mid" function.

[jenniferduffy]

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? 🙏

[pnggreen]

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

[prosenjitshaw]

Can I learn SQL without or No knowledge of MS Excel.. please guide..

[qvetnxq]

Means, I have no option except practicing SQL?

[denisbaranoff]

There is an inconvinience to work with regexp in excel ...