Natural Language to SQL using Google's Gemini Pro Model | SQL Database | Python

แชร์
ฝัง
  • เผยแพร่เมื่อ 3 ต.ค. 2024
  • Make natural language queries to a SQL Database using Google's Gemini Pro Model. In this video, you will discover how you can harness the power of Google's Gemini Pro Model to query a SQL Database using natural language. This step-by-step tutorial will guide you through setting up a powerful, intuitive, and user-friendly SQL querying system.
    ▶ Link to the notebook : github.com/bha...
    Gemini Pro Vision is a specialized version of Google's more general-purpose Gemini model, specifically fine-tuned for vision tasks. It's trained on a massive dataset of text and images, allowing it to understand the relationship between them.
    This enables it to perform various tasks like:
    ▶ Image generation: Create new images based on textual descriptions or existing images.
    ▶ Image captioning: Generate detailed descriptions of images.
    ▶ Image editing: Modify existing images based on instructions.
    ▶ Object recognition and classification: Identify and categorize objects within images.
    ▶ Visual question answering: Answer questions about the content of images.
    What makes Google's Gemini Pro Model special?
    ▶ Multimodality: Unlike traditional vision models, Gemini Pro Vision can combine information from text and images, leading to more accurate and nuanced results.
    ▶ Uncertainty-routed chain-of-thought: This novel approach allows the model to reason through complex tasks and make informed decisions, even in situations with incomplete information.
    ▶ State-of-the-art performance: Gemini Pro Vision has achieved impressive results on various benchmarks, outperforming other leading models in many tasks.
    What are its potential applications?
    ▶ Creative industries: Generate realistic product mockups, design concept art, or create personalized artwork based on user preferences.
    ▶ Education and training: Visualize complex concepts or create interactive learning materials.
    ▶ Accessibility: Generate audio descriptions for images to assist visually impaired individuals.
    Robotics and autonomous systems: Help robots understand and interact with the visual world.
    Gemini Pro Vision is currently available as part of Google's Vertex AI platform.Gemini Pro Vision represents a significant leap forward in AI's ability to understand and manipulate visual information. Its potential applications are vast, and it's sure to have a major impact on various industries in the years to come.
    ▶ Sponsor me on GitHub : github.com/spo...
    ▶ Join this channel to get access to perks: bit.ly/Bhavesh...
    ▶ Join the Telegram channel for regular updates: t.me/bhattbhav...
    ▶ If you like my work, you can buy me a coffee : bit.ly/BuyBhav...
    *I use affiliate links on the products that I recommend. These give me a small portion of the sales price at no cost to you. I appreciate the proceeds and they help me to improve my channel!
    ▶ Best Book for Python : amzn.to/3qYThqu
    ▶ Best Book for PyTorch & Machine Learning : amzn.to/3PyUkdy
    ▶ Best Book for Statistics : amzn.to/3vzvHEn
    ▶ Best Book for BERT: amzn.to/3lpX0fz
    ▶ Best Book for Machine Learning : amzn.to/2P6aZuT
    ▶ Best Book for Deep Learning : amzn.to/30UMTGl
    ▶ Best Intro Book for MLOps : amzn.to/3AoPZmM
    Equipments I use for recording the videos:
    ▶ 1st Laptop I use : amzn.to/3AqI8Fp
    ▶ 2nd Laptop I use : amzn.to/3KAiYsB
    ▶ Microphone : amzn.to/3qUPxtz
    ▶ Camera : amzn.to/3rKQsM2
    ▶ Mobile Phone : amzn.to/3nRHP1f
    ▶ Ring Light : amzn.to/33LedM5
    ▶ RGB Light : amzn.to/3KzLgmS
    ▶ Bag I use : amzn.to/3AsM3RZ
    If you do have any questions with what we covered in this video then feel free to ask in the comment section below & I'll do my best to answer those.
    If you enjoy these tutorials & would like to support them then the easiest way is to simply like the video & give it a thumbs up & also it's a huge help to share these videos with anyone who you think would find them useful.
    Please consider clicking the SUBSCRIBE button to be notified for future videos & thank you all for watching.
    You can find me on:
    ▶ Blog - bhattbhavesh91...
    ▶ Twitter - / _bhaveshbhatt
    ▶ GitHub - github.com/bha...
    ▶ Medium - / bhattbhavesh91
    ▶ About.me - about.me/bhatt...
    ▶ Linktree - linktr.ee/bhat...
    ▶ DEV Community - dev.to/bhattbh...
    ▶ Telegram - t.me/bhattbhav...
    #largelanguagemodels #sql

ความคิดเห็น • 12

  • @prashu25925
    @prashu25925 9 หลายเดือนก่อน +4

    Brilliant Bhavesh. Really helpful. Thanks 👍

  • @MrSoumyabrata
    @MrSoumyabrata 9 หลายเดือนก่อน

    Thank you Bhavesh for this amazing video.

  • @DhananJayShembekar
    @DhananJayShembekar 9 หลายเดือนก่อน

    Hi Bhavesh, I have been following you, great work as always, can you please also provide a example video for dataframes?
    For instance, in terms of BA , we also have excel dumps, so can we use pythons dataframe, like telling google that you;re a pandas dataframe expert or something and give it few examples just like your above video, also where can we give it knowledge about the excel file/columns in file or the data it is handling ?
    If you can tell me the approach it will really help me out.

    • @bhattbhavesh91
      @bhattbhavesh91  9 หลายเดือนก่อน

      Will upload soon

    • @DhananJayShembekar
      @DhananJayShembekar 9 หลายเดือนก่อน

      Thank you so much@@bhattbhavesh91 . Waiting for the video.

  • @igorg.8624
    @igorg.8624 6 หลายเดือนก่อน

    Has anything changed around this implementation in 2024?

  • @padalalikhithrishi
    @padalalikhithrishi 8 หลายเดือนก่อน

    Can you please also explain how this can be done using langchain libraries and syntax using gemini Ai like:
    Natural language to Sql using langchain, Gemini Ai

    • @avinashnegi9126
      @avinashnegi9126 4 หลายเดือนก่อน

      @bhattbhavesh91 Is there any answer for this?

  • @chihebnouri5541
    @chihebnouri5541 7 หลายเดือนก่อน

    can you make a video how to do that in angular?

  • @AdityaD69
    @AdityaD69 5 หลายเดือนก่อน

    Can anyone link the fashion_db.sqlite file?
    Not able to find it online