Thumbnail for PYTHON Mock Interview Part 2 | Program Solving | Core, Advanced (Django), SQL, CSS & HTML by Kiran Academy - Python & Mern

PYTHON Mock Interview Part 2 | Program Solving | Core, Advanced (Django), SQL, CSS & HTML

Kiran Academy - Python & Mern

28m 49s3,289 words~17 min read
YouTube auto captions
Transcript source

YouTube auto captions

This transcript was extracted from YouTube's auto-generated caption track. The transcript below is server-rendered so it can be read, searched, cited, and shared without opening the original YouTube player.

Timestamped outline
Pull quotes
[0:00]It gives details of the employee and having a crowd operation, that is create, read, update, delete.
[0:00]We have brought so many things in this app, we have consolidated all the data, you will see our experience in it till date, how much work we have done, which will give you a lot even for free.
[0:00]So Samiksha, I see that you have given almost 95% answers of every question, most of the questions and that's a good knowledge, being a fresher.
[0:00]MSC computer science, then firstly you did BSC, MSC, so as per your qualification and past record here, I feel that most of the questions you are very comfortable.
Use this transcript
Related transcript hubs

[0:00]This is database. We already talked about it, this is we talked about it. Go down. What is language code? English. Can we change it? Sure. Which codes are available? When we create a project, these things automatically get created? Yes. My project is of employee management system. It gives details of the employee and having a crowd operation, that is create, read, update, delete. Today, Kiran Academy has launched an app. The link is given in the description. Download it, you will get all the free courses, placement courses, technical mock interviews, all the data we have consolidated so that you can pass any interview, you can try to take your preparation to a better level, there are many courses where you can buy paid courses, we are charging a very small amount, you will also get pre-recorded sessions in it. We have brought so many things in this app, we have consolidated all the data, you will see our experience in it till date, how much work we have done, which will give you a lot even for free. So Samiksha, I see that you have given almost 95% answers of every question, most of the questions and that's a good knowledge, being a fresher. MSC computer science, then firstly you did BSC, MSC, so as per your qualification and past record here, I feel that most of the questions you are very comfortable. I don't see that you're getting stuck for some questions, but my expectation would be, you will be understanding tricky questions also and more and more practice. Okay, so what are you practice, you need to talk. So let's move on to now on your laptop, where we'll be seeing what are the courses you have done, okay? So show me your things, can you give me control? Yes. Give me control of your system. Yes. No sound sound off.

[2:02]Okay. So now I have control of your system, okay?

[2:09]I want to ask you, like in your mobile, uh sorry, in your resume, I was seeing the employee management software, okay? So what is this, can you explain me what you have done in your project? Yes, sir. Yeah, open it and just explain me.

[2:31]Just wait a second, sir.

[2:37]Just a second, let me see if recording is going on. Just a second.

[2:54]Yeah, go ahead.

[3:12]Am I visible, sir? Yes, yes, it's visible. So I want to know like what is the folder structure you have adopted for this project? Yes. Yeah, go ahead. I will explain first my project. My project is of employee management system. It gives details of the employee and having a crud operation, that is create, read, update, delete. We can perform and using HTML pages, I have developed some code and and HTML pages and connect. Okay, no problem. So can you explain me like folder structure? No, firstly folder structure. What is the folder structure of this project? Okay. Firstly, employee is an application. Can you be loud? Employee is an application. Okay. And account is my project and whenever we can see settings.py file in any application or project or any folder, that defines the project and in Can you go to setting.py?

[4:53]Yes.

[5:12]Uh huh. Yeah, so explain me what is this databases? Yes. I I haven't used any other SQL databases, like MySQL workbench, because Django provide a built-in ORM. That you have used. What is this SQLight? SQLight 3 that is built-in built-in database that is provided by Django. After that. What is this validators? Means? That is automatically created when we. When we create a project, these things automatically get created? Yes. Some files automatically created. We don't need to have create particular files. Only in setting.py file, we only have to install in install app. We have to register our apps that are EMP and account which are our apps and. What is that? That admin, auth. What is that app? These these are the modules. These are automatically installed, right? Yes. Built-in. That we are using and what is this middleware? Middleware that provides security. You need to do anything over there or automatically it happens? Yes, sir. It automatically happen when we when we create the command, that is make project. Hm, make project. Yes. Okay. What is templates? Templates. These templates. Templates are the mixed files that defines the HTML pages and the Python pages and in which we have using here DIRS templates which defines here our templates folder. Okay, so you can change the name of this folder? Yes, sure. We can change it. It's possible? Yes. Can we define two folders over here? Yes, but it it may be complex, rather than we use only single. Which type of collection it is, directories? It is a list. Okay, and options? It is a set. Okay. Collection of and templates? It is list. Oh, list inside tuple or list set inside list, you can say? Yes, sir. Paka? Yes. Is there any dictionary you are seeing here? Yes, I'm seeing. Which is dictionary? Where is key and value? This this purple single curly braces it is a dictionary. So it's not a set, right? It is a dictionary. Paka? Yes, sir. Okay, what is the key in that dictionary? Backend, DIRS. All these are keys. These are the keys. Okay, so here inside list, there is a dictionary. Inside dictionary, there is a keys and values. And in values there are list and in one value there is a set, right? Yes. Or wrong? Wrong, sir. Options, options is a key, right? And what is the value of option? Dictionary. What is the key in that dictionary? Content processor. Correct. So that is possible, right? These combinations. So whatever you learn in core Python you will be used in the advanced Python, that is in Django, correct? Yes, sir. Definitely. Okay. So where you use Django list in Django frameworks, you can tell this answer, right? Yes, sir. Okay. What is the WSGI application?

[9:02]Sir, it is a. Uh huh. Sir, I'm not sure. Okay, not needed, maybe, maybe it is related to web services, right? It is built in. It is provided by built-in when we have created our first, that I already said that when we created our project, the manage.py file and setting.py file maps all the project. Okay, go down. databases. We already talked about it, this is we talked about it. Go down. What is language code? English. Can we change it? Sure. Which codes are available?

[9:47]I'm not familiar with it. Why this EN hyphen US?

[9:55]Who told you this EN hyphen US? English, US, right? How this code is? Why can't you write English? It is a code, keyword. Python developers created. Paka? Yes, sir. Okay. So you don't need to write English, you're saying? No, sir. Okay. This time zone UTC means? Don't know, sir.

[10:24]Okay, so this is Python developer coded, you think? Yes, sir. Django is providing this. No, this is like, it's a language, that is a regional code, actually English, US, English, UK. This is inbuilt universal. It is nowhere related to Python, understood? If you go for your keyboard setting, there is also English, US, right? Which language you talk, EN-US. So there is no relation. Time zone, like there are many time zones are available, US follows different. Our India follows different. Okay, so this is not related to Python. Time zone means your times will be calculated on that basis. Like 5.6 is this is Indian time, IST, understood? US will have different time, understood? What is this use I18N? 121 line. No. This is internationalization. Internationalization means every country will be seeing their own language. If Japanese person open your project, he'll be seeing that in Japanese. If you make it true. But obviously, there are some code you need to write for that. Okay. So what is this static URL? Static is a is a folder that we have used here. That includes the all the CSS, images, videos. Can we change that path? Yes. Okay. What is default auto field? No, I don't know, sir. Okay, anyway, so I tried to ask you everything of settings.py, okay? And you was awesome in this, good. So you was able to answer most of the things, okay? So many things are there which are even not useful, many things which I have asked, might not be need to be changed but just I thought of taking your awareness test, whether you know it or not because it is expected that you are touching it daily, so you should be knowing it. Like I18N, it is internationalization. Why it is used? So those who are seeing this video, why I am asking these questions to Samiksha, just because I wanted to see her awareness and I wanted to check your awareness also. So you also, guys, understand from this interview, this mock interview, like you are not here to judge Samiksha, I am here, I am enough for her. So why I am asking you to see this interview very very diligently, because whatever questions I asked her, you search those on Google and prepare yourself. Tomorrow you may face interviews and you will face these questions. So that time, you should not get panicked. So let's move on to the next. Okay, it's helpful, right? So you will also study now? Yes. Great. What is views.py?

[13:12]Here I have used post method, get method for getting input from the user. What is this request? Eighth line. Yes, this this one. This is a parameter. Can you write the request one, it is possible? No, sir. It is we have imported. Perfect. Just good good good answer. We have imported it. Yes. Show me an import. I didn't see.

[14:06]No, now my question is like, why do you use that post in on ninth line? Okay. This one is to retrieve data from the user. Retrieve or to post data or to insert data? Insert a data. Now you can say retrieve. Not possible to retrieve or possible? We can.

[14:29]Okay. So post means putting a data into the database. Okay. Now what is this REG? It is a variable name. How this REG? You can write anything over there? Yes, sure.

[14:42]Or it is related to database or front end? No, it is a variable. No, not that. 10th line that is a single code, I am asking you.

[14:55]Okay, this one. This one is a model name. Perfect, it's a model name. We are defined in models. Okay. What does this save method is doing? It will save that means commit. What is redirect method is doing? It will redirect means it will. But here you didn't give dashboard file path. How this path is getting identified? By using name. Yeah, so where dashboard.py, right? No, sir. Then. It is a name that is given in urls.py. This name, details that will render to the details. But I saw there dashboard. Okay. I didn't see that. Perfect. This name details that will render to the details. I saw there dashboard. Okay.

[16:09]This one, name equal to dashboard. Okay. So here you are binding, right? Like it's a it's a dictionary or list. It is a tuple. But in tuple you need to have circular brackets, right? Here I'm seeing. It is a list inside tuple or tuple inside list? Sorry, tuple inside the list and here we are giving the name equal to dashboard. We don't need to specify any dot extension. Only simply we just. On fourth line, why you wrote import star? Because I I have to import all the views functions from the account that we have created account app. So there are three four apps you are saying? Only two apps. But I see here three, account, employee. No, wait. I will explain account is the first app. EMP is another second app and employee is a project. Okay. So in this project you are using two apps? Yes. So where is that integration? In settings.py file, I have I have shown you that installed app. We install the EMP and account. So here I can see like three two apps and one project. So in that project we are integrating these two apps, right? Yes. So can it be possible to call from account to EMP? Sure, definitely. How to call that? No, just explain me how you can call. By using by referencing. By importing? Yes, by importing. Okay. Can you open any model in accounts? So this project you created by yourself, you are saying? Yes, sir. Okay, go to model. You didn't write here anything. App, in app, I have. This is this is details. This file is automatically generated or you wrote by yourself? I wrote by myself. Can you tell me like how to generate this file automatically? We can't generate file automatically. You can because let's say there are 100 tables having 100 columns. Is it possible, you think that you can write everything? No. How to write multiple? No. How to generate model from database automatically? Anyway, you explore that. Can you go to Google? And what you'll write in Google to find the answer for this? Understood my question? No.

[18:56]How to write multiple? No. How to generate model from database automatically? Anyway, you explore that. You shared complete screen or only one screen? Only one screen. No, I would expect you to share. But anyway, now next. What is this apps.py?

[19:16]This is configuration of an of our app. Okay. So what is that _ _ init _ _.py? This is package, initialization of a package. Good, good. Okay, so can you show me after running this project? Yes, sure, sir. How to run this project? By by simply using command.

[20:05]Uh huh. Good. Which server is running now? On Django platform. Uh huh. Django server. Django server or Tomcat server? No, Django server. I haven't used Tomcat here. Okay. Which port it will be running on? Which port? This server is running, right? So on which port it is running? On Django platform. Yeah, but which port? Like 8080, 8090, something kind of? 127 here it is given. 8000. That is after colon it's a port. Go ahead. Run the project. Just simply follow the link. I will share my screen.

[20:49]Am I visible, sir? No, it's not visible to me. Yeah. So you shared complete laptop, right, now? Uh huh. Now, we need to login. First, if you if we have any login username and password, then simply go through it and if you don't have, simply sign up the page. First name, okay, wait. Let me do something over here. Just a second. Give me access.

[21:37]I just clicked login button, okay? So what will happen now? It will it will be shown an error. Okay. Where from this error is coming? By using message. Can you show me in your code?

[21:57]So guys, whenever interviewer takes your interview, he may ask you such things. He may ask you to go into the code. He may ask you to debug your code. He may ask you to change even this error message. He might ask you to put the red color for this message. So this is the level of interviews these days people are facing. Go ahead. Fast. I'm not able to see that. Sorry, should I help you?

[22:27]Great. Okay, so where is message? This. I'm not able to see.

[22:39]Okay. Where it is? Am I visible, sir? Yes, but where? Yes, it's my. I have opened message.html file. This file is including in my login. That is correct. Where is the message like username password is not. Correct. Understood what I am saying? Okay, so that is coming dynamically, okay? Through a message. Yes, so you understood the question? That is coming through that message word, okay? Anyway, so you have any username password right now? Yes. Yeah, put that. Yes, we are login. But we don't have any details, so we have to add employee. So this is a crud operation you tried, right? Yes.

[23:54]Just put some data.

[24:20]Great, go to update. It will redirect to the form. Can you show me code for this update?

[24:37]Am I visible, sir? Yes, yes, yes. Yes. In our.

[24:55]Yes, sir. Great. Okay, let's say that 18th line, okay? Input type text is there, okay? I want to make that field in such a way that that field should be there but nobody should change it. What should I do? Understood what I'm saying? Right now you are able to see that field, right? I don't want to show that field to people. So what will you do? Go there type hidden, what you write, type hidden. 18th line, okay? Understood? So it will be a text box but it will remain hidden. You got my point now? Yes. Yeah. Save that. Because in edit, you should not change employee ID itself. Okay. Now go to your file. But anyway, so yeah. Understood what I am saying? Yes. See now. Correct. That is there but nobody can change it because if people start changing it, then your rows will increase in database, correct? Yes. Okay, so can you make it Samiksha one? Yeah, updated Samiksha one.

[26:15]Now you try deleting it.

[26:21]Done. Good. So okay, so thank you Samiksha. Actually I have gone through most of the things of your knowledge and I see that you have wonderfully answered all of the questions. I really like this interview because you was able to answer many of the questions and I hope you also feel confident about it. Do you find this interview useful? Yes, sir. In what sense?

[26:56]Because I'm I'm giving my interview to the director of the Kiran Academy. That's okay, then if. No, that's not okay, that's a big thing for me. And. And you can prepare all the questions, right? Like whatever you have answered, whatever you have not answered, that you can answer, correct? So you'll be practicing more now. But I'm very happy that more than 90% earlier I have said 95, now I'm saying 90% at least you have answered and remember guys, everyone, it's not necessary that you should be knowing everything but whatever you know should be good at expert level and at the confident level, so you will be able to answer them properly. So thank you Samiksha and thank you and see you again. Next interview we'll take again, we'll arrange and in that interview, I hope you will be performing more better, we'll do more coding, we'll do more puzzle type questions, more higher level questions, okay? So guys, those who are listening this video, stay tuned, we'll be meeting again. See you, thank you, bye bye. Today, Kiran Academy has launched an app. The link is given in the description. Download it, you will get all the free courses, placement courses, technical mock interviews, all the data we have consolidated so that you can pass any interview, you can try to take your preparation to a better level, there are many courses where you can buy paid courses, we are charging a very small amount, you will also get pre-recorded sessions in it.

[28:35]Many things have been brought in this app, we have consolidated all the data, you will see our experience in it till date, how much work we have done, which will give you a lot even for free. Thank you.

Need another transcript?

Paste any YouTube URL to get a clean transcript in seconds.

Get a Transcript