Double your learning efficiency, use ChatGPT to learn SQL data analysis

ChatGPT can do a lot of cool things. One of them is writing code. Users only need to give the correct instructions and ChatGPT will do the job.

If you want to learn SQL, ChatGPT is a great resource to get started. It helps you create SQL queries in natural language, solves any coding issues you may have, and even helps you understand predefined queries you don't understand.

This article will outline how to use ChatGPT to learn SQL and become proficient in this valuable skill.

First of all, what exactly is ChatGPT?

ChatGPT is a large language model trained by OpenAI. It is capable of generating human-like text based on the input it receives and can be used to answer questions and hold conversations with people.

So basically, users can leverage its knowledge -- and its ability to tell the user anything in a very simple and human way -- to understand SQL and learn from it.

Step 1: Set up ChatGPT

To start using ChatGPT, you need to register an account on the ChatGPT|OpenAI official website.

ChatGPT registration interface

You must provide your email address and phone number to start using ChatGPT.

Step 2: Learn How to Interact with ChatGPT

Once ChatGPT is enabled, you should see the following display:

ChatGPT Chat Display Screenshot of

In the input box below, users can write anything to start interacting with ChatGPT.

ChatGPT responded to my first message.

Step 3: Ask any question you can think of – and it will answer you.

So now you can start asking ChatGPT any questions. This article will focus on learning SQL. There are 5 main things we can ask to do to improve our SQL skills by using ChatGPT.

1. Explain any concept or command in SQL to the user

When encountering a new programming language, we usually have a lot of doubts and confusion about every command. ChatGPT can help understand any command with simple explanations and provide as many usage examples as requested.

This article starts with the most basic thing in SQL-the SELECT command.

Please briefly explain what the SELECT command is and give an example of how to use it.

ChatGPT answered a short answer explaining the SELECT command and gave the most basic example: SELECT*FROM.

ChatGPT chat screenshot.

However, the SELECT command can be further interrogated.

Please explain what the SELECT command is and some examples showing how to use it.

As you can observe in the image below, ChatGPT explains the basic principles of this command and gives some examples of its use.

ChatGPT chat screenshot. More examples of SELECT commands are given.

You can try asking for any command imaginable, such as a more challenging command like HAVING.

Give me some examples of HAVING command in SQL.

ChatGPT gives the following examples to answer:

1. To find the names and salaries of all employees whose income is higher than the average salary, you can use the following query:

<code>SELECT  name,  salaryFROM employeesGROUP BY nameHAVING salary > (SELECT AVG(salary) FROM employees);</code>

2. To find the names of all customers who have placed more than 10 orders in the past year, you can use the following query:

<code>SELECT  name FROM customers WHERE customer_id IN (SELECT customer_id FROM orders WHERE date >= DATEADD(year, -1, GETDATE()) GROUP BY customer_id HAVING COUNT(*) > 10);</code>

Of course, you can continue Asking for more explanation and more examples. Try any other command you can think of and it will answer right away.

2. You can ask how to do something in SQL, and ChatGPT will let you know what command (or commands) to use.

Can ask how to do a specific action and ChatGPT will let me know what command I need to use.

我想合并两个表，应该在SQL中使用什么命令？

ChatGPT回答可以使用任意join命令，可以在下面的图片中看到:

ChatGPT聊天的截图。解释如何合并两个表格。

然而，我知道我只是想在某些特定列中的行有重合值时连接两个表。在这种情况下，我可以再询问一下，了解一下我应该使用什么命令。

我想连接两个表，只获取在某些给定的列中有一致值的数据。

我想连接两个表，只想获得在某些给定列中有重合值的数据。

因此，ChatGPT让我知道只有INNER JOIN允许这样做，可以在下面的图片中看到：

ChatGPT聊天的截图。解释了如何合并两个表，并只是保持重合的数值。

它给出了相应的查询：

<code>SELECT *FROM table1INNER JOIN table2 ONtable1.id = table2.id AND table1.name = table2.name;</code>

3.可以要求ChatGPT使用自然语言创建查询

现在让我们想象一下，我知道我需要什么结果，但我没有如何制定这个查询的任何想法。我可以简单地向ChatGPT解释我想做什么，它就会给我一个让我遵循的结构。因此，我可以按照ChatGPT的例子学习如何构造查询。

请向我解释一下如何创建一个SQL查询，计算出欧洲最昂贵的城市，并在表中列出每个城市不同商品的价格。

ChatGPT马上回答我，你可以在下面的图片中看到:

ChatGPT给出了一个查询的例子，并解释了这个查询的作用。

4.可以询问ChatGPT，它会向你解释查询是如何进行的。

现在让我们想象一下，你正在做从一个生病的同事那里接手的工作，但是你不理解他的查询——有些人的编码方式很混乱，或者你可能只是觉得很懒，不想浪费太多时间去理解别人的查询。

这很正常——可以用ChatGPT来避免这项任务。我们可以很容易地要求ChatGPT解释一个给定的查询。

假设我们想了解下面这个查询是做什么的：

下面的查询是做什么的：[在此插入查询]

ChatGPT就会马上回答：

ChatGPT聊天的截图。它解释了一个给定的查询是做什么的。

正如在前面的图片中所看到的，ChatGPT一步一步地解释了这个查询的作用。

首先，它解释了所有包含的子查询和它们的作用。然后，它解释了最终的查询，以及它如何使用前面的子查询来合并所有的数据。我们甚至可以要求在一个给定的子查询中提供更详细的解释。

你能进一步解释前面查询的第二个子查询是做什么的吗？

ChatGPT聊天的截图。它进一步解释了给定查询的第二个子查询的作用。

正如在前面的图片中所看到的，ChatGPT详细解释了第二个子查询的内容。

用户可以用能想到的任何查询来挑战ChatGPT!

5.可以要求ChatGPT用练习来帮助你提升。

ChatGPT最好的部分就是可以要求它提供一些练习和答案来练习和测试你的技能。它甚至可以告诉你，你什么时候做得好——或者不好。

Can you give me some exercises to practice SQL

Screenshots of ChatGPT, give me some exercises to practice SQL.

Now ChatGPT tells me some issues that need to be executed. In this case, I can try to solve the first problem and ask ChatGPT if my solution is correct.

Whether the following query is correct for the answer to the first exercise above [insert query]

ChatGPT will answer and write whether it is correct and why.

# Screenshot of ChatGPT to answer my query on whether the encoding is correct.

I can ask for the correct answer to each of the previous examples:

Can you give me the correct answer to the previous exercise?

As you can see in the picture below, ChatGPT gives me all the correct query results.

⚠️ Noticed that the answer provided to me by ChatGPT and the checked answer I provided were completely different.

Summary

SQL is a valuable skill in today’s data-driven world. Become proficient in SQL by using ChatGPT to learn the basics and practice skills. With continued learning and practice, you can continue to expand your skills and use this tool to take leaps in your data career.

The above is the detailed content of Double your learning efficiency, use ChatGPT to learn SQL data analysis. For more information, please follow other related articles on the PHP Chinese website!