Use ChatGPT To Write SQL Queries From Scratch
Вставка
- Опубліковано 12 вер 2024
- ChatGPT can create SQL queries for you.
Here's a quick walkthrough in the video.
Some best practices:
1) Set the context
2) Give ChatGPT a role to play (ex: SQL expert)
3) Describe your table(s)
4) Tell the AI what you want a query to do
This is a use case that will produce mixed results.
It's mostly pretty good, but not perfect.
So it's best to come armed with some basic SQL skills so you can evaluate the result you're getting from the AI tool.
Still, it can do some of the heavy lifting for you.
And we expect tools like ChatGPT and Google Bard to get much better over time. At some point they'll be rock solid.
Learn more about ChatGPT for Data Analytics!
COURSE DETAILS: 👉 mavenanalytics...
In this course we share our ChatGPT best practices, and walk through some of the most interesting Analytics use cases for Excel, Google Sheets, Power BI, SQL, and Python.
Happy learning!
Want to learn data analysis and business intelligence? Our guided learning model gives you the flexibility to create your perfect path, with live support and expert coaching to keep you on track every step of the way.
www.mavenanaly...
Want to practice your skills? Explore and download sample datasets hand-picked by Maven instructors. Apply your data analysis and visualization skills to real-world data, from flight delays and movie ratings to shark attacks and UFO sightings.
Typical "Maven Analytics": absolute TOP QUALITY in everything you guys do.
Love the comments and comparison to Bart.
OMG, Bard even added some sample rows ... crazy
@MavenAnalytics I love the video. This maybe minor. However, I did'nt see where you pointed the chat to the particular name of the database. I have multple datbases.
can you show examples of working with actual database ?
I would like that as well
Why? You only need the schema to answer the question.
informative video
Nice