Excel Alternative: How to use SQL to perform EXCEL tasks (SQL for Data Analysis)
35.7 هزار بار بازدید -
4 سال پیش
-
Microsoft Excel Alternative: How to
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 - Basic concepts
✅ SQL Tutorial - Intermediate concepts:
SQL Tutorial - Intermediate concepts
✅ SQL Tutorial - Advance concepts:
SQL Tutorial - Advance concepts
✅ Practice Solving Basic SQL Queries:
Practice Solving BASIC SQL Queries
✅ Practice Solving Intermediate SQL Queries:
Practice Solving INTERMEDIATE SQL Que...
✅ Practice Solving Complex SQL Queries:
Practice Solving COMPLEX SQL Queries
✅ Data Analytics Career guidance:
Data Analytics career and more
✅ SQL Course, SQL Training Platform Recommendations:
SQL Course / Training
✅ Python Tutorial:
Python Tutorial
✅ Git and GitHub Tutorial:
Git and GitHub
✅ Data Analytics Projects:
Data Analytics Projects
THANK YOU,
Thoufiq
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 - Basic concepts
✅ SQL Tutorial - Intermediate concepts:
SQL Tutorial - Intermediate concepts
✅ SQL Tutorial - Advance concepts:
SQL Tutorial - Advance concepts
✅ Practice Solving Basic SQL Queries:
Practice Solving BASIC SQL Queries
✅ Practice Solving Intermediate SQL Queries:
Practice Solving INTERMEDIATE SQL Que...
✅ Practice Solving Complex SQL Queries:
Practice Solving COMPLEX SQL Queries
✅ Data Analytics Career guidance:
Data Analytics career and more
✅ SQL Course, SQL Training Platform Recommendations:
SQL Course / Training
✅ Python Tutorial:
Python Tutorial
✅ Git and GitHub Tutorial:
Git and GitHub
✅ Data Analytics Projects:
Data Analytics Projects
THANK YOU,
Thoufiq
4 سال پیش
در تاریخ 1399/10/14 منتشر شده
است.
35,754
بـار بازدید شده