Natural Language to SQL with Google Gemma : A Comprehensive Guide

2 個月前
-
-
(基於 PinQueue 指標)
In this video, I show you how to fine-tune Google Gemma for your converting natural language question to SQL queries. Google Gemma is a family of open-source, large language models (LLMs) that are designed to be accessible and lightweight.This allows your Google Gemma model to perform much better for your business or personal use case. Give Google Gemma detailed information that it doesn't already have, make it respond in a specific tone/personality, and much more.

▶ Link to the code : https://github.com/bhattbhavesh91/google-gemma-finetuning-n2sql

▶ Features of Google Gemma :
Open-source: Anyone can access and use the code for free, which encourages research and development in the field of AI.
Lightweight: Compared to other LLMs like me, Gemma models are smaller and require fewer resources to run, making them suitable for laptops and cloud environments with limited computing power.
State-of-the-art: Despite their size, Gemma models can still perform a wide range of tasks, including text generation, translation, question answering, and code completion.
Safe and responsible: Google has taken steps to ensure that Gemma models are safe and responsible to use, including filtering out sensitive data from the training set and incorporating safeguards against misuse.

▶ Two versions of Google Gemma:
2 billion parameters: This version is ideal for users with limited resources and is still capable of performing many tasks.
7 billion parameters: This version offers better performance but requires more resources to run.

▶ Applications:
Chatbots: Gemma can be used to create chatbots that can engage in conversations with users in a natural way.
Content generation: Gemma can be used to generate different creative text formats, like poems, code, scripts, musical pieces, email, letters, etc.
Research and development: Researchers can use Gemma to experiment with new ideas and applications for LLMs.

▶ Additional resources of Google Gemma:
GitHub repository: https://github.com/google/gemma_pytorch
Google AI Blog: https://blog.google/technology/developers/gemma-open-models/
Kaggle: https://www.kaggle.com/models/google/gemma

▶ Sponsor me on GitHub : https://github.com/sponsors/bhattbhavesh91/
▶ Join this channel to get access to perks: https://bit.ly/BhaveshBhattJoin
▶ Join the Telegram channel for regular updates: https://t.me/bhattbhavesh91
▶ If you like my work, you can buy me a coffee : https://bit.ly/BuyBhaveshCoffee

▬▬▬▬▬▬ VIDEO CHAPTERS & TIMESTAMPS ▬▬▬▬▬▬
00:00 : Intro to Google Gemma
00:41 : Fine-Tuning Google Gemma for Natural Language to SQL
13:30 : Conclusion

*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 : https://amzn.to/3qYThqu
▶ Best Book for PyTorch & Machine Learning : https://amzn.to/3PyUkdy
▶ Best Book for Statistics : https://amzn.to/3vzvHEn
▶ Best Book for BERT: https://amzn.to/3lpX0fz
▶ Best Book for Machine Learning : https://amzn.to/2P6aZuT
▶ Best Book for Deep Learning : https://amzn.to/30UMTGl
▶ Best Intro Book for MLOps : https://amzn.to/3AoPZmM

Equipments I use for recording the videos:
▶ 1st Laptop I use : https://amzn.to/3AqI8Fp
▶ 2nd Laptop I use : https://amzn.to/3KAiYsB
▶ Microphone : https://amzn.to/3qUPxtz
▶ Camera : https://amzn.to/3rKQsM2
▶ Mobile Phone : https://amzn.to/3nRHP1f
▶ Ring Light : https://amzn.to/33LedM5
▶ RGB Light : https://amzn.to/3KzLgmS
▶ Bag I use : https://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 - https://bhattbhavesh91.github.io
▶ Twitter - https://twitter.com/_bhaveshbhatt
▶ GitHub - https://github.com/bhattbhavesh91
▶ Medium - https://medium.com/@bhattbhavesh91
▶ About.me - https://about.me/bhattbhavesh91
▶ Linktree - https://linktr.ee/bhattbhavesh91
▶ DEV Community - https://dev.to/bhattbhavesh91
▶ Telegram - https://t.me/bhattbhavesh91

#gemma #largelanguagemodels
-
-
(基於 PinQueue 指標)
0 則留言