End to End Gen AI Project using Google Gemini Pro | 2024

[Music] [Music] n [Music] [Music] n [Music] okay guys I hope everybody's able to hear me out can I get a quick yes just give me a thumbs up something again we are going to really have a very interesting session so we'll just wait for some time so that everybody joins perfect so let's see how many of you are live and let's see I hope just drop a message once you are live okay perfect yes yes so let's let's wait for some more time so that many people join and today also we are going to really do an very interesting and amazing project so you will have really fun with that you know so again today we are going to probably do our end to end project by using Google GMA name but today I'll also show you the deployment part that will be quite interesting okay hi hi hi everyone shria VES let's take up some questions I think from LinkedIn also people are live let me just see from LinkedIn whether you're able to see me hear me out or not just give me a second okay I I think yes we are live in Linkin also which is good great we are live in LinkedIn everywhere we can see great I've been watching your videos and it's really helpful thank you best regards from carcas Venezuela amazing that we have audience outside India also you know throughout it's worldwide good evening hamon so we'll just wait for some time so that everybody joins I don't know whether the notification are going or not just give a confirmation just a second good evening good evening evening everyone yes so yes I will talk about the agenda what we going to specifically do in this session um again just give me a confirmation if you are able to hear me loud and clear how long this session should be so it'll be for 2 hours we will try to develop a project completely from scratch okay perfect so just let me know give me a quick confirmation whether you can hear me out or not can we integrate Pond's AI library for getting the response from Custom AI let me go ahead and check this out now I've have not checked it out so once I check it I'll let you know perfect audible sir what about the others I hope everybody's able to hear me out quickly let's give me a quick confirmation the session had to be started at 8 I just came little bit early so that you if you have any specific questions we can go through that also so but we'll just start in a couple of minutes okay just give me a confirmation all right ready to go great yes we can hear you uh Divya says yes we can hear you yes you're audible perfect okay so let's give another couple of minutes and then we will start okay so again what is the entire agenda the agenda is very much simple today we are going to create an end to end project using Google giny and to I will also make sure that we'll be doing deployment what will be the project name I'll just say you in some time okay but today we are also going to play with SQL okay so the agenda I'm going to write I'll share my screen just in some time and what we are going to discuss what all things uh we are doing we'll just have a look onto that can we learn all in gen AI course which will be starting from 20th yes everything what I am probably teaching will be included in gen AI course along with more in-depth uh projects more complicated projects and uh we'll also try to show you that how we can use those okay so everything will be taught uh in that particular course now before I go ahead quickly let me go ahead and share my screen uh so I'm just going to share my screen over here see the thing is that I will probably take the entire session and then I will keep a 30 minutes discussion session where you can also join with me if you have any specific questions you can also ask okay so let me share my screen just give me a confirmation if you are able to see my screen I would write I require a quick confirmation guys come on let's see and come on hit like hit uh let's and share with all the friends right because this session is going to be really amazing I'm going to really take a lot of things in this session this one and a half hour two hour session session will be quite amazing for you okay perfect uh the screen is visible um now as you all know like uh what are we we we we specifically teach in uron so if you really want to check out all the courses in uron here is the ion. page and we have also developed the support system and this is the first real project that we have developed with the help of llms not only that this is a complete endtoend support to all the students who are specifically studying with us you know um at the end of the session I will go ahead and talk about this particular support system more what all benefits and features it specifically has okay uh if you really want to check out our bootcamp courses so gen mastering Genai courses coming from 20th Jan M machine learning boot camp is coming from 19th Feb um along with that you also have machine learning boot camp in Hindi and English both data analytics boot camp is also coming and mlops production ready data science project is also coming okay so if you really interested interested in any of this particular project or course itself you can go ahead and communicate with our team all the information regarding uh home to call everything will be given in the website itself or you just go ahead and fill the form by clicking any of this particular uh course and our team will basically contact you perfect uh now let's go ahead towards the agenda so what is the agenda of this particular session what are we specifically going to discuss right and uh what is the end to-end project that we are going to De uh develop over here so it is very simple the agenda is that we will be developing a text to SQL application or I'll say llm application now just by the name you think that text to SQL may be simple here we will be having a specific database we'll write some queries we'll insert some records and then we try to develop llm application wherein the main task of this llm application will be that take the text whatever text or prompt that you give let's say I I ask uh hey tell me tell me in this particular classroom how many students are there right so this text will be sent to the llm model and here the llm model will be Gemini Pro okay and this Germany pro model will specifically give you a query right and this query will try to execute and read from my SQL database okay so this is the entire project that we are going to do right we need to have a c database we need to have a table over there and this entire project will be buil in this specific way itself right so this text that you will be seeing this is nothing but it is a prompt okay so this will be my input prompt in English language and then this will be sent to the llm llm is nothing but our gmin pro model this will in turn convert this into a query and then with the help of SQL libraries we'll go ahead and hit the SQL database and get the response okay so this is the entire agenda of this specific project and we'll also try to see how we can actually deploy this okay so everybody clear with the agenda what you are going to do in this specific project itself yeah can I get a quick yes if you are able to hear me out I hope you are able to understand this project that we are going to do and this is going to be done by Google gini pro okay we will do the line by line coding from scratch so just give me a quick yes if you got the entire agent of the specific project yeah and we'll develop part by part so just quickly give me a quick yes guys come on come on be somewhat active you know you need to be active then only the session will be fruitful okay so I would suggest please be active and try to say yes give some symbol give some thumbs up that would be quite amazing okay perfect so let's go ahead and let's start this particular project now here how we are going to implement things right implementation part so the first step what we are going to do is that you can use any SQL database as such here I'll be suggesting to use sqlite so that we'll be able to show everything in the demo itself and this is just not restricted to sqlite or SQL database you can also do it in a no SQL database you can do it in Cassandra DB you can do it in mongod DB whatever database you specifically want second uh we'll do this setup we'll insert some records okay we'll insert some records and again this all things will do with by Python programming language okay so Python programming language will be used to do this the second thing after we implement this we will start creating our llm application and inside this llm application we'll create a simple UI where you can specifically write the query and this llm application will probably communicate with gin Pro and then it will communicate to the SQL database to give us the answer okay I've just written two steps over here so you may be thinking that this may be simple but it is not that simple you will be seeing there will be a lot many things that will probably be coming over here okay and uh uh again at the end of the day please code along with me uh see what all things we are specifically writing in this what all requirements are there you know and step by step we'll go ahead and do the implementation perfect uh so everybody has got the agenda and the implementation part so let me go ahead and open my vs code okay now for opening the vs code over here you'll be able to see the first step you know when we start any project is that what we really need to do please answer someone we really need to create a environment right now a interview question may come for you like why you specifically require environment or why do you create an environment for every project that you probably create right there's a simple fundamental in this is that every project has a different dependencies you really require different libraries over there right so that is the reason you have to create different different environment for this again create an environment I will just go ahead and open my terminal okay so this is my terminal you can also do it in Powershell you can do it in command prompt so the first prerequisite is that you really need to have Anaconda installed okay so here is my uh in this particular location I have my project so let's go ahead and quickly create my environment so go ahead and write cond create minus p v pnv python okay always remember as I said that Google gini pro works well with 3.10 right sorry greater than 3.9 version so that is the reason I'm going to use 3.10 and it is going to ask me for a not uh request saying that whether it should go ahead with the installation or not so I'll will give that preand that symbol AS why y basically means yes so let me quickly go ahead and create this so you also can parall start creating it guys okay go ahead and create it uh everybody go ahead and create the environment itself so be work along with me then you'll be able to understand everything go ahead and create the environment and let me know once the environment is created come on and hit like if each and every step you are able to work out and at the end of the day I will also give you the entire GitHub code so that you'll be able to see it okay so quickly just tell me whether you will you are able to create a new environment or not I'll wait I'll wait slowly uh like I want everybody to execute it and probably you can go along with me and you can actually execute each and every line of code along with the project okay so at the end of the day I don't want you to just see the code but also Implement along with me okay so perfect over here so nanu is along with me he's also implementing things that's great everyone come on create the environment along with me and give a quick confirmation if you are able to do it okay they are 64 people watching I want everyone of you to do it along with me come on quickly let's do this okay great so environment done okay okay sir yes yes yes okay so I hope everybody has done the first step now as usual I will go ahead and clear the screen and now what we are going to do in the next step is that here you'll be able to see my V EnV environment is created okay in this specific environment we will go ahead and start installing all the libraries so for this we need to activate the environment so I will go ahead and write cond activate VNV right so cond activate V andv I'm giving this specific folder location over here and once I execute it here you'll be able to see see that my path has changed now it is inside my VNV environment okay so this is the second step step by step we are specifically doing it so please participate in this start implementing things you know give me a confirmation it would be really great okay sir can watch this actually I could not complete ml it's okay you can also watch this the prerequisite is only python okay uh perfect so this is done which application you are using what do you mean by application I'm using a vs code so there only I'm probably writing the code itself okay perfect so done we have activated the environment now let's go ahead and create our requirement. txt requirements.txt file okay now requirement. txt what it says it it basically says that what all libraries I may specifically require you know so for this let me go ahead and write all the libraries that I'm actually going to use one is streamlet okay because we are going to create the front end with streamlet the other one is Google generative Google generative AI now this Library also we require because at the end of the day we are going to use Google gini pro the another one is python. EnV now why we require this Library so that we can load all our environment variables and as you all know that we are going to create a Google giny pro uh API and then we are going to insert that in our environment variable okay um along with this uh I think this three libraries will be more than sufficient to start with perfect okay great so this three libraries I'm going to use over here now once I have actually written all these libraries over here then what I'm going to do is that go ahead and write pip install minus r requirement. txt okay so once I go ahead and write pip install minus r requirement. txt you'll be able to see that all the installation of all these libraries will happen okay and this is actually happening in the v EnV environment so please go ahead and do this step create your requirement. txt and then after that start doing the installation and this is the basic initial step that we really need to do in every project so till here everybody's clear give me a thumbs up give me some symbols some something laughing emoji right hit like and if you have chances call all your friends in this live session okay come on this kind of sessions you'll not get it anywhere live that also I'm coding along with you live so that you understand all these things come on so great so all of the requirements for this project are free yes absolutely free you don't even have to put credit card that much free okay so uh the installation is basically happening please let me know whether the installation is done from your end or not okay and hit like come on you need to probably see the entire session and code along with me that is the main purpose of coming live you have to code along with me okay so this was one of the questions sir all of the requirements for the projects are free yes it is completely free I believe in open source so that you don't have to pay anything over there okay perfect the installation has been done we are good to go over here now great can you give me a thumbs up if the installation if you have done at least partially you have done the installation come on let me know great now we will go ahead and create ourv file now for our ENB file environment file we require Google gini pro API okay so what I will do I will quickly go ahead and go to this website which is called as maker makers suit. goole.com slapp SL API key okay I'll just change my email ID because I've created my API key in another email ID okay so go to this particular website which is called as makers suit. goole.com slapp API key okay all keys needs to be put yes so just go ahead and click on this create API key new project so this will basically create your API key for Google giny okay so go ahead and click this right once you probably click it you'll be able to see this kind that is getting created the API key I've already created it so I will go ahead and copy it from here okay so I have copied It Off from here okay so everybody are you able to do this step just let me know and if you're following let me know okay I want everyone of you to implement along with me please that is a request then this session will be fruitful okay if I keep on teaching like this if you say that no I'll do the implementation later on trust me later on nothing will happen you not be able to do it you know if you give excuses and keep on postponing things uh that will not work out you know when you have an opportunity when you're seeing this live please go ahead and Implement along with me great so can you add the link okay perfect let me go ahead add it over here let me go ahead and add from stream key okay so I am adding this link over there perfect is everybody able to see the link now yeah yes yes great now from this link you have to create your API key once this is done go to the environment variable now and now for this API key you really need to create a key itself right so how do you create a key over here so here I will keep it in the form of key value pairs so here you can see that I've used the key that is Google API key and then this is my key that I've actually copied it from there okay so please keep in this format with respect to the key value pairs okay and initially you definitely require this because if you don't have the right key your application is not going to work perfect great now this is done our environment key is set we have activated the environment we have installed all the requirements okay now let me go to my notepad now the first thing with respect to the implementation as I told you that we will take a database like cite and we'll insert some records to just show that there are some records there is a table there is a database there is there is a sqlite over there you know so that you can query you can query from those particular SQL database itself okay so for this what I'm actually going to do quickly I'll go ahead and create one file let's say this file name is sqlite dopy okay so here I'm going to write my code and this code will be responsible in inserting any records in the sqlite database okay so I'm going to close this over here and now I'm going to start writing my code and remember one thing guys over here whatever code I'm writing this is something also this will also help you to understand how we can connect python with sqlite and how we can insert records and all okay so first of all uh to start with I'm going to import sqlite so sqlite is again a lightweighted database okay sorry sqlite uh three so we are going to by default in Python 3 right you have this imported already okay now we will go ahead and connect connect to the cite database okay cite database now for this I usually write the code AS connection is equal to I will go ahead and write connection connection is equal to sqlite 3 dot connect and the I will keep a database name let's say the database name is student. DB okay so this is my database name I'm going to create my database in this specific name okay so in short what we are doing is that we connecting to this particular database so if this database does not exist okay then it is going to create this new DB okay so this is the first step the second step is that we'll create a cursor object to insert records to insert and create tables let's say to insert records or or create table because inside a database we going to create a table right so till here I hope everybody's clear what we are specifically doing because this will be a this will be another py file which will be responsible in creating your database it will also insert all the records okay so please do along with me so that you'll be able to understand perfect now what we are going to do over here is that quickly we will go ahead and create a cursor object so for this we will go ahead and write cursor cursor is equal to connection connection dot cursor so that basically means inside this particular V database connection right whatever I'm basically using this particular function this method will be responsible in traversing the entire table going through all the records and all whenever we try to insert or retrieve the records okay so this method will be responsible for doing all those things now we will we will go ahead and create the table right now with the help of this cursor object we will try to create the table now here will be my table info let me go ahead and create my table info and I will say this will be three columns okay and let me start writing my query name so here I will say create table student I'll try to write it in capital letter and inside this I will use first first parameter or first uh variable right name and here I'm going to use this as we care and let me go ahead and write to 25 character so that basically means name is a field okay and in that it supports variable character you can write numbers integers uh values string anything that you specifically want to write so this will be my first First Column you can basically say in that way in that particular table second one is let's say I go ahead and uh go ahead and write something called called as class okay so I'm writing the student information in which class he or she may study um and this class will also be a v care and inside this I will go ahead and write this will be my two two 25 characters okay and the third parameter I'm going to specifically use is something called as let's say I'm going to write this as section so this will basically be my section and here also I'm going to use my Vare and this will also be 25 character so once we do this we will close this entire command that the query that we specifically have so simple query initially we'll just go with simple one so that you'll be able to understand it so sqlite 3 wasn't in requirement file Yeah by default with Python 3.10 sqlite 3 comes installed so this is going to work okay I've already tried it out fine we have done the table info over here and you'll also be able to see that now what I'm going to do is that I'm going to create this specific table okay so for creating this specific table I will go ahead and write cursor dot execute table okay so this this table info cursor. execute so as soon as this line gets executed this table is going to get created with the name of student okay perfect now we will go ahead and insert some more records okay now for inserting this records how do you write an insert statement so here I will go ahead and write cursor. execute okay and let me go ahead and create this multi-line commment and let me say that what is the command I will say insert into students student or student student value values insert into student values inser into student values and the values will be the three parameters that I'm going to give name class and section okay so here I'm going to use the name as crish then let's say the section of the class that he's probably studying is data science okay and over here you'll be able to see I'm also going to use a section let's say section is a okay so this three information you'll be able to see as soon as I execute this will basically be inserting this record in the data science like with this information the name the class and the section okay so I will copy this entirely so this will be my first record second record third record fourth record five records let's let's go ahead and see with respect to five records okay here I will change keep on changing the data right now when I say I'll keep on changing changing the data that basically means I'm going to use my second record as let's say I here I will write sudhansu okay Sanu data science and I will say this belongs to section B okay uh let's go ahead and write more over here let me go ahead and write Darius so Darius is also in data science and let's say he's also in section A okay I will go ahead and write one more record because let's say because is in another section which is called as devops and this is section A and let me go ahead and one more record like the I will go ahead and write the and this time I will keep the also in devops okay and let let it be in section name so this information I am probably inserting in this specific table okay all this information will be basically inserted in the specific table now as soon as it is inserted we will display all the records okay here I will say print the inserted records are okay and let me go ahead and write data is equal to cursor do execute okay and let me go ahead and write this triple code statement so that it can be multi also select star from student okay the table name is capital so once I probably execute this I will have all the information over here in the data and then what I will do I will write for Row in for for Row in data I will go ahead and print my row okay so this is what we are going to do so this becomes my entire query with the help of Python programming language where where I am creating a database I'm creating a table I'm executing this particular table info I am inserting records I'm displaying all the records everybody clear with this can you get me can you tell me whether you able to understand till here quickly come on let me know till then I'll drink some water yeah everyone come on quickly yes or no sudano says yes Prashant says yes what about others come on guys you are not implementing is sad you know so if you do not show interest then there will be no use of doing this live session right div also says yes what about others 84 people are watching please do hit like let's make it a target of at least 100 likes in this session you know because if this session we teach in some batch you know it'll be so fruitful for us come on we are doing this completely for free for the entire Community you really need to show some proactive measures okay either be active otherwise drop off if you feel that this is not important for you okay done perfect now let me go ahead and open the terminal and now this time what I will do I will execute this file and let's see once we execute this particular file that basically means uh we will be able to see our database that is created okay database that is created so in order to execute this file I will go ahead and write python sqlite dopy okay so if I execute this my database should get created my table should get created and at the end of the day so here you'll be able to see right at the end of the day One DB file should be created over here and the name should be student. DB okay so let's see whether we'll be getting any error or it'll just execute perfect the inserted records are chis data science a sudu data science B Darius data science a v devops a the devops a so student. DB file is also created that basically means my insertion has happened perfectly well right now all the data has been inserted into my DB and this is the student. DB file that you'll be able to see now now this completes our sqlite insert some records Python Programming this completes our first step now in the second step we will try to create an llm application and now the same DB see that DB is already created now what my llm application should be able to do is that whenever I give some English text it should be able to retrieve the records from those database you may be thinking how that will be possible I will just show you just stay along with me and code along with me right step by step I will show you each and everything okay so just be along with me and just stay over here right so let me go back to my code and now I will start writing my code with respect to this uh in my SQL py file now this file will be responsible and again I'm repeating this file will be responsible for creating our llm application okay so let me go ahead and write first of all we will go ahead and import from EnV import load uncore Dov Dov okay and then to load all the environment variables I will go ahead and write like this and let me go ahead and write take environment or or load all the environment variables okay okay and that is the reason we have also installed those now the next thing is that we will go ahead and import streamlit as St we are going to import streamlit I'm going to import OS I'm going to import OS along with this I'm also going to import cite 3 okay site 3 because we are going to specifically use this again and then I will go ahead and import from Google do generative AI import gen okay so I'm going to use this gen and as usual first step is to set our API key so in order to sorry import as okay as J now in my next step what we are going to do is that we going to configure so here I'm going to write configure gen AI key okay so for this I will write gen do configure and here I'm going to specifically use my API key so here I will go ahead and write my API key is equal to os. get EnV os. get EnV and here I'm going to give my key name okay so whatever is the key name and you know that my key name I've kept it as Google API key okay perfect everybody clear till here are you following everyone come on let me know whether you're following each and every step yes yes or no so till here I have set up the environment variable okay now is the main thing that we will start our coding with so if hit like if you're able to understand till here and and uh you're able to follow each and everything with respect to sqlite SQL everything that we have actually created okay perfect now let me go ahead and show you the next step what we are going to do over here now okay now we'll try to create a function function to load gen AI generative AI model or Google gin model Google gin model okay now one thing that you really need to understand two information will definitely go in this function right The Prompt that we are specifically giving and what the Google gin model needs to behave like right so over here I will create a function and I'll say getor Gore response and inside this response I will give my question and prompt like what what the Gin pro model needs to behave like okay this prompt we will be writing question is the input that we are giving let's say if I go ahead and ask hey how many people are there in the data science batch right let's say something like this so let me go ahead and create model is equal to gen do generative model so this will be my model now understand one thing over here we going to use gin Pro we are not going to use gini Pro Vision gini Pro is for text gini Pro Vision is for uh images video frames and all so here I'm going to specifically use Jin Pro and then let me go ahead and create my response my response will basically say model dot generate content and now this is the most important thing I need to give two information to this right the first is that what the model should act like so for that I will go ahead and create my prompt I'll give the first parameter as prompt and this will go in the form of a list so prompt the second thing that I'm going to probably give is my question okay now I can also give multiple prompts if I want okay that also I will try to show you like how multiple prompts can also be given okay so this is what my model is basically giv so I will go ahead and write return response dot response. text okay so here this entire information so this model will be responsible in giving the query okay let's say if I say that hey how many people studies in the data science batch or data science class so this entire function will be responsible in giving you the query so function to load Google JY model and provide queries okay as response so this is the function that it is going to do understand one thing right because first when we hit when we write any input our llm model should be able to generate the query and then that query will get go and hit to the sqlite database where you get this response right so I hope everybody is able to hear till here right so guys there is no such prerequisite for Google gin Pro you really need to know Python programming language and you should know how API is basically used over here right so can I get a quick yes if you able to understand till here and why I have created this specific function okay just give give me a go ahead and please keep on hitting like at least we'll try to make it 100 in the live session itself and understand at the end we are also going to have some live discussion you can come and ask me questions by voice and I'll be happy to provide a response to you okay now this is what we have done now second function that we are going to create function to retrieve query from the database okay okay so this is what we going to do in the second function so for this let me go ahead and Define my function so here I will write definition read SQL query okay the first parameter will be SQL right whatever SQL query this model gets create this model provides a response as and the second parameter will be my DB name right whatever DB that I have now if you really want to convert this into a real world scenario we can just make sure that we can put our databases in the cloud and how to read it and all already so many videos has been created both in my YouTube channel and in Iron Channel also so you can probably go ahead and watch in that specific way but here the main idea is to integrate multiple tools and show you how powerful an llm application can be with the help of Google gini pro now this next thing will be that I will try to create a connection so sqlite 3 dot connect I will write and this connect will will be with respect to my DB okay and then I will go ahead and create my cursor so let me go ahead and write con. execute sorry con do cursor I will try to create my cursor now this cursor will be responsible in executing our query right now what query the SQL query right and once I get all the results once I execute this uh uh you know the SQL query inside this itself C dot if I do fetch all it is going to fetch all the records with respect to that right so this is the prerequisite that you really need to know a brief idea about how you can work with SQL databases and this will basically be my rows okay I will get all the rows over here now to retrieve or print the rows what I can do I can write for Row in rows I can print the rows so that you can also see the rows over here what all records are uh generated okay um the next thing what I'm actually going to do is that return all the rows okay return all the rows perfect everybody clear with this yeah yes so this is the function which will be retrieving the query from the database so whenever I give a SQL so in short what is happening the output query that is getting generated by this model it will get sent to the database and from this database we will get the records okay so this is done now this is my function that is got created right now now the next step what we are going to do is that do our setup of a streamlet app now before doing our stre setup with respect to the streamlet app this will be the most important step that is defining your prompt so now we are going to Define your prompt now this prompt because of this prompt this entire application will work so efficiently trust me in that it will work very much efficiently right now what is the specific prompt that I'm going to create and as I said I can create multiple prompts so I will give it in the form of list okay so my first prompt let me go ahead and use triple quotes because it will be a multiple prompt itself okay I'm going to copy and paste one important prompt that I have written over here now this is the main game of the prompt guys without this you won't be able to write or you won't be able to make the llm work in a better way so here what is this prompt all about see you are an expert in converting English question to SQL code or I can also write SQL query okay converting a English text also you can write question also you can write to SQL query the SQL database has the name student and following columns name class and section for example example one how many entries of records are present the SQL command will be something like select count star from student right similarly I can go ahead and write example two let's say I go ahead and write example two so this this is just one query understand one thing guys this is just one query right I can write like this multiple queries so this this is my example one okay let's say I copy this in the similar way and I go ahead paste it over here okay let's go ahead and write example two you can write many number of examples as such uh let's say how many how many people how many students study study in data science class if this is the query if this is my English statement query tell me what will be the command select count star from students or let me just change this okay tell me all the students studying in the data science class right so in this case what will be my query my query will be select star from student where class is equal to where class is equal to data science data science I have written it in small right where class is equal to data science so I will go ahead and write it over here okay so this becomes my query right and we will end this query also like how we have end it over here right like a colon something like this so this is also ending in this way right so now I hope everybody will be able to understand this yes you are getting it right and after this I'm also saying also the code SQL code should not have this kind of in the beginning at all I've given some more additional statement for the clean one okay does this make sense everyone yeah so this basically is your prompt okay and let me paste it over here so that you can also work accordingly with me so this is the entire prompt see okay this this entire prompt has been divided into multiple sections okay just see to this okay but this is how things are I will give you some time go ahead and write this okay go ahead and write this because this will be the magic this is the most magical thing right and that is how you will be able to see that how powerful this LM models are right so here you can see you are an expert in converting English questions to text or English text to SQL query the SQL database has the name student and has the following columns name class section for example this how many entries of records are present the SQL command will be something like select count star from student example two here you can specifically use in this particular way right clear everyone okay you want it in code share I will also do it in code share just a let me see whether I'll be able to see in code share or not but don't change the prompt okay and don't delete the prompt once I probably share it okay share so I will share the link everybody can copy it from there okay everybody got it in the code share yeah so in that code share I have given this entire thing you just can copy it from there and uh start seeing it okay clear everyone can I get a quick yes because this will be the most important step creating your own prompt right so please do hit like till here if you are able to understand each and everything trust me this is a amazing application by this you will get multiple ideas multiple ideas trust me in this okay so this becomes my prompt now the next step obviously the next step is basically to set up our streamlit app so let's start our stream late app and understand this prompt will tell Google JY how it needs to add okay so first of all I will go ahead and create my st. Sate page page config and here I'm going to give my page title as text or I can say I can retrieve any SQL query okay so this will basically be my P page config and then I will go ahead and write s. header gin app to retrieve SQL data okay now I've given some examples guys see this prompt you can take it to any extend even write complicated queries you know once I probably show you the result you'll be able to understand why I'm seeing like this okay now I will create a text box which will probably take the question from my side so here I will write question is equal to st. textor input and this will basically be my input let's go ahead and Define my input and key I'm going to write it as input okay we can basically write any key according to you then we will go ahead and create a submit button only two things we specifically required submit button and let me go ahead and write St do button and here I can basically write ask ask the question done now if submit is clicked so I'm I'm using one field a text box and I'm specifically using one I'm using one text field text field and I'm using one submit okay perfect everyone yeah everybody good enough everybody can I get a quick yes if you're following everyone okay perfect simple now if some MIT is clicked I will go ahead and do all the activities that I specifically want okay great so let's go ahead and see the next step now in the next step if submit is clicked I will write if submit I will go ahead and write response is equal to get Gemini response and here I'm going to give my question comma prompt right now question comma prompt if I give this prompt is in the form of list so when I'm going over here I will just make this as prompt of zero the first prompt that I specifically want to give you can also give multiple prompts and by that you can give in that specific way let's say I have three buttons in the first button I want to behave it in a different prompt in the second button I want to probably behave it in a different prompt so here I'll write prompt of zero okay once I get the response I will say St do subheader the response is okay and then I will write for Row in response print row I'll print all the rows okay and if it is printing in my field let's say I will go ahead and write something like this St dot header and I will display all the row elements over here done guys almost done now it's it's like whether this will work or not we need to check if it does not work we need to play with this prompt okay remaining all code you know see first step is probably taking with respect to get gini response based on question and prompt it will generate a SQL query and that same SQL query uh what will basically happen over here so question and prompt response what I'll get over here just a second I think um get gini response generate content and then I have to probably go ahead and read my SQL query okay so just give me a second wait wait wait wait wait wait I will get the response and I have to probably call this read SQL query because here it is not getting called so I'll go ahead and write my response read SQL query now inside this SQL query I'll give my SQL whatever SQL response I'm getting over here comma whatever is my DB name my DB name is basically what student. DB student. D perfect now I should be able to get the response I guess does this look good everyone yep everyone second is the response it response now let's see whether it will run or not DB is student. DB perfect now is clear I guess response is also there this response it will go over here and does done now let me go ahead and run it and I hope so it runs absolutely fine if it does not run we'll try to debug okay so in order to run it I will write streamlet run SQL py so this will run let's see now here is the thing let me go ahead and write a requ uh tell me the student name and data science class let's see I will go ahead and ask this question as you all know how many students are there over here in this particular class 1 2 3 so Krish Sanu and Darius right so let me go ahead and execute this I hope so it works so I'm not getting the response so this is not good oh something is happening oh I did not receive anything why let me execute this once so the cursor did I execute SQL dopy so sorry it should be SQL py now just a second no it was working fine I guess let me see once again but last time we did not get anything tell me the student name in the data science class if this is not getting executed there should be okay operational where syntax the problem is coming let's see what kind of query it has generated let me print the query also print print print print the response okay I will go ahead and print the response let's see whether we are getting any error or we need to change okay so I'm just doing some kind of debugging guys so please be with me okay we will try to run this select the name of the student where class is equal to data science this looks perfectly fine select name from student name from student where class is equal to data science this looks fine when I'm executing this DB this DB is there student. DB response I'm giving it over here fetch all okay this is coming as an error let me see why this error is coming execute SQL current dot con. cursor SQL there's some error with the retrieving the query just a second guys connect DB DB name is this one let me see one second let me debug this the query is generated correctly when we hitting this particular database it is not working let me see test.py okay SQL py import sqlite 3 and I'm going to use this command let's see it will work or not cursor. execute select star from student let's see DB name is student. DB come on so some error in executing this let me open my terminal let's see whether this will get executed or not Python and once I execute this I will just go ahead and write this three records we'll just go ahead and print this records let's see python test.py from nothing is getting printed white is not getting printed now it should work let's see still not getting printed but it is getting executed select star from student but this record should be visible just a second I will just delete this once and let me go ahead and write python sqlite dop y the record is done student. DB oh student student student I'll close this requirement try printing line number five line number five oh this is fine now let me go ahead and write test.py still it is not getting printed that basically means is not able to read this why print rows let's try this also just a second rows are coming as empty why student. DB is there I could see over here the insert statement has happened happened and is displaying all the records okay why it is coming as null select star from student is done while I'm reading what is the mistake over here select start from student I'll I'll try to fix it guys just give me a second soel let start from student c [Music] table let's see no nothing is coming where did my database go select star from student is my student spelling wrong or what student we need to welcome this guy and this helps us to the opportunity line by line yes student just just a second guys let's fix this issue oh I feel there is one problem over here let me delete this once okay working for godam says working for me student. DB I will delete this let me create another DB over here wait I will go ahead and write test. DB let's [Music] see SQL py this is done now if I go ahead and execute test.py let's see python test. py okay sorry so this should be test. DB no it is not able to read why object is coming so some major error in connection. commit is that so oh is the cursor not closed so that I'm getting the problem I'll do one thing I'll commit the connection so print row and I will say okay I got a problem what was that commit your changes in the database con. commit so here I have created my connection connection. commit now along with this I will also say CN Dot connection. close now I think it'll work so let me go ahead and delete this let me go ahead and delete this now I will go ahead and change my name to student now I think it should work I think I did not close the connection that is the main reason equal it. py so this is done student. DB is created now let me go ahead and write streamlit streamlit SQL py no I think it should work work definitely it should work tell me the students tell me all the students name from data science class let's go ahead and ask the question now let's see where is Right 29th still I do not get the response now this is here also I have to probably close the connection I guess so let's close the connection here also so I did not close the skite connection at the end Connection cursor. close Okay cursor is over here we don't have to close the cursor connection if it is closed I think it is sufficient anybody prompt is giving the response from stimulate app this work for me read the S rows can for rows in print rows return rows so the same function I think I've written over here for Row in rows return rows so you have not closed the connection now I've closed the connection I think now I think you should not have that issue anybody's facing this issue still now once I close the connection I have my student DB in my SQL I'm giving my student. DB cursor connection CS CS csor cursor c c c for reading I don't have to probably do anything as such so this work for me yes so still say data science Capital no no the query is getting created perfectly the problem is in this read SQL query I don't think so I need to write this but I'm just trying it out let's see sqlite May commit and close is done this is also done no no I have the data no so data is getting printed over here see so this was the data that was got printed right let's see once again rerun oh now finally now I get the response see so I just did this I just go ahead and write it okay so I have to close the connection over here also okay so now you can see Krish sudhansu and Darius is visible minor mistake I can understand but again a good error to fix tomorrow if you get any error over here you can probably check it out okay everybody got this yeah all happy enough tell me any more queries tell me tell me the class where sudano let's say I'll say tell me Tell me sudu I written his full name or not I think I've written just his single name right SQL ppy sqlite okay tell me sudano's class tell me Sano section let's say if I write like this ask the question see the b b section is coming over here and the best thing will be that you'll also be able to see what what query it is generating select section from student where name is equal to sudhansu right and here you can probably clearly see right this is this is really really nice right so let's see what CL tell me the class of vikas and dpes whether it'll be able to write this queries also or not we'll see devops tell me the class of vikas and dpes devops deop see now how many queries see select class from student where name in vikash and thees so this is good right see this kind of queries also it is able to generate now the more amazing we basically write in the prompt template right in the prompt more complex saries we specifically write and here you can probably see vas and thees was in devops right tell me the student name from section A Krish Darius vikas Dees everybody sudans is missing so sudu is another section I guess see sudu is in B section so did you like this project guys everyone so if you liked it please do make sure that you hit like and uh yeah between there was some challenges because I did not close the connection okay it is good to close this specific connection okay uh so close this connection make sure that you close this connection okay otherwise you'll get an error because see if you don't close this connection right the DB will be open right and uh there you'll not be able to do it now the most amazing thing is about how you write this prompt in a better way you can check with Google B you can check with different different ways you know whenever you write a query you'll be able to and this definitely works for advanced advanced SQL queries Also let's say if there are two tables and all you can also probably write it over there tell me any query any complicated query that you feel that we can write and try it out [Music] um tell me all students who are from class data science who are from section A and B let me go ahead and write in this way from section A and B I think this should this should be an easy one itself I don't think so it'll be the response is chis sansu darus vikas dipes okay let's say if I probably go ahead and write one more column name like marks I can still write more complicated text over here right let's see okay fine marks also will do it okay so I will go ahead and create one more one more marks and this will basically be int and what I will do I will just go ahead and create this once again so let's say marks will be over here as 90 100 uh darus I will write it as 86 because I will go ahead and say 50 the I will go ahead and say 35 okay so I will use this all and now let's see whether this will work I will delete this database contrl C python site. py so the database is created now let's go ahead and run my SQL query so streamlet run SQL py now tell me what sentence should I ask tell me all the students name who marks marks is greater than 9 so if I ask this query will it work sudhansu see sudhansu it is basically showing so let's go ahead and see the query greater than 90 how much I have got 90 see greater than or equal to 90 if I had send then my name should also come right if I say greater than 80 uh there is one question hello from the generative AI course starting next week how often will the doubt section be checked I noticed the community version has not respond to often see right now we have come up with an amazing support uh system so every day within 24 hours you'll be able to get the response okay every day within 24 hours you'll be able to get the response so guys this is amazing right happy now you write any comp ated query just give some examples over here right so Kish sudans and Darius is having greater than 80 if I probably go and see what is the query that is generated here you can probably see select or I I I'll I'll just do something okay greater than greater than or equal to 90 and less than 50 let's see whether this this query is also possible or not okay here now the problem is because we have not given those kind of scenarios I don't know what select name from student where Marx is greater than or equal to 90 and Marx is less than 15 this is good but the but the column name is what let's see the column name marks I think this should have got executed oops select name from student where marks is greater than and marks is less than 50 okay both the condition is not getting matched huh less than 50 we had one right thees okay please ask to give rank on basis of marks tell me tell me let me do one thing Max is greater than or equal to equal to 90 greater than or equal to 90 greater than less than 50 okay and uh less than so I have written the condition in a way that I have to reverse this okay till let's try this one tell me the student rank tell me the student name based on Marx rank let's see I try like this something like this again you you can try multiple things so see sudhansu Krish Darius vikas and dipes this is nice let's see the query select name from student order by [Music] marks so previous condition I say tell me the student name where Marx is lesser than 90 and greater than 50 see darus is there okay if I say Marx is greater than 90 or lesser than 50 let's try this also so danu should come and thees should come Perfect all good everyone tell me students having marks greater than also tell me the number okay yeah you can write this fetch me the topper of all the classes fetch me the topper of all classes see section B Sudan is the topper vikash why it is showing devops a branch yeah uh fetch me okay one more give me the third highest rank by sudano let's say give me the third highest rank third highest rank marks usually this is an interview question okay there is an error let's see what it has generated operational error mhm first I'll print the response wait over here some error has come over here so uh print response get Gin response select name from name section marks over by as marks from table as table where rank is equal to three so this is the problem guys right so let me write it in a better way give me the third highest rank give me the name give me the student name of third of third highest Mark something like this darus right so here you can probably see Darius is coming now so this way so we also have to write prompt in a better way right so here you can see select name from student order by class limit 2 comma 1 so Q song says one more way of writing this query tell me how about tell me who is the third best student on marks darus perfect so this is working really good oh my God this this is nice people are creative in writing prompts okay so this is can you provide a list of student categorized as first class if their marks are greater than 60 and categorized as second class if the marks are between 50 and 60 so let's ask this question first class Kish first class sudu first class Darius let's see the qu query the query is quite complicated in this so here oh big nested quer is there select case where marks is greater than first class then marks is between 50 to 60 second class else null nice see the output is coming up try to run the rank with the table name uh so should give the query give the prompt it'll be better but this is nice guys see this so complicated query it is being able to give the marks over here will this replace human why it is going to replace human see have first class first class first class vas is second class give me the second second okay give me the give me the second last rank student name from student table so danu second last rank second last rank it should be select name from student right is giving error let's see if it's let's run this give me the second last rank student name from student table near offsets I think some error is coming over here let's see now it is getting complicated writing so this query may not work select name from student Group by null order by count so this makes me feel I'm learning SQL for three months okay perfect anything other than this you want to try everyone so hit like if you like this video and tell me how was it did you enjoy shall we do the deployment for this everyone wants to do the deployment so let's go to hugging face okay go to spaces and create a new space just let's go ahead and write text to SQL generative AI generative AI okay text to SQL generative AI license you can probably use Apache License streamlet I'm going to use and this provides you uh CPU basic uh 2 CPU 16GB free public and all I will go ahead and create the space now for this what you really need to do is that I will close this till then I will close this I will rename this particular file SQL to app.py app.py oops okay I'm just going to rename it because this takes app.py and requirement. txt is there okay I will go ahead and open in the reveal in the file explorer and I will go ahead and create this space please match the requirement okay text to SQL okay go ahead and uh what is happening no spacer text to see equal generative AI let's create this space now after creating this space what we can specifically do so this is the space that has got created I will go to the files and here is my entire file so I will go ahead and upload this three files student DB this this this okay so I will go ahead and add upload files and probably drag and drop these three files okay so this is dragged and drop I will go ahead and commit the changes to the main so here it is now you just go to the app it will start running it internally creates a Docker the deployment of this llm app will be very simple uh the DB is there obviously in the real term scenario we have databases in some Cloud so when we are using Docker we have to probably give the IP address and all okay so here you can probably see that everything is happening in front of you the installation of requirement txt and all so let's continue this very simple so guys overall everything is good did you enjoy the session yeah so application startup let's see if everything works fine this is getting builded once this building will be happening and you can probably execute it okay I hope it was fun okay now we'll have a doubt clearing as soon as this application works all good the streamlit app is running might is not running let's see so here it is now just let's go ahead and write the query what query was that last I had written okay everybody was giving so many different different queries right so we'll run one of the query let's run the more complicated query okay can you provide a list of student categorized In First Class second class and all I think this should work absolutely fine oh one thing is remaining this will not work I have to go ahead and put my API key okay so if you go down in the settings so just click on settings over here and there will be something called as Secrets right so I will go ahead and create a new secret my secret key name will be Google API key I will copy this paste it over here and we will go ahead and paste this also over here the value and I will remove the quotes save it okay this is done now let's go back to my app now again it'll build and again it'll do all the installation again as soon as I probably do each and everything that is required okay so now this is my input okay now I'll paste it over here oh not this what I was pasting I will paste this query so this is the thing can you provide a list of students categorized as first class so I will go ahead and ask this question it should be able to give me the response okay your default credential were not found to set up default credential this is the why this is not working let's see it should work my settings is there and Google API _ key save it over here let's see again let's see whether it will work or not till then uh my team will provide a link in the chat section if you want to join and ask any queries that you have you can specifically ask me okay so Prashant you can share the link in the chat okay okay perfect guys it's running so it's running in the hugging phas as I said in order to set up the secret key just go over here down there will be something called as secrets and variable create a new secret write the Google API key and write the value over there that's it okay and here is the entire app it is working absolutely fine okay perfect everybody yes yes yes yes yes yes yes yes or no please make sure that you write the quote over there okay okay guys so please join with me in the session and I will allow you to ask any queries if you have but I hope you like this session all together guys yes or no so if you specifically want the code uh the GitHub link I will provide you the GitHub link of the code over here okay so go ahead and join the link guys if you have any question if you want to ask me anything and regarding all the paid courses in nuron you can probably see the description of this particular video so we are coming up with Gen AI course mastering generative AI machine learning bootcamp uh in both in English and Hindi we are coming also with data analytics boot camp and mlops production ready data science project everything is basically coming up you can probably check in the description of this particular video check out the course and if you are interested right because this kind of projects what I have actually discussed right now this is still I will say basic to intermediate we'll still discuss more advanced project when we are doing in the course itself okay so yes this was it so how did you like the session first of all was it good bad yeah yeah Vishnu Khan please go ahead with your question mishuk Kant can you hear me unmute yourself vishant Vishnu Kant if you have any questions you can ask me okay what about next people who want to join hi sir am I audible to you yeah tell me sir my question is that how to fix that response error which you have fixed I was trying to fix that still it's not showing the response response ER first of all see whether your SQL quer is getting generated or not is it getting generated no sir then I would suggest just check the GitHub link that I've actually sent with the code okay try to run that code once okay okay I've sent you the GitHub link so this is the GitHub code that we have okay so just try to run this I will try to edit this over here itself in front of you sure whatever things we have run everything I'm going to put it over here okay uh SQL light. py so this will basically be my insertion database I will commit this up I'll commit this changes and uh in SQL py I will go ahead and use this code that uh I have written app.py okay so you can go ahead and check it out okay sure sir yes please next question yes jbin AI will be able to generate images yes it will be we have discussed about that in the last session yes the session was informative live coding session helps us to understand in a better way I would appreciate if you could continue adding more interview questions and answering videos sure I'll do that any more question guys if you want to probably join please make sure that you join the link that is given by our team okay if you want to talk with me if you have anything as such you have to go to this link and you can join it along with me okay yes any more questions guys just go ahead and ask very good everything is fine so please create one more session for generative AI images okay fine I will try to create that in my next session we'll try to create a health management app okay and then we will work on that sir please can you tell generative AI is an job oriented course yes obviously whatever things are people are using in the industry that same thing we are teaching in the course okay is jini better than chat GPT I would still suggest I'll still suggest that many people we cannot just come to a conclusion right now okay we cannot come to a conclusion right now with respect to that but when the High Advanced model will come then we can probably see so guys use the link that is probably given over here we have put that in the comment section you can join directly to my streamyard and here I will allow you to probably talk with me and if you have any questions we can discuss please go ahead join the streamyard link and if you have any question you can ask me as said right what are the timings of the generative AI course so if you probably see over here if you click this link the timing is given 10 10:00 a.m. to 1: p.m. IST okay every Saturday and Sunday this course will go for five months yeah Sati please uh tell me your question uh sir great talking with you uh I enrolled for G course uh for python uh actually as a beginner I just know till oops Concepts not much in data structures and uh uh much more advanced concepts uh even I'm not a developer I am from uh non-developer background and just doing some uh like manual testing and all uh will that help me this gen course can land me other than testing uh jobs just want to know yes ma'am so the thing is that the more first of all the prerequisite in our course is Python programming language so that is the reason we have given already recorded videos also in our curriculum okay the more you go become better in Python programming language the more better courses you'll be able to I mean the more better projects you'll be able to develop okay so I would suggest still focus more on Python and then probably start learning all these things and how to create uh entire llm application which you need to focus in the class after that try to do some internships try try to do try to see in in your work can you do something something related to that you know all those things will matter okay actually actually I enroll for this course because I don't want to be in testing domain anymore so uh if even if I am not a developer uh can I get some hands if I get handson in this project can I switch my from domain from testing to any other yes ma'am but again you need to follow some steps over there you know do multiple projects see currently in testing also many things can be used llm task can be used that is what I'm trying to say you know so if you're able to use this that experience you'll try to put in your resume okay if you're already working that is what I meant but yes definitely there is an opportunity with respect to that okay if I if I am not able to understand how to put this knowledge in testing can uh get get can I get mentorship from Team uh so that I can can implement this in the classroom we'll discuss of those kind of use cases see right now I did I I'm not a let's say I'm not a good SQL Developer but still I'm able to write queries right yes sir from this application you saw right now in testing also you you have you do manual testing you do automated testing right yes so in that also you can do something with respect to that there are lot of different different things which you can specifically do with these llm models okay sure sir sure daily I will be waiting for your videos okay today Chris will be giving new video on which topic I'm curiously every day waiting for your videos your videos are so great and helpful thank you ma'am thank you thanks this here yeah hi mju yeah so what I'm looking for is like uh I required uh company oriented realtime projects for computer vision and large language which you already teaching but I I'm looking for a projects which are on uh computer vision uh thing so will your team will be helping on that already already in our data science uh full stack data science batch we are already doing all those things end to endend projects that are related to computer vision and if I want to get only the related to project because I know all the things which is required prequest for data sence I know all the stuffs in that so now I only want the prodject so so so so sir I I'll tell you what we have come up with okay so are you able to see my screen yeah yes I can see now here you are able to see my screen right so in I neuron right we have something called as one neuron okay now inside this one neuron we are creating this data science project neuron right so here you'll be able to see computer vision set of projects MH right so this this entire neuron is specific to projects only right here we are not teaching anything from scratch but in instead focusing on solving projects and these are like end to endend projects with deployment okay okay okay so just go to one neuron and there is a data science project neuron sir oh okay Kish yeah thank you for that yes yeah more question guys I think mju had asked right right now hello yes yes mju okay any more question mju yeah but seriously one thing I want to tell you man you you are amazing honestly speaking like you are making the things like you know anybody can pick up things and become a know any any from any background and they can become a programmer and move to the career transitions so the way you are doing the way you are teaching is you know you are reaching to the worldwide you are not limited to India like across the world people are recognizing you that that is a level but you need need to give one motivation speech like how you came from a know you are from Karnataka from Karnataka but so how you grown up how you made yourself know that one kind of know motivation video you have to give like how you build your know profile to to this level like to you can reach out to the world that is really amazing I'm very proud that you are from my state thank you thank you Manju definitely we'll do a specific meet up where in our closed audience specific office in Bangalore or anything yeah yeah so in Bangalore we have office so it's near uh this brigade and we our building name is Brigade signature Tower oh okay okay yes try to come up see at the end of the day U again the main Vision over here is to democratize AI education you know uh the way that we are selling courses because this courses adds values right uh it helps you to get jobs it helps you to make Transition you joined multiple other I spent a lot of money on learning but I see always I get a very small like you always do in the jupyter notebook know jupyter notebook thing is a outdated stuff like where you cannot use it in the company now we are moving to the you need to build an app company is looking for that because I'm I'm working on that I'm already in the industry I have a 10 plus years experience and I'm using it because you need to need to build a app end to end so that is what industry is looking so there your you stand out from rest of the crowd which you are teaching so that is really amazing continue to do that see we are already coming from that background you know so we know see my total years of experience if I say it is somewhere around 13 to 14 years okay and uh if I talk about I we started at 2019 right so that till that experience we were already 8 to nine years experience specifically me now I know like what things are required in the company working in company getting into a company transition making a transition in the company what in a project what what skill sets you specifically require right so hardly you'll be seeing any Jupiter notebook session but instead we focus on creating an end to end project or a module you know which will be very much applicable in the sessions but thank you for your uh amazing words that you have actually said uh yeah this is really Heartfield you know because I I hear from the people who are in us and Australia different countries right they they speak they watch your videos that's know from such a background like where you are reaching today that is really amazing it's it's inspiration for everyone you know thank you thank you Manu again at the end of the day I need to add values in others life and that is what we our team in I neuron are doing with the same vision we are working on thank you uh hello yeah yes sh yes sir actually uh so what we are doing is generally uh we are fine tuning the llm and based upon our own data set and we are getting that as some text okay so is it possible to integrate the uh you know so panda a so to get that plots uh sir I will just have a look onto the Panda's AI i' I've kept a point over here first let me explore that you know so once I probably explore that then I can definitely come with that thing okay so first of all let me explore because I've never explored that Panda's AI okay it is kind of yeah sure sure thank you yeah yeah good evening next question sir can you yeah sir can you create some Transformer projects you explain the two hours Transformer right how it is going on attention can you create some projects sir so I seen your YouTube channel I I'll uh llm and lstm projects is not there in your playlist uh can you create some projects within two weeks I mean or else this month sure sir sure definitely I'll do that sir sir you are creating the so many projects right can I can I do that projects to I mean fin year projects like finally year projects yeah yeah you can do it you can do I mean how to uh sir in my laptop you said that K python version 3.10 right K is not available in your laptop it you have to install you have to install sir I install on but you have not you may have not set the path that may be the problem the default path will be there that you have not can I use can I can I so without see if you try to do without K it is possible by using pip but again there will be a lot of clashes within your environments it will not be at one specific place you know where all the tracking of those environment is done so it is a good idea available in your YouTube channel sir actually I did not seen this actually I did not seen this live uh you upload one video on the morning right I seen that 2 hours video uh I follow your YouTube channel very much as compared to this uh can I uh downloading that uh K it is there in your YouTube channel yeah it is there but don't worry I may also create another video where you can directly use Python and create an environment okay okay can I see the okay I'm not created yet I'll create those videos I'm saying yeah no sir due to this I struck in the in only sir I entire thing I writing the notes because I stuck there when I stuck there I did not come the interest to go further so I writing the notes so that's why I'm asking that doubt okay don't worry see it's more about creating python environment if you V see I'll I'll show you one link over here okay just give me a second sir one more idea is uh iuran you are conducting that 16,000 right sir mean G Codes mhm 16,000 5 8,000 huh sir that much money I did not bother sir because my friend also want to contribute me can I both join I neuron sir uh just talk to the team just talk to the team like let's see what team can actually do okay just talk to our counselor team how how how I want to contact to the team sir uh in the website itself right you will have the number see over here talk to our counselor right okay bottom their number is given you can talk to them okay so see over here creation of virtual environment uh this entire documentation is given okay you can use this and create an virtual environment just follow the steps automatically you'll be able to do it okay okay sir I don't know the internal parts how YOLO is working from where I want to study that wo V8 that all I don't know I mean where I want to study see YOLO documentation is given in a amazing way over there if you have seen YOLO V8 right if you see this specific documentation right I think most of the things are given step byep installation everything is given over there but don't in Inon no we'll be coming up with live classes with respect to deep learning also okay from YouTu YouTube paid code live session in paid code also if you want to join there is already but in YouTube also we'll have live session going on okay yeah can you explain you sir how internal parts is working math behind that sure definitely thank you sir thank you yeah thank you yeah next question hi sir yeah hi Hari uh sir uh yeah nice to meet you sir sir uh I have a question so in machine learning and deep learning how we use uh graph modeling sir I mean uh I uh I mean I I saw the one article regarding graph modeling but depends on what kind of use case right graph modeling can be used in multiple use cases uh it is AA fraud detection uh I mean like that so see again you can use this techniques but sometimes right you also need to think which algorithm is very much feasible to use with respect to a project okay okay yes your uh the algorithm with respect to this will speed up the process but again try to understand this I've not yet created any videos with respect to that you know let me have a look onto that and see if I'm able to create one project I'll try to upload that in my channel okay okay sir actually uh I mean uh last couple of uh days weeks I watched your video sir and uh uh I uh mention those uh project Basics projects regarding the generate uh in my uh resume and I uh I got a call I mean the interview call and I clear the first round I have techn rounds right now and so I I don't know exact exact I mean how how we'll go so can I get the some I mean likeone of us knows like how the interview is going to go always make sure that when you have a technical round prepare well your projects right it should be till deployment what all things you have done in that you have to explain that properly so that you know you guide the interviewer what what should be the next question that he should ask you know try to try to make sure that you have the control of the interview not the interviewer you know so the information that you're portraying in front of him right try to provide him some some things that you have actually done which may be something new for him because see interviewer would like to just understand that what all things you know so how well you specifically speak with respect to a project the more the better it is okay okay sir actually I uh I enrolled the I mean Genera a clause sir uh I mean the the but I mean I I mean last I mean the S I mean also teaching the generate I mean the community section so I watch those videos and I took one project uh I mean he I mean what he's teaching and I uh mentioned that project in my resume and I'm not expert in a generate right now so I'm very scared of that what how will go uh the don't be don't be scared of it see if you know how to use AP that's it you just need to be scared whether you know Python programming language or not the more better you know Python programming language the more better you'll be able to create this llm application okay okay sir so don't worry see anyhow you are in the course and uh when you are in the course you don't have to worry with us okay okay sir yeah thank you sir yeah next question please hi sir rendra rra you're my inspiration basically to be frank sir can you make some in your playlist based upon LM sir large language modules with python custom gpts from scratch you're saying yeah yes sir see I will take llama 2 model okay so llama 2 is there it a very good open source model on top of that I will try to show you fine tuning okay by using this glora or clora method okay yeah okay sir and have one doubt sir regarding YOLO before doing nms I mean non maximum SU we do some something called we do sorting desing order before that we do something we give some threshold values and if it is less than 0.3 thres threshold we we make it as zero Suppose there is a some small object tiny object is there suppose there's a tiny object which it has a score of 0.2 in the sense so we may lose the data in we may lose the data in that case so rinda just give some days okay what we will do is that we'll try to create a dedicated video for that okay I'll tell my team also with maths don't worry everything will broke break break into math smaller smaller parts so that you'll be able to understand okay directly explaining right now will be difficult so let's wait for one video okay from all yeah I purchased the dlcv NLP from inur I have completed the course I have completed the course I this this is just I have qued to Theon support team and small can you explain data argumentation see data argumentation is like let's say you have one of my image okay now to train a model you know what I can do is that I can change my face like this like this and give the model give the model different different images to identify me data augumentation what it does is that it takes all the images it tries to horizontally rotate it vertically rotate it expand it zoom in zoom out so it tries to creates a variety of the same images so that the vision model whatever Vision model you are actually creating it will be able to understand that image very much easily so you're just trying to create multiple images by applying some techniques some transformation techniques where it can probably zoom in zoom out horizontal flip vertical flip it can do multiple things in that image and create a new one okay uh the day before yesterday was doing a project based upon deing sir I was trying to read I have created a folder and I have created some dogs photos of dogs I have downloaded and some photos of cats when I was trying to read that in the collab it's not getting running it's showing an error for me why better drop US mail to the support provide the collab link over there okay and let them have a look with respect to that okay so we have a dedicated team who will take care of all these things okay okay try to do L from with python thank you sir that's yeah thank sir sir I have one question sir uh currently Vision language models are coming up are you going to include that in our course generative course sir mean I'm not sure whether the document papers released or not but Vision language models are coming up right so are you going to include that in generative yeah sure see the thing is that at the end of the day whatever things are coming in generative AI let's say the vision language model you basically saying large image models right so uh the gmin Pro Vision whatever functionalities whatever projects we'll be developing over there also we'll take that in the class H okay sir and I heard one of the uh student ask that about python may know what level of python is required sir because as I asked you before data structures and algorithms I am very poor at data structures and algorithms until what level I have to Learn Python may please the python you definitely need to know modular programming language you know oops inheritance classes all these things that is the reason we have given that as a prerequisite along with that we have given the entire recorded videos in the curriculum okay yeah I'm aware of till oops sir but data structures and algorithms like in advanced uh tree graphs and all uh that will not be required to create projects okay that will not be required okay sir thank you and in in Project do we get some real time industry level uh how they using all the deployment techniques we'll teach you all the deployment techniques you know what all things are currently happening and in the future let's say when the curriculum is going on when the course is going to come when anything new comes we will also take care of that you going to add in that course sir not add but at least we'll discuss that modules in the last okay first we'll complete the entire curriculum and then we'll try to include that yes definitely I want to get into this uh I uh field because I have only the hope is about this only this course after this course I I don't have any other way to switch to in testing I have only hope is this gener course I your best yes sir thank you sir yeah thank you okay guys so it's already 10 so two hours of session I hope you like this session please do hit like uh and as usual uh keep on supporting and again I will be coming in the next week Friday live session we will be discussing more about amazing projects and all uh again let's see what all things are basically coming till the next week I'll come up with that and we'll have a good one so thank you this was it for my side so if you are new please make sure that you subscribe the channel subscribe all the I own channel share with all your friends share share share the post like whatever things you specifically do tag me over there I'll be happy to answer or probably comment down like what kind of works you have specifically done uh yes uh at the end uh I would always like to say one thing guys uh see there are new things that are coming in the market right the reason why we are teaching all these new stuffs is that it actually increases your effic efficiency productivity at the end of the day the more you work the more you put effort the more you become a successful right you go in any company you go anywhere right the more knowledge you gain and trust me anything that you do in your life if you are spending two hours in learning if you are spending three hours in learning if you are not learning also right some are the other thing you specifically learn with respect to each and everything right and one more thing that if I probably talk about Inon right so this in neuron support if you want to really see a real practical example okay so let me just show share my screen so in this example you'll be able to see there is something called as support system right the main llm we have integrated in this entire support application right so let me just go through this so that you get an clear understanding what all things are basically there let's say once you join a batch let's say you are in generative AI so mastering gen native AI batches over here you can join the group in this particular batch right so let's say I'm in machine learning boot camp okay or I'm in this particular boot camp in all the all the batches I've probably joined let's say there is data science interview batch going on okay now you may be asking various question like CR can we probably communicate with our team members can we have a onetoone session can I probably study in a group so for this let's say I'm in this specific batch if you go ahead and join over here there is something called a join group as soon as you join group right then here you'll be able to see that this group will be added right let's say over here the machine learning boot camp is over here I've joined this the data science interview back so all your team members will be in this specific group you can ask any question as like as you like you know you can ask any any question as you want right over here like you can probably ping hi all the members you'll be able to see you'll be able to ask any question if if you want to probably do a group study everything will be in one platform itself right apart from this if you want to communicate with anyone right if you want to probably communicate with anyone here right you can also do that now see karik Kash basically says that why One to1 support is stopped because this was when we are developing things right so here you can probably see thanks Chris not sure if this is chrisan human or chis the chat bot I'm the human over here right now let's say if you want to get more question and right now there are many people who pay some pay they pay $20 to chat GPT but by using this Megatron you don't have to pay anything you can directly chat it over here let's say give me the python code python code to create a floss cap okay so if I write like this if I execute it I'll be able to get the entire code right so here what we have done by using see over here in the Megatron we have used L LM but the other entire application looks more like a WhatsApp message right where you can probably do one to one group chat you can have any kind of discussion now see all the questions are basically there right not only that once you probably go to the knowledge ocean let's say if you have any query right you can go ahead and write the query right so it'll you have to probably select the batch where you are in let's say I'm in master generative Ai and I say hey what is generative AI right now before when we were giving the support sometimes because of huge queries we are not able to solve that in 24 hours but now by using the support system we'll be able to solve within 24 hours let's say I'm asking what is generative AI okay and I've asked this question and I post it over here right so here when you go to knowledge session you'll be able to see new to Old what is generative AI you'll be able to see over here wait new to Old this is old to new um let me just go ahead over here in the homepage so you'll be able to see all the queries that people have asked now this is where uh the most amazing thing will be that as soon as you probably click over here you'll be able to see all the responses from the students right large language models are this this this this let's say if someone if none of the student provides a response over here then what will happen is that our llm model will provide the response within 24 hours it will first of all go ahead and filter and see which question has not been answered and then we probably what we do is that we provide a response over here itself right normally none of the vendors allows to talk with other batment in the join course yes but we allow the reason is that people waste their time people waste their time joining multiple groups right someone will be joining telegram someone will be joining WhatsApp and other than studies other than studies you know they will talk all rubbish things right they'll not talk more about studies but other than that everything they'll talk right so this is one specific place where you can have a discussion about each and everything right and not only that let's say you want to proide if you have any queries and you want to probably write a mail to us you can compose the mail here itself you don't have to open a Gmail probably go ahead and write query at theate ion. or support at theate ion. a right everything and in the future what is going to happen right in the future you'll be able to see that right now we have this chat right in the future our Megatron will be so strong since we are processing with two 20,000 videos see we have highlighted over here 20,000 videos has been processed along with that it has generated 6,000 question and its answers so any question that you specifically ask either you can get a video or either you can get any kind of answer from our Megatron itself or from our this specific chat B right so that is how strong it is going to have become in the future so at the end of the day this we are specifically doing because you'll be able to communicate with your batchmates you'll be able to do group study you'll be able to do projects you'll be able to do internships multiple things all at one place and if I probably show you ion. every tab that you see over here every tab right this allog together has a complete different story let it be with respect to internship portal let it be with respect to job portal neural lab neural laab why did we come with neurolab because many people did not have that strong laptop or machine to do the coding so that is the reason we came up with this Virtual Lab wherein you can go ahead and probably uh you know open any IDs probably work with flask wor of python it provides you an entire development environment which is running in Cloud so you don't face that specific lag then support system was one of the challenges which you are trying to fix from past two to three years now this is completely fixed and still we are making it much more better you're going to provide a lot of features as I said all these things are basically coming over here the best thing is that you don't have to pay any money for this right if you're part of a course you will be able to use this right that is the most powerful thing and again why we are doing this this is for our community we really want to build our community in such a way that you learn you learn in an amazing way and at the end of the day get plac somewhere make Transitions and yes obviously others also whenever you get that particular opportunity okay so thank you uh this was it from my side uh I hope you like this entire things that I've actually shared okay and yes this was it for my side keep on rocking keep on learning um other than this please go ahead and check out all the courses in the Inon and it'll be provided in the description of this particular video uh and yes I will see you all in the next video have a great day thank you take care bye-bye everyone Tata at least say Tata I know you did not ask answer much question over there okay but yes a good happy weekend for all of you out there thank you guys thank you take

Channel: iNeuron Intelligence

Views: 6,319

Keywords: ineuron, gemini ai demo, gemini ai google, gemini pro, gemini pro ai, gemini pro krish naik, end to end gemini pro project, gemini pro project, gemini pro end to end project, end to end gemini pro, End to End Gen AI Project, Google Gemini end to end Project, Google Gemini Pro project, ineuron support system, end to end project gemini pro, Google Gemini Pro end to end project, gemini end to end project, gen ai, end to end ai project, gemini pro api, gemini pro vision, gemini

Id: 7uR3JFYOa7s

Length: 135min 57sec (8157 seconds)

Published: Fri Jan 12 2024