Day 20 | 1 Shot Interface Python with MySQL | CBSE Class 12 Computer Science | Rock in Board Series

Hello and good evening to all my super duper intelligent students, how are you all, please tell me immediately if my audio and this visual both are clear to you, please mention me in the chat section, thank you so much, Chandan Kumar, member of our channel. Thank you so much for joining the membership of our channel. Let's good evening to all the students. Did I share the session or not? Good evening Divyansh. Thank you so much Kapin. Let's good evening to all the students. Yes, audio visual bot

h are clear. Great thank you friend. Thank you Gunjan Yes, what is the doubt, tell me, I am not able to save time to complete the papers. Ayesha Khan I think you have not followed our Rock and Bore series from the beginning, because if you are following from day one, then I had told you in the very beginning about my In the live class, you can go along with the sample paper also, there is still time, thank you so much, look forward to joining the member of our channel, sorting is not late in the

syllabus, how to revise everything on the last day, you do it in every exam, right? Revise the last day in this also. Good evening Lokesh, okay, so again good evening to all the students and welcome to our Rockin' Board series of 23 days master plan of Re Jeet. Let's go right in the audio and visual both things are clear . Today's Day 20 March 30 and at 4 PM We are live here with our topic One Shot of Interface Python with my Ask and you know what today's session is going to be very important,

do you know why please tell me because on this basis The program is about to come, okay, this is the schedule of our Rocking Board series, see where we are going from 10th March, see where we have reached, isn't it true that we are going from first to A, right Well, it's 30th March and one short bus will be left to us tomorrow. Your PYQ, we will do the interface connectivity, I will keep it for doubt solving, so I am replying to a lot of your questions in the comment section. Last minute tips, t

he session of first April will also be very important. This one is fine, so make sure children that you all have shared the session, see the strength I have here, today my highest strength is 190, I am very happy but this is dil maange more, it is fine, so let's do it quickly and more. Share it and make sure children that you are supporting the channel as much as possible by just subscribing to the channel. Okay, the only support we need from you is that make sure you share the session and also

subscribe to our channel as much as possible. Give me the right, let's go quickly, please tell me in the comment section that are you guys all ready for today's live class, please tell me quickly, where is Yuvraj Singh scared? The name is Yuvraj Singh, still you are saying that you are scared, come on. It's great Omkar , let's go, so I have got complete confirmation from you guys, it's great, all are super duper ready right, let's start our video, how is the enthusiasm high children and this ent

husiasm should remain absolutely high session. Okay till the end too, so what we are going to do today is interface python with my skull. Look, if I talk about the PY Qs of this chapter, okay look, let me explain one thing to you in the very beginning itself. It may also happen. It is possible that when I am teaching, the doubts that you people are asking here, my focus remains here, the time while teaching is fine, it is possible that at that time I am not watching the chat section of you peopl

e or sometimes I am studying. If I look here, I get a few doubts, then I respond, okay, but then keep your chat section on hold for a bit, so that those doubts can be taken at the end of the session by you all, okay plus. If I see any doubts here, then definitely I will consider it right. Now see, if we talk about the questions of this chapter and not of PYQs, then till now our case study base questions were included in it. If I Talking about PYQS, whether case study base questions come or outpu

t base questions come, now CBSE does not tell me that I will give you only case study base questions or only output base questions or only programs. No, we have not. I have set my target as 70 out of 70, there will be questions of every type, right, if I talk about the sample paper of CBSE, then whatever I know on this, there is only one question of program type, okay, so what will we do now, which will be based on the concept today. This will be of use to you when you read it. Your questions wi

ll come. Right now see, first of all we will see here that you people have its requirement. Why did you read Python, I have a different software, I work in it, my AI is different, so now why am I studying the connectivity of these two? Connecting Python with Maa. Okay, now first of all you see this wherever you go. If you look at the school, in the shopping mall or anywhere else, your data is being stored somewhere on the back end. Okay, all the programs we have done till now, children, the outp

ut of pressing f5 came, it was executed and closed. Is that output not stored somewhere? Okay, provided you are not talking about file handing, okay, even in file handing, our data is being stored. Right, so now what we have is that we suppose you went to a shopping mall, okay, you did shopping there, your record, bill. When I do this, the record gets saved, so that means somewhere on the back end, I want something where I can store my data, so what is my SQL, yours is nothing but a back end sof

tware, right my SQL, what is your back end software? Back end meas in which I am storing my data or information, now it is just storing it in a very basic software, it cannot perform much complexity in it, the entire coding part is not the front, which is called front. And we will do that in Python, so basically I have to do the connectivity of Python and ML because we are coding in Python, we are storing data in MySQL, so from here I am sending my data there. I am fetching my data , so what do

I have to do with both of them, connect, connect, right, now see, first of all, what I have to do is to install My SQL Connector, so what is the command of you guys to install My SQL Connector? Pip install My L Connector d Python Right after writing this command, your My L Connector will be installed. If you want to watch the detailed video of its installation, then it is better to check it from the Hamal Connector playlist, here I will tell you the complete list. I am not telling all that after

setting up, but if you want to see the playlist of Interface Python with my L, you will find it in the description box of this video, from there you can see how I have to install the Skull Connector now. Look after installing, now you have installed it, now what do I have to do to import it into my program? So what is the simple concept for that? Import my add connector right from my L module. What do we have to do with the connector? Now when I do this I will write the statement if I am not ge

tting any error then that means it has been installed successfully Right now next I have steps for creating database connectivity Now what are the steps for database connectivity First of all what I have to do is to create my Mock connector package Second, I have to create a connection. Now look, I have imported the package. Mal Connector. Now what I have to do is to create a connection with my database, which is basically your entire chapter. Right, so first of all, look, we have imported the M

al Connector. How to import my adot connector Okay, now if you think that I will call the connect function, I will have to write again and again, I will make its alias alias miss as its alternate name rat, so here what you have to write is import my adot connector s lto. Now instead of writing myd connector, what will I simply write? Skltr r write masl connector is imported. Next step see what I have to do. Now look at both the Python and my SQL. Here I have four arguments. Which host? What will

you write in host? Name of the host that is local host which is by default. In user we will write user name that is. Root Password: What password do you have to write here, which is the password of your MySQL? Right, now look here, I have written the complete password, at many places you will see PA, Double, S, W, D, B, it is written, Both R is correct, Both Will. Work right, after that you have to write the name of the database with which you guys have to do the connectivity. Right now let's t

ry it and connect but before that do this thing and see that I have this connect function which I need. This tells me whether my connection has been successfully created or not. Now we will see it by executing it practically. So the first step is what I have to do. Import my SQL. Connector right now after that what I have written is connection object. Make C is the connection object, I am not taking it, okay, I wrote mod connector and connect function, now in the connect function, what comes to

me is host, I wrote here local host, after that, user comes to me in user name. We have written the root, after that the password comes to me, what will you write in the password, which is the password of your my SQL and then you have to write the name of the database with which you have to connect, okay so what is this mine, let's say this is my my. Now what we have done here is Suppose Show Data Bases, so whatever database you want to connect to, you can write the name of the database here. Ok

ay, I have written Suppose here, let's see once with which we can work live. If you wrote 'Suppose' then we have written the tables here and there is a table with student name, there is also a table with record name, see what is there in the table with record name, yes, this is correct, we have a table with record name, if you want, then do this on any table. You can. Okay, so what is the name of our database? Live Fati. Now I want to see whether I have a successful connection or not, what will

we do for that? Write the name of this connection object. The name of the connection object that I have created here. You will write dot is connected then after this I am writing here connection successful in the else part we write here print error while connecting when I am connecting the error is coming ok now execute it so here Its output has come and what is the output showing me, the connection is successful, ok, but let me take a screenshot of it, later I will give you this screen message

of what you are doing, I will send you the PDF file right once if you If you create a table in my SQL, Divyansh, then what will you save unless you install Windows, it will not get corrupted, let's go, now I am connected here, now what did I do here, it got erased, now what did I do here. Look, this is our data base, okay, this argument has been removed, now execute this, now I executed this, still your connection here has been created successfully, do you understand what it means that if I But

I am not writing the database argument and what it is telling me is that your connection is successful, so that means that your database argument is optional, okay, so I write here that our database argument is, look at the database argument. I have not written here that it is optional and yet my connection has been successfully created because many times in the exam it comes up that which of your arguments is optional, right now if I remove any other argument here then suggest. I brought the da

tabase argument here, okay, suppose I removed the host from here, okay, now let me execute it, okay, so what that means is that your host argument is also optional, now if I remove the root and remove the user. This is giving me an error Okay, are all the students clear till now Okay Yuvraj I will check it is clear till here tell me quickly Is it clear is it clear till now Children tell me quickly Sot V I can do it without wasting any time. Saurabh Kumar had already made a video of important que

stions. I will share it on Telegram. Anshika, if you want to use alloy, you can do it in this way. I used alloy and this is my A Dot connector. What can you write on the space S Kulti R Y What happened to you guys, should I activate it ? Okay, so what have we used? Also clear, yes, very good, now look next, what do we have to do, the connection has been created, this is what I did. I told you guys, okay, all this is done, I have found out what this connected function is for. Let's check whether

our connection has been created successfully or not. Next comes the cursor instance. Creating means, after you have created the connection, what do I have to do? I have to create a cursor instance i.e. a cursor object. Okay, now I will say a statement carefully. First look at the syntax. We have created a cursor object. Okay, with the help of the connection object, you guys. Okay, now see carefully that if the definition of cursor object comes or in this way then what will you write to create a

cursor object or to create a cursor instance we have to call. The cursor function with the help of the connection object Right to create a cursor instance we have to call the cursor function with the help of the connection object What I have to do with the help of the connection object is to call the cursor function This is your next statement Okay now See what is Database Cursor means that we are creating the cursor object after creating the connection why are we doing this it is a special cont

rol structure that facilitates the row by row processing of records in the result set means that I have If I put any query, query means select star from student where marks are greater than 18, if this is the query then the one whose marks are more than that and the record will come to me, what will we call that record? Result set set of records retrieve s on the query means. After applying that query, what will I call the result set? Now to process that result set row by row, to traverse it row

by row, then what do we create a database cursor? That means the cursor object write is cleared. What is a database cursor? Next, what do I have to do? I have to execute my query of my L. Now once you have createdDocumentsFragment , once you have createdDocumentsFragment, let's shift it here. Okay, now I have here. What did you write? Create a cursor object with the help of connection object. We have to call the cursor function. This is the next step. After this, what did you write? Cursor dot

execute and then you wrote my SQL query here. Suppose I wrote select star from student. You have to work on the table, I have written the name of that table here, that is Student, OK, now the query has been executed, now after executing the query, the result set that came, the record that came to me, fetch it one by one to me. To do this, I do not have a fetch function, so the first among those fetch functions is fetch l and I print it. You have taken a variable. Now the record is coming to me,

so I take a data variable here and print it. Now execute this, now this record has come to me , okay , if you want, this is your student table, right, this is your student table, which one is created in my SQL of yours, right and after that if we Talk, this is your output. Look, the same records are coming. Is it visible? Is it clear to all the students? Tell me quickly. Can we write the query in caps? Yes, you can write in caps. No problem. Is it clear till here? Quickly. Just tell me here yes

whistle we will do it after this Astha after your board exam ok yes clear very good ok see if you want then I will shift my my skull here and take your output window below ok like output from It will be hidden if I shift it down. Let's read it till all the students are clear. Now look next. Look at us. Whatever table name you write, the same will be suggested. I have written here , I also have a table with the record name. What did I write here, the name of the table, record, now that data has c

ome to my right, now let's see the next, the execute function of the cursor function is done, what is there in the execute function, basically, what you have to do, any you have to put the query, which you can do in my skull. You assume that I have written here where gender is E, where gender is A, that record should come. There is no gender column. Is it a good record, I will make it, student, come on, so whatever gender record is miss gender M, I will have only one record with roll number. Fou

r, this has come to me, let's go, all the functions of fetch are being done, now look next, it has been executed, now look from here, exequed from result set result set, I have told you what happens that after whatever you are putting the query of my skull. What result will I get? What will be your result set? Miss records or you can say set of records. After I put the query, after that I will get set of records. What do we call that result set? Now I have to extract the data from that result se

t. If I have to extract the means, I have three functions for that: Fetch All, Fetch Many, Fetch One, which name is clear? Fetch All will fetch all the records, Fetch Many will fetch some records, and Fetch One will fetch one record. Right now look at what's here if I talk about a record So I will get one record in the form of a tuple, I have one record in my Michael's table, it will come in the form of a tuple, so if I am saying that the Fetch All function is creating all the records and giving

it to me. That is, each tuple contains one record each. Collectively, all those tuples come under each one. Inside the list, all those tuples will come under each one. They will come in the list. So, see what we have written here. Cursor, what is yours? Cursor is the object. You can take any variable, here the place of data is fine, what will the fetch all function do, it will return all the records on the retrieved edge, query in a form of list of tuple, it will return me in the form of list o

f tuple, see son, now you have your doubt. Look, how are you asking, ma'am, what is the difference between Fetch Man and Fetch One? Children, no, I have not got Fetch Man done yet, nor have I got Fetch One done, after I get this topic done, ask related doubts after that. Okay, no, password is not optional, friends. Yes, when. If I had executed then the data type of our column which I have taken as date will show date time date dot time right let's fetch all cleared it returns all the records ret

rieved as per query in the form of list of tuple now this What is the meaning of list of tuple? A record will come in the form of a tuple and collectively all of it will be inside the list. If I have no more records left to fetch in the list, if I have more records , then I have fetched all the records. I don't have any record in my L table to fetch, so what will this return to me? What will it return to me? What will MT list return in this way? What does Rat Next tell me? Fetch Many Fetch Many

What did I write in the brackets? This method gives record. If I write two here, it will fetch two records. If I write four here, it will fetch four records and give the same. In whose form, in the form of list of tuple, in the form of list of tuple, it will return me if no argument is specified. If I don't take any value of n here and leave it blank, then it will give me a single record at a time by retrieving it, which is the same thing that my fetch one does, so that means if I put any argume

nt in the brackets of fetch many. Not writing and fetch one, they will fetch one record of mine and then it will work as fetch one function if no more records left to fetch. If I have no more records left to fetch, then what does this function return to me? What it will do is empty list right next is last I have fetch one function fetch one What will it do It will return one record from the result set as a tuple What will it do I will return one record and what will be its return type I have tup

le first time It will fetch the first record, read one record, now suggest that I have three records in the file, then fetch one or any fetch function, what will it do, here is the pointer, fetch one has fetched one record and given it to me, now where is the pointer. I have the right to the beginning of the next record, so after that when I fetch that record, from where will I fetch it, it is cleared, if there are no more records, if I have no more records to fetch, then this nun should return

this m tuple . What will he return by not returning the M-List? It is not clear to all the students till now it is clear till then let's do it practically . Come on, children, there is no doubt till now, very good. Let's look at the bar table. On which table should we work? Yes, this is Let's work on the Employee table. Okay, and the name of the database is Class 12. Is it clear to the C students? Now we will work on this Employee table. Okay, in which we have nine records. Right, let me execute

this. These records have come. I am fine, is this thing clear to all the students till now, if I do more fetch all in practice, then no one will have any doubt. Now look carefully, this is our my SQL table. Ok, now what have I done here, I have installed the fetch all function. What will the function do? It will fetch all the records I have and give it. Now, how many records are there in our mail table? Nine, so it has fetched nine records and given it to me. Right now what am I doing, here is

a I am retrieving a record and I have given my data here because it is in the form of list of tuple. If you want, you can also print its data type. Print data and then print type of data. Now we have executed it from here. Look at the list of what types I am getting. We have written what type is this list type, look at these brackets here, one record of mine will be in the form of a tuple, one record will be in the form of a tuple, or write each record, each record will be in the form of a tuple

write . Let's look ahead, next what do I have to do, now I have put a four look on this data variable here, so for I in data and print, what am I doing, I then that means, now I have a list of tuples, so when I If I execute this, what will it do to me? One record seer, now what has it given me? One record, the output is clear, please tell me once, it has become very small, tell me quickly. By the way, if I look here, I will So it is looking fine, you tell me the quality of the video, you can in

crease it by going to the settings, yes, it is looking fine to me, you guys tell me quickly, is it clear, very good , now what did I do, I put a four loop, this is what I have. One record came here, okay now what did I do, children, now there is no more record to fetch, so I took a variable here from the data and equal to cursor object, I told it to fetch it and again fetch all. I just put the function and then what am I printing? Data one is fine. Now here I have put it like this. Now look at w

hat I got as a result. Now I don't have any more records to fetch, so what will it return to me? Will give none ok miss or mt list none too sorry i no more records to fetch if there are no more records to fetch then what will the fetch all function return m list is this thing being cleared what will it return for all the students me MT List Right, this is our done Fach. Now tell me if any student has doubt only in Fetch All function then we will move ahead. Why is there no list in this output? V

ery good because the output that came to us is data variable. Right now I have put a for loop on that list of tuple, that means now when I am putting a for loop on my list, it will come to me one by one element and in what form is each element. I have it in the form of tuple, let's write. Does anyone have any doubt in the fetch all function? Tell me quickly, then let's proceed further. When you did the range function, why is there no list, where is the range function? You are talking about this,

I am wondering . Here you are saying range function. Okay, so there is no range function here. If you did not use meas, then the list did not come. Children, earlier I had the list in the form of tuple. Now I have put four loops on my list, then one element will appear. Only one element will come, right in the form of my tuple , now next comes to me the fetch many function, okay now what I did here is fetch many and here you will write the number of records to be fetched, I wrote it and after t

hat I I printed the data variable and also I printed the type of data right. So look here now I have three records fetched from Fetch Many. This is your table right. Now here what we did was what was written in the brackets of Fetch Many. So what does this thread mean that it will fetch three records? First records will be fetched. What will it do? It will fetch the first three records. Look one two and these three and its data type also what is your list or You can say, list of tuple right, is

this thing clear? Now see, after fetching three records, my pointer is here, that means, my point is now at the beginning of the fourth row , now the pointer is at the beginning of the fourth record, okay. What is my point at the beginning of the fourth record, so now when I apply fetch many again, now remove this type variable and here I have put it in the simple print function in this way, now it is clear, which thing is clear? It's fetching the first three records first second third and after

that when I did this look at this fetch the next three records right next three records cleared thing here it will fetch the next records so after that I have six Records have been fetched, how much is the total, please suggest, I am putting the total here, I have no records, I have it in the table, okay, and I am writing three here , okay, total, what are the records I have, and I am here. But what am I writing? I am writing sorry, there are total nine records, I am writing A here, so when I w

rote T in fetch many, it has fetched eight records, then what did I write three that you fetch three records, now it does not have three records either. It will not give error here, what will it do to your single record, it will fetch how many total records, I have nine in my SQL table, okay, so I am telling it to fetch eight records, it has fetched eight records, then I am telling him to fetch three records, he did not have three records, so error error, don't give anything, he has a naughty tu

ple, he will fetch and give me one record, okay, after this I fetched him again, I said, brother, you fetch one more record. Do it. Now I told him again to fetch one more record. What have I written in the fetch menu? When you execute it, now it does not have any record to fetch, then what else will it give here? MT list, is this? The thing is clear. I have simplified the output to all the students so that it is visible to you people. If you ask, I shift it to the right here . This is your outpu

t and this table of M is now fine. Let's see if it is clear. It means to extract the record right. Now what we have done here is that it has fetched eight records. It has fetched one more record. Now when it reached here, it has no more records to fetch . No more records to fetch. fetch then what will it return to me return mtel look at what it returned to me mte write cleared if I don't give any argument here now suggest I removed it from here ok now what did I do no argument in fetch And then

I want to execute it , so see here it is returning one record to me and giving no argument, so that means by default it will fetch only one record. Now see if I am not giving any argument here in fetch many. You had read that this will behave like fetch one, miss will return one record but the fetch one which will return one record will give it only in the form of tuple, this one which has given me one record is in the form of list of tuple which it has given me by returning one record. In whose

form is this given, is this your list of tuple in the form of is this thing cleared to all the students Aryan, you, me, I told you yesterday also that you should mail my on the mail id and the second thing is your membership tub is there. But you will get my direct link on Telegram, you can contact me there also. Okay, I had given you the mail ID in yesterday's live class also by writing Swati Chawla Swak Rat on the screen , is your list cleared? It is done in the form of tuple, now I can put m

y four loop here , I entered the data and printed it, now execute it, now look at you, here I have written the proposal, if I mean, then that message will fetch these three records and give it. So here, how many of your records have been fetched, is it clear, tell all the students quickly, is it clear to all the students, now it has digested and given me three records, let's clear it, now next. I come to the fetch one function, what will fetch one do, it will fetch only one record at a time, now

I have printed it here and then I have written the data variable here and then I have written here print type of data , the type of this data variable. Now you can see here now the fetch one function is what it gives me by fetching one record fetch one is fetch one record will fetch one record cleared and if there is no other record to fetch then what will it give me okay look In whose form should it be returned? Type of data: In the form of tuple, write is cleared. It is absolutely necessary t

o use execute function to fetch all the students . Unless you execute the query, how will you fetch the data ? Now look next, I have fetched one. Look what I did, total I have nine records, I put fetch man from here ok, after that what I did now I put fetch one here will fetch one record 7 8 no and then like this right now execute this now Look carefully what happened Pach I have sent this to you It has fetched seven records Right fetch one is one Record has been fetched, then fetch is one, then

it has fetched one more record, then here it has no record to be fetched, so what will it return to me, sister, is this thing clear to all the students, is it clear, tell me quickly. Do I Read All The Concept But I Can't Able To Handle And Do Program Related Questions How To Deal With It Obviously Practice So, what will it return, what is this thing clear to all of you students, right cursor D, five, one more time, then show second record, if you use range, then son, I have not used the range f

unction anywhere, you are talking about four loops. Right, so if I put fetch one here and after that what I am doing is for I in data then I get one element of the tuple, what is each element name and all this then I have the answer. Will come in this form, write is it clear, write a function to split a path, son, first let's do this one, we will check if the connectivity is fine, then we will take the doubts about it later. If we give the argument 'fuch one' in 'fuch one', then an error will co

me. What we do here is Fetch W I gave here let's suppose two let's give three this is what we call what you do print it right now I executed this so now what is it giving me error right this Look at this statement here, what I had written in fetch one, three it will return and it will give you an error, we cannot give any argument in fetch one function and any doubt it is clear now let's fetch considers many nulls. Yes, if you don't write anything in the brackets of fetch manic, it will still gi

ve the output. Where are you sleeping Divyansh? If you don't give any argument in the brackets of fetch manic, then it will record one. Just did a practical, rewind a little video, let's get these three fetch functions clear. Now let's put our own query. Okay, now I wrote select star from employee and one more thing and go to row count property. One more look. Children row count property. Okay, what does this property do? This property returns the number of rows retrieved. So for that means , he

will tell how many records I have retrieved till now, so I wrote here, 'Fetch many', I have printed it, then I have printed these data and I am printing it, and then I am printing total records retrieved . You have to call the row count property from the cursor object. Right, so look here, what have I got? Total records retrieved. This is your row count property. How many records have been retrieved? Now I have three. What I wrote here in Fetch Many was in Fetch Many. When I wrote, it showed ho

w many total records have been retrieved. Now what did I do? Let me write the same thing here again. Now I told him that I have fetched two more records here, so this is Total Records Retrieved So Far Miss, how many records till now? When it is retrieved, what will it show in the next row count property? Is this thing clear to all the students? First, I had retrieved three records, so what was this total record retrieved showing? Then what did I do? What did you write, then how much is your tota

l records retrieved? F Miss, how many records have I retrieved so far? Three, first two, now what is the total? Is this thing clear to the students? Post argument son, I did not book. I had read that it is not optional but I wrote it without it and it got executed. See the answer. The answer is also correct. Look, I have not written the name of the host. You enter your Python ID in the 'My SQL' field and check it once more. It is okay to take this thing, is it clear to all the students till now,

yes very good, if there is any doubt till here then ask, after that I wrote here select star from employee where gender was equal to A where gender is A, now we Fetch all will do all right select star from employee where gender is equal to a where where gender is m, those records should come to me ok now see how many records I have total no records and this has given me f ok m Well, I had put a query that wherever there is gender M, those records should come. Now check here where M is in your t

able, one is roll number one Saksham, after that roll number is four Manoj, then I have these hints and Shikhar is fine and there is one below also Rishi Right So Jahan Jahan Gender M That's your total records retrieved That means five Is this thing clear till now all the students What if we don't fetch any record and row count you get zero Will give right, now let's see next what I have to do, I have done that only those records will come where gender is M. Okay, so you can put any query of you

rs here, I guess I have put that whose D code or The one whose salary is above 50000 , then here I have written the salary is greater than 50000. The one whose salary is greater than 50000 should come, this is 50000 now. Okay, so I have a record whose salary is greater than 50000. So here I have. Now it is clear, tell the students immediately if it is clear, then let us proceed further. Yes children, notes, we are executing practical, this I will send it in the telegram plus in the description b

ox of this video, after this video, you people will get it right. Yes, CS students will have to read IP in CT. Yes if type cursor dot fuch l inside print what will be the output random. If you want to see any record, it is random then you will not see any record in it. You will put your query on its basis and it will give you the result in the same way. Whatever query you put in your mail, you can put it here. Okay, I suggest that I put group by command once and do the grouping to see how many p

ersons, gender wise, are there in each D code. So here. But I wrote select D code comma count star from student group by D code, how many students are there in each D code, he should come, I don't have D code, is there a good employee here, then this record came to me, you have three in 10 departments. Employee is 102, there is three in this way, this is my employee table, all the students are cleared, let's go right till here , putting loop will not make any difference on the row count, okay if

I am simply printing data here, that 's okay too How many records have I retrieved , let's just say that the email address is not found. What email ID have you written? Swati Chawla Dot Swati, this is the email ID, son Aryan, check out this mail ID Swati Chawla Dot Swati is fine, plus you, me, if you have membership . Once you have joined, you will have a membership tab open. Open your channel. There you will get the direct link of Telegram. Right to contact me Aryan. Come on, now after that we

will see the next. Fetch function is done . Extract everything. Taken data, now the last thing that comes to me is that is parameterized query last, so what is the next topic, okay now see what is parameterized query, whatever query I am putting till now, I have not taken any input from the user, no input. I am not asking the user to tell me which gender of employees you want to see, right, here we have Parameterized query is useful. What to do? If I have to take input from the user, then here

I have two options, old style and new style. It is okay till date, it has never been written in the exam that in which style you have taken input from the user. If you want to take it then it is your choice but we both will study okay, I like this new one okay, you see yours, which method seems easy to you, okay, here what we have is A modulus y A modulus, not even percentage or okay. A. Your template string means what is your complete string which will be the SQL query. We specify the values ​​

to be formatted using the tuple. Using the template. Now look here, I have written and crossed out one thing which is that we must be a tuple. If you guys read the books , it is written there in the book that select means, this is your argument, it should be in the form of tuple, but we had executed it practically without tuple, you guys were taking the right and new style. What does select say? What is your example in this? Look at the example of select star from student where marks are greater

than percentage. Here whether it is an integer value or a string value, whatever type of data you have taken, here what is your percentage? Right and This module , this percentage, this one and this v means whose marks will be replaced by s to 70 so wherever this s is there then what will come here 70 new sl string what does it say select star from student where marks are greater than these curly brackets Put end section equals to this. Now see whose data type is integer. These codes will not c

ome there. Marks' data type is integer. These codes will not come. If the data type of the section is string or varchar or care, then here you will write it with these codes. Look at the dot format, the entire query will come with these codes. After dot format, you will write what has to come in place of these brackets. What did I write? 70 That means 7 in front of the first bracket and what will come in front of the second one? B Is this thing clear? Now let all the students try it once, now wh

at do I do here, I take user input, okay, what did I take as user input, let's assume marks m, I took input, int input, enter marks, whose marks I should enter, as much as I should enter. Or enter the roll number, whose roll number is not there. Roll number will not be there. This is the employee table. Enter the employee number. It is ok. If I enter the employee number, I will get his record. Right then execute. Here you will write select star from table name. Is Employee? Now what do you guys

write next in the mail query? Where is the number equal to percent? Right, this is done, then percent and then what do you want to replace it with? E number, name number of the right column, activate it, here I have entered E number. When I let you submit, I got the record of the second employee . Is this thing clear? Is it clear to all the students? Children, please tell me quickly, this is our MYL table, I have entered the employee's name here, I have put 'who is yours'? There is a style of ol

d style, now we will also write through the new one, so look here, it has retrieved the record of your second employee and given it to me, right after that, if I write here, I will talk about the new string, okay, see it in the old string. I write gender here, Gender we have written within quotes, so here I have written gender G, I have written enter gender, if I enter M, then male record will come. If I enter F, female record will come, then here I have written A and Here you will write 'ver ge

nder equal to 2'. Now here what I did was take an input from the user as to which gender record to see, in which variable it came in 'g' variable. Here I put my query select star from employee ver. Now look at the value of Gender, you will write the value of Gender as your Vidhan Course, because when I execute the query, you will write Gender Course as M, then you will also write this percentage as Vidhan Codes. So here if I am entering Gender, let's assume that as many as There are also mail re

cords, ok, remove the integer, we had set integer for ME number, right, now here I have entered M, so look carefully here, I have got the data of all the mail records, right, this is your mail. I have all these records. Is this thing clear to you guys ? Is it clear to all the students as well? Yes, we will do it with the new sale as well. Don't worry, kids. As soon as I saw the comments , I started hanging in the chat section. Poor phone, let's get it clear, now see if I have to specify multiple

conditions, multiple conditions mean that now I have all the male genders, now I said that there should be more records of male genders whose salary is more than Rs 20000, okay? Yes, I want to enter salary also. Input and enter salary rate. So what will I write here ? Gender equals to this and salary equals to percentage SGA. Is this thing clear to all the children? Now what I have put the query here that I want to take two conditions that whoever's gender is male or female plus salary should b

e this much or more then here I put the sign of greater than ok now execute it now suppose I have entered the gender M. And I entered the salary, let's assume it is 20000. Right, so I have got the records of those whose salary is more than 20000. Here you can see, it is okay, there should be a male employee and what should be the salary, if it is more than 20000, it is cleared, son. All the doubts related to networking and file handling will be taken at the end of this session. Now you just focu

s on this. Right, no, in the old style, percentage S is compulsory to write. Yes, in the old style, you will write percentage S. Come on, son, last year's agent and not raise. The previous exception handling came only this year, is this clear to all the students? Yes very good thank you so much vampire gaming for the super Chat Percentage S replaces the value Yes Yadav Swastha ji, this percentage S which is written, it will replace its value. Means, what will come in its place, that value will c

ome in 'G' and 'G', that value will come in 'Gender' and 'Salary' will come here. What will it replace? Right from the variable of this salary, this thing became clear to all the students. Now let us see the new style of string, what is there in the new style, I have it, remove it only where there was 'percent', what will go there, bracket or do bracket, this is your new style. It is of string, it is ok, here percentage will not come, dot format is function, everything else is same, now cut it a

, look at this, here, activate this and I have written let's propose a and I have put salary greater than 20000 right. Here I have two records whose salary is greater than 20000, this is your new style format, it is cleared, here we have put this new star, simple, what will you do, wherever there was percentage 'S', what will you do there? You will put the brackets and use the dot format function . It is clear till now. Tell the students quickly that it is clear. I am not able to understand the

old style. Do not do anything in the old style. Just the percentage will come like this and in place of this dot format also that percentage symbol. It will come, okay Nayan Gupta ji, you are looking good, so I am comfortable in the new one, okay, by the way, both are fine, no problem, it is cleared till now. All the students, whatever query you want, you can put it here. You can right, now one comes to me, see what the commit function does, we have not used it till now, all the queries we have

executed, not only fetched the data, but have not sent anything in my SQL, all the queries I have done now. Till we put select stop from this select this select all select queries neither I put insert query nor I put update query nor I put delete query which are making changes in my database right so what is your commit function for that if I I am sending a command in Python that you insert it in the database, you update the values, I want to make a change in Means Ma's table, now you will do it

using the commit function, unless you use the commit function, you will not call your database. If the changes will not be accepted, then Commit is small. It is used to save the changes in the database. Physically, if you have to make changes in your database, then if you have to save it, then what will you do, will you call the commit function and when does this happen? You have to put all these queries like insert update delete later then what we do is call the commit function and you will ca

ll it with the help of a connection object suppose my connection object is CO so here I am CO dot commit in this way Let me call the commit function, it's cleared, let's do it till date, Arthva has not told you in a particular style whether to use the old style or the new style, but yes, you can see both once, let's do it now, insert update delete. Query it quickly and insert it later. First let 's update and delete. Right, now I have opened this, see what I have done to it, deleted it. Now what

am I trying to do with the help of cursor object? You will call the execute function here. But I wrote delete from table name what is employee where e number is equal to two see either take the e number from the user or I write like this the e number is not equal to the one whose e number is nine what to do record this query execute Do it, if you want, then take it in a variable, one, I took the variable from the query name, assigned it to it and here you put it in the variable, okay now what d

id I do to delete it, executed the query, put it right now. I just printed here, delete record successfully, did not apply commit function, write now, what did I write here, delete record successfully, now I executed it, now see, it is getting printed here, delete successfully, but from here, the record was not deleted, why not? Deleted because we have n't called the commit function, so I write here or I write record not deleted because we haven't called the commit function . Changes will not be

made to your database until I call the commit function. Right, look at this. I wrote this. Record as it is I did not call the commit function so this is your record not deleted Now what do I do Call my commit function here I will do it like this, just get it printed, no, by printing like this, some records will be deleted. Now with the help of connection object, I called the commit function here, rat, now execute it, now ya aha record related successfully, now see your my acl ya still No, we ma

de a mistake of deleting. We made a mistake of checking. Tell me quickly. Just delete from table name is employee, which is number, check its data type. Integer is only if the number is equal to no. Activated the query and gave the commit function. Let's get the record done. You will have to open the delete table again. Okay, so let's see here what I did. I had to delete the record of employee number 8, so it was done for nine, I did not open the table again. Okay, so see here, you guys. Now wha

t I did was apply the commit function, ok and here you can see that this record has been deleted, right yes, selected star has been undone, ok, no need to close the SQL, now open the table again, it will be done, let's do it now. We do the update command. What do I do in the update? Look carefully at what I am doing in the update command. I will make the user enter the e-number. Two questions are cleared. How will we do it? I will make the user enter the e-number and enter the salary. Ok. Yes, w

e will update the salary of that employee number, right now we will take it from the user, we told the user, brother, you enter this number, enter this number is ok, then we told the user to enter the updated salary, this will also come in the integer itself. We told the user to enter the updated salary, now we will update it, update command, what do I have, update table name that means l set salary equals to and percentage or whatever you have to write where e number is equal to again bracket h

o g query. Dot format e number earn salary t y I write update record updated successfully right now we have done this thing entered this number entered the updated salary and I am executing it right now I executed it now I am entering from the user I am doing let's propose, look at this table, you have this table, okay, now what did I do, I entered the number, let's propose and then I enter the updated salary, if the number of employee number 5 is 30000, then I get it written as 55000. Now let's

look at the employee number file. If you have doubt, you can also print the query variable. Okay, what have I done? Updated table name set salary. Okay, first here is salary, so first write SL here and then Write e number, ok, now let's go, enter e number, write f and updated salary, write 55000 rupees, now look at this, I have updated it, now open my SQL table, now it should be done, ok, now look here, this is your employee number five. His salary has been updated. Okay, this was his updated s

alary. We have put a query to update it and I have also committed it here, so that his changes should be saved and cleared. Yes, look in advance here. But whatever brackets or percentage you write, it will be replaced with the same, so the salary is coming first, here you will write the salary first, right, it is clear, now let's do one last thing, if we just want to insert it, then it is okay. Rest all has been done, fetched, updated, deleted. One last thing, if I want to get my records from th

e user and get them written in my database, okay, once quickly, I will create a table here. Let's create a small table, I will create a small table with the name of the student and the roll number of the student will be integer and his name will be ver ker and his marks will be just write these three things. Hey create table, write class 12 like this, it's okay. What is happening, now here the table has been created with the last 12 names. Now what do I want? Look, if I select star, I have not e

ntered any record in it, nor is the MT set. If you want, you can insert half of it. In the name of the table, I wrote class 12 and then this became the values, role number one, I assumed in the name, I wrote Neha and marks, I wrote let's assume 89, one record has come, what will I do with the rest of the records, I will make the user enter right, now look carefully. How to enter and shift it here, it's okay, this much will remain okay, now see what I have to take from the user, first, roll numbe

r, first, I have to take the name from the user and second. I am ok to take marks from the user so here I wrote int input enter roll number ok then I wrote enter name and then I wrote enter marks right now what do I have to do after this I have to execute the query the query is a simple one I took the variable here I wrote insert into table name what is the name of the table I have insert into table name then value this is for roll number bracket for name this is done code and this is for marks

insert into table name value this is bracket close Dot format is done, this is roll number, name and marks, now next what should I do, should I enter the commit, should I execute the query, first the object of the cursor, dot execute the query, then the query has been executed, now what should I do, should I call my commit function, so all this All the chances will be saved in your database, okay, nothing else to do, now execute it, okay, now what I wrote here, in the roll number to name, I ente

red Nisha, marks are 100, okay now check. Go to the database there and look carefully here, this is my roll number two, now I have it in my table. Okay, so look here, I got the query entered by the user, executed the query and submitted it. Here I made the user enter the record and this is yours, it got inserted in my SQL, okay now see what happened, only one record was entered at a time, now if I want that as long as the user wants, he can do it in file handling. By making the file true that I

keep entering my records as long as the user wants, what will you do for that, you will put a while loop, now I have to repeat all this work, if it comes inside the repeat and while loop, then I have done this here. But what to do, you have put your while and this true while loop, okay, pick up all this and shift it inside the while loop, now from here we will ask the user whether you want to enter more records, yes or no, now if User presses N, I have written both capital A, B, A, B, so what sh

ould he do? As soon as he breaks the loop, he breaks and after coming out of the loop, I print Y, record inserted successful write, this thing is cleared, now execute it. Here I have written the roll number. In Let's Suppose Name, we have written Priyanka and Marks. I have written 45 more records. Yes, roll number is the fourth name. Pooja and Marks are now. I have 63 more records. Yes, roll number is the fifth name. I have Sonia and Marks are done 45 more records no ok now I pressed enter this

is the record inserted successfully now check here so now look here all my records which are there are successfully inserted ok now I have made it wide loop These records have been inserted here. Is this thing clear to all the students? Is it clear till here? Tell me quickly. Now let's take your doubts. Is it clear till here? Tell me quickly, children . Yes very good , there is no doubt, if the children do not come to the programmes, then we will have to practice for that, there is a playlist na

med after our programming corner, you check it, plus we did not know when we did it, we thought, we thought. Then we had practiced a lot of PY, why check that, let's go right and if you have any doubt, you guys also have create table in this chapter, yes you can do it, just the syntax will remain the same, salute what we have written here, create table, table name, all that. Do this, pass the query, put the commit function in the at function, put the output base question. I had sent you on teleg

ram channel. Study time is less so I should watch only Piva's 20 videos. It is hard to watch the videos in two days. You can see only Piva Q. Yes Nikita is sufficient. Using Pra Accept is compulsory in file handling. Yes, if you are inputting records through list then it is not necessary but if you are taking list or dictionary then it is necessary. Anshika Aggarwal If you want to practice more questions, then you can also see our old playlist , we have questions from all over the world, you che

ck once, okay yes Ashok Kumar, thank you so much, like everything, let's go and no doubt children, you guys are parameterized . Query I don't know why the phone does not hang at this time. Come on, what is parameterized query? This is parameterized query. Okay, when will you use this parameterized query? When I am taking input from the user. Okay, here. But either you write percent s or put these curly brackets, right, then it gets replaced by that. If I talk about old new string new style, then

I put these curly brackets whose data type is my skull, what is it, what is the date, all this. Whose values ​​you put with these codes, then you will put curly brackets here in your with these codes. Ok, write it as it is, whatever is your query, close the with codes, put dot format function in double codes and then if this is the case then this If you want to write in new style, then what will you do? Sorry, if you want to write in old style, then insert into table name, you will put this per

cent S, you will put this percent S, you will put this percent S, okay, what will come here in place of dot format, percent right. Cleared , practice the beauties of YRK, is it necessary to make a table in it, to show the output, which one has network security ? Prince children, network security is not mentioned directly in the syllabus, but it is a very basic topic. If you want to do it, you can do it other wise. Let it be but split it is better. Yes Varsha Kumari definitely linear list. The li

near list that you guys have is a linear list. Is the list small or do you want to ask about linear search? Let's talk about this chapter. Question tomorrow. Yes, we can. Create database also by using this if no record is written in the book yes child study time key if no record left then what will fetch fetch I have written in the book MT tuple you said MT list please tell son only MT list will come and the publisher of which you are You are talking even, I will not take the name but I had not

even mailed them for this thing, plus one more thing that for the nun there, if I have a fetch one function and that was nothing but fetch all. Think there was some misprint in the data tape space when the very starting edition came out, okay maybe it will be corrected in the new edition but I showed you practically that if there is no other record to fetch and you can fetch it using many functions. If you are, then it will give you MT list, not MT tuple, it is okay, study time, it may be your m

isprint, how to learn the code, children do not learn the code, okay, first remove this thing from your mind, only practice. Do it automatically, the code will be created, Percentage S of Akshat, whatever is yours here, it will be replaced, I am writing the format specification, first, what is the R number, this is the percentage, that is, the format, if you have not studied anything yet, then what to do still 30 31 First two and a half days Do practice questions, if you still feel like it, firs

t pick up networking, then pick up muscle, then pick up python logic tour, then pick up file handling. Linear search is basic simple searching, binary search is not like that , programming is not hard in your syllabus. Many children will ask, will programming be hard? Some programming will be hard. Now you don't know whether programming will be hard or programming will be hard. OK, let's go P.Y. There is a link in the description box of this video, check the CBSE website, it will come from this

chapter. If we talk about the sample paper of 4F Marx , then it's okay, so I think mostly we have cleared your doubts, that's all for today, so with this our today's session gets completed and We will meet tomorrow, that is 31st March, tomorrow we will be doing PYQ of Interface Python with my SQL. Tomorrow's session will also be very short, it will not take much time, it is okay, but the session the day after tomorrow is very important, I will tell you about it. I will tell you what things you h

ave to pay attention to before giving the exam. Okay, so datchi, we have executed the practical which we executed in Pai Cham, I will make a PDF file of it for you and add it in the description box plus I will Send it on in the comment section as well how did you like the video how did you like the live session right so see you tomorrow same time same place next day right but with a different topic that is p y reasons of my askal connectivity right till then Keep reading keep smiling bye bye all

the very best