fbpx
Search
Close this search box.

All articles with 'sql' Tag

SQL vs. Power Query – The Ultimate Comparison

Published on Oct 13, 2023 in Chandoo.org Podcast Sessions, Power Query, SQL
SQL vs. Power Query – The Ultimate Comparison

On the left side, we have a veteran warrior with 37 years of data battle scars and redundant six pack. They call him SQL.

On the right side, there is a young challenger with transformative powers and “never say undo” attitude. He goes by the moniker Power Query.

Who is going to win this battle?!?

Continue »

Learn SQL for Data Analysis in one hour

Published on Aug 23, 2022 in Learn Excel, SQL
Learn SQL for Data Analysis in one hour

SQL is an important skill to have for people working with Data. In this article and the companion video, learn how to use SQL to perform common data tasks in under one hour. Sample files are provided.

Continue »

Using Excel As Your Database

Published on Apr 2, 2012 in Automation, Excel Howtos, VBA Macros
Using Excel As Your Database

Often I have thought, if I could have write “Select EmployeeName From Sheet Where EmployeeID=123” and use this on my excel sheet, my life would be simpler. So today we will learn how to do this.

People spend a lot of time thinking whether to use Excel as their database or not. Eventually they start using Access or SQL Server etc.

Today we will learn how to use Excel as a Database and how we to use SQL statements to get what we want. We will learn how to build a form like above.

Continue »

SQL Queries from Excel

Published on Sep 22, 2008 in Learn Excel, technology
SQL Queries from Excel

Often when you are working on 2 incompatible systems and try to import data from one to another, excel can be a handy tool. I have used excel plenty of times to generate SQL insert / update statements which I could later execute on the database console. Here is a tutorial if you ever have […]

Continue »