Microsoft Copilot is a text-based generative AI tool that can do various tasks. In this course, you will learn how to write prompts, generate content, generate codes and utilise its powerful features in the web version of Microsoft Copilot.
In this video lesson, we will learn about Generating SQL Queries in Microsoft Copilot.
You can access the entire Microsoft Copilot Course in the following playlist:
https://www.dailymotion.com/playlist/x8rnke
In this video lesson, we will learn about Generating SQL Queries in Microsoft Copilot.
You can access the entire Microsoft Copilot Course in the following playlist:
https://www.dailymotion.com/playlist/x8rnke
Category
📚
LearningTranscript
00:00So what you can also do is you can generate SQL queries using Microsoft Copilot. So to do that,
00:11I'm going to go ahead and type in this prompt. I'm going to go around and say generate a SQL
00:19query to create a table with name, SN, fruit type, color, fruit type and color right here just like
00:35this. So if I were to go ahead and press enter, then what happens is that it'll go ahead and then
00:40write an SQL query right here to create a table accordingly. You can go ahead and copy this and
00:46then go around onto any SQL compiler of your choice and then run the SQL query right here.
00:51And then what happens is that the fruits table is created as you can see right here. So now what I
00:56can go around and do is say, let's say for example, now generate 10 sample content for the sections
01:10and generate SQL query to do the entries on this particular table right here. So if I were to go
01:21ahead and do that, then what happens is that it'll go ahead and then write an SQL query for that as
01:27well. So you can see that it is going around right here. So it says here's a sample content and the
01:32SQL query for it. So I'm going to go around onto copy and go to SQL query editor right here and
01:41then run the SQL query right here. And you can see that under the fruits, you can see that the data
01:46has been inserted and that is how you can generate out SQL queries as you like inside of Microsoft
01:52Copilot. So I hope you found this video useful. So be sure to comment on what you think about it. Be
01:58sure to hit the like button and don't forget to share this out with your friends and family. And
02:03for more contents like these, do follow Simple Tutorials.