SQL Full Course 2026 | SQL Tutorial For Beginners | SQL Basics To Advanced Full Course | Simplilearn

Key Takeaways

Hey there, welcome to SQL full course by simply learn. Imagine you have huge pile of data. Now imagine trying to organize it all using just an Excel sheets. Sounds like a nightmare, right? And that's where SQL comes in. It's the tool that helps you manage and organize massive amounts of data easily without even crashing your system. In this course, you will go from the basics to advanced SQL techniques, all while learning how to interact with databases like a pro. Whether you're looking to organize customer data, analyze sales figure, or work with complex data sets, SQL will help you do it all. Here's a quick look at what we'll cover. First, we'll start with the basics. What databases are, how to set up your environment, and how to write your first queries. You'll be up and running with SQL right from the start. Next, we'll dive into how to retrieve data using select and sort it using ordered by. We'll also teach you how to filter results and perform calculations with aggregate functions like sum and average. As we move forward, we'll introduce joins. This is where the things get really interesting. You'll learn how to combine data from different tables using inner and right join. We'll also cover how to create your own tables, define data types, and ensure your data stays accurate using primary keys and constraints. Finally, we'll wrap it up with how to control transactions, which is savings and undoing changes, and even how to modify your data with commands like insert and update. By the end of this course, you'll be able to manage and manipulate data, build powerful queries, and work with databases like a true expert. Let's get started to unlock the power of SQL. Before we dive in, let's see how much you've already known. What does SQL stands for? Is it structured query language, simple question language, sequential query logic or is it standard query locator? Drop your answers in the comment section below and let's get started. Now let's understand few of the terminologies, okay? why your uh you know uh SQL is important and we although we have the Excel so we are going to understand first those concepts okay and then we are going to move to the coding part okay I will also show you how to install though we have a lab we will go for the installation as well okay so we have the individual data right we individuals have some data suppose we have the bank data we have our personal information, personal information. Okay, info. What can be the personal information? Maybe our name, our age or date of birth, you can say, right? Our qualification, qualification, we have our address and so on and so forth. Okay. So, these are the we have the bank deta uh data, we have that is a bank details. Okay. I'm talking about the bank details. Then we have yes we have the personal information then we also have uh maybe our phone data right we have our phone data our internet data so we are generating lots and lots of data right everything we are doing is generating some data right now storing this individual like on if I talk about storing this data right we can still store this data in the excel files Now if I talk about the individual data right what are the individual information we have we can store these things in an excel file right we do store information in excel file right in different sheets we can store this data even though these are the individual's data if I'm talking about the bank details or maybe the personal information phone details or internet details I will be able to store it in an excel file when it comes to the individual information of people I'm able to store that because Excel also is capable of storing 10 lakh plus data in a single sheet right it is able to store that it is able to store that much uh that much amount of data so 10 lakh plus data we can store in excel files right but even if we try to store even if we try to store for individual information totally okay not a problem right We don't have 10 lakh plus data right even we I individual people right we individuals even don't have one lakh data okay one lakh data that's completely okay for small data we are able to store it in excel files but what about the organizations what about the organization we can consider the simply uh simply learn for example where where we have so many courses learning. We have so many trainers too. We have learners as well. Different courses are running. So if I talk about this and apart from that we have different you know the financial statements and all those things. Is it possible to store all this information in an Excel file? Yes. If I if I want to store because see if an Excel is capable of storing this 10 plus data in a single sheet. Right. But if I talk about this organization simply learn where we have multiple information large data huge information is there okay is it possible to store it in an excel file even though we are able to store only 10 lakh data right if I talk about okay let's take again one more example that we have all of you are comfortable with we are doing online shopping right the e-commerce websites right we have the Amazon flipkart everyone is using maybe the blinket right? Uh or anything else, right? Zeppto and all those things. All those things every if I talk about this websites also they too have the information about the customers. They have the information about the products, they have information about the orders so on and and there are so many information. It is not limited to any size. Right? It is not limited to any size. Huge data. And when I talk about huge data and if I want to store that information in an Excel file, your file will crash. It is not possible to store more than 10 lakh data in an Excel file. And even if you feel like okay and you can notice one thing, even though Excel has the capability to store 10 lakh data in a single sheet, but even if you store five lakh data in an Excel file, it will crash. it will become slow so slow and it will finally crash only it will not open only right when we have huge data for huge data for big data like I'm talking about this organizations we will have need a database for that we will need a database for that okay a database is nothing but it is you can just think of it as a container Okay. You can think of a database just as a container. Just give me a moment. Let me take a shape here. Uh-oh. Okay. Okay. A database is just like a container. is a container which is used to store and organize the data just a container you can see here where you are having all the datas right all the data so you are going to use a database you are going to use a database is for storing huge volume of data, right? You for storing huge volume of data, you need a database. Okay. Now the thing is once you have this database, right, this is just storing the it's basically it is storing and organizing the data here, right? All the datas are present here. Now the thing is people will be let me write here Excel file what we do Excel file we directly open and we share the file to fetch the information right we are able to directly open the file and fetch the information but if I talk about the Excel uh databases right the data are stored in the container the datas are stored in the container so now if I want to fetch the information because the data class are present in the container here. If I want to fetch the information, okay, suppose here in my organization I have the user one. Okay, user one or maybe you can just take a person one. Let me write here person one. If you are confused about this, let's go for this person one. Then we have person two. Okay, the person two also requires some information from the database. Okay, person two also requires some information from the data base. And also at simultaneously you can just think some application okay some websites some websites also require some information okay require some information from the uh database okay now the persons okay or the applications the how they will communicate right the way they will communicate how they will communicate the like we are communicating in the class is uh with the English language right we are communicating with each other we are doing this class with the medium is in English language similarly if I talk about your database right this persons or this applications are going to communicate with this container are going to communicate with this um container okay using language SQL okay they the language they are going to use the like we are doing we are communicating in English similarly these users or these persons who are going to require some information from the database they are going to use the SQL language okay so SQL I'm writing here okay instead of writing here let me go for this okay SQL this is a medium of communication okay it's a medium of communication SQL is nothing but your structured query language. Structured query language it is basically the language okay which is used to communicate to fetch the information from the database. Okay. Now check here as I mentioned this is simply a container. This is simply a container which is storing the data. It is storing the data. But here we have different users who is asking for the information right? It is asking for the information here. Now the thing is if this person one person two person three websites are asking the information who is managing the request who whose request should I uh prioritize first? Who should be given the access? Who should not be given the access? Will the database will be able to uh do that? Prioritize the access. It is simply a container. It is storing the information. It is just storing the information. It will not be able to do that. And these persons are communicating to the database with the medium that is your language that is a programming language SQL. The that is a programming language. Now to manage this database and the person request these persons are requesting right this applications or persons are requesting the database right now they need a middleman because it is just a container it will it is a storing holding the information able to prioritize it and they will not be able to give the permission to all of this person or application okay you need this information okay take it you need this information That decision is basically done by a software. Okay, that is done by a software known as your DBMS. Okay, this is known as DBMS. That is database management system. Let me write it here. Database management system. So this is basically a software which manages the request. Now what happens is that give me a moment here. This right this directly does not query. Now this person will write an SQL query in the DBMS. Okay. And then this will pass on to the let me copy this. This will be passing to the database. Okay. It will taking up the query and then this DBMS will be deciding. Now I can change the arrow as well. Okay, I can go for the changing the arrow. Let me go for this here. I'll make it shorter here. So it is quering now the request right the person's request websites are request. The request are handled by your database management system. Okay. Now the database management system will basically manage the database. That means it will prioritize the request. Okay. Show with the help of an arrow here. So it is uh asking the question and then it will decide which give me a moment. Which query okay which query or request to process first? Which query or request to process what first? So it is basically you can think of it as the uh manager. It is like the manager who is managing the system because every at the same time many people are uh requesting for the information requesting for the information. This container it is just storing the information it will not able to do anything. So this DBMS is basically serving as the manager. Okay that is a database management system. Give me a moment. Yes, it's an software. DBMS is a software. Okay, DBMS is basically a software which manages the request which manages the request of the clients. Who are the clients? So these are the clients. It can be a person that means it can be a human people working in the same organization or it can be from some website. It can be any application maybe you can also connect from PowerBI or you know the visualization tool Tableau you can uh connect to the DBMS you can query from there and you are able to connect all those things right like the thing is that permission who which request should I process first is by is basically decided by the DBMS it's decided by the DBMS okay are you getting my Right. So there is no access privileges needed to connect to the okay that access privilege that comes later okay that is set by the admin team we'll discuss about later okay but SQL and DBMS we'll okay SQL is just a language okay SQL is just a language the programming language you are going to query the DBMS the way how are we conducting the class how are we conducting the class we are conducting in English that is just the way of communicating with the database right you are asking the question the way we communicate okay I want this information similarly the clients are going to communicate with the database okay that is SQL is a uh language it's a programming language that we use to communicate with the database and database management system it's a software which manages the request it's a software which manages the request based upon the priority based upon the priority it is basically the DBMS. Okay. Okay. On what basis it will prioritize? It totally depends. Okay. Like the users level. So there are different users levels also. Okay. So based upon the users they are going to prioritize the request. Suppose if someone is already reading it the file. So probably that is not possible to show it right now. So read permission they can give it. So something that is also done by the admin team. Okay. So the administrator point of view. So I'll just discuss little bit later about it. Okay. First understand this part. No need you don't have to note down on all those things. You have to understand. Okay. First we have to understand the environment and then we will be going to the programming language. Okay. Now the thing is that please understand here we have the clients here. These are the clients. We have a database management system and here we have the database. Now if I talk about this database, give me a moment. If I have this database, let me just go for uh no fill. Yeah. Now please check here. We have a database. We have a database management system, right? It should reside somewhere. It should reside somewhere, right? Physically a software is a software is present here. A software is present here. Now this place we need an infra right where this should stay this database management system. I mean the database management system and your database should reside somewhere. It need a physical system for that right it need a physical system for that. For physical system we have this server. Just give me a moment. We have a server where your where your database and your DBMS resides inside a server a physical system. A physical system are which should run 24/7. Okay? Which should run 24/7 here. Are you getting my point? This is just a software. This is just a software. Your data is stored here right now. So it needs a physical system to store this information. Right? So we need a server for that. We need a server for that. Okay? So currently I'll not discuss about SQL my SQL and SQL. Okay? Just give me some time. You will be understanding it in the process. Okay? I will be explaining you everything. No worries about that. Please focus on what I'm teaching right now. All right. Now let us take an example here. Let us take an example here and understand this concept better. Okay. Imagine okay now think of it if I talk about if this three parts let me just remove this. Give me a moment. Let us take a real world example okay of a library. Uh okay let me go for this. Scroll down. Let us understand this database. Then we have uh your DBMS. Okay, it is understand here library management. Okay, let's go for this library system or library management system. Let's go for this in real world. Okay, if I go for a real system here. Okay, I hope everyone has gone to a library. In the library, we have the bookshelves, right? Okay. In a library, we have the bookshelves, right? What is this bookshelves doing? they store the actual books. Okay, let me just give you an example here. Let me write it here. A database, you can just think of it as the bookshelves where the actual books are stored. The actual books are organized organized and stored there. Yes. Used to organize books. Yes. Now this if I talk about if we have the bookshelves we have a database here we need a librarian as well. We need a librarian as well. What does the librarian does? What does the librarian does in the library? They organize the books. We can say right? Then what they do uh helps you search helps to search the books. Search or you can also say borrow or issue the books. borrow issue issue books and also maintains the rules of the library or I can also say maintains the rules in the library right yes exactly keeps the records of the book great an manages the request documents information uh how of how is it taking the books etc Yes, absolutely correct. Okay. Now you can think of the librarian. Okay. As the DBMS as the DBMS that is your database management system. Okay. Database management system because it manages the queries. Manages the queries that is coming from the different users. Right? Manages the queries. Then what it does applies the rules. We can apply various constraints. Okay. Apply rules there. It controls the rules. Controls the rules. Ensure safety. Ensure safety to. So these are all the roles of your DBMS, database management system. Any confusion here? Any confusion here? Okay. Now lastly, okay, if we have a librarian, if we have a library, we will also need a infrastructure, right? Where this people will be present. Okay, if I talk about you need a library infrastructure, right? library infrastructure like the if I talk about the library building because if I talk about where will your librarian and the database will be present if we don't have a building if we don't have a building right so you can just think of it as the server here which provides the space okay to which provides the space to uh space for the database and the librarian right without the library building you cannot have your librarian and data uh library. Similarly, if I talk about the server here, okay, if I talk about the server here, what it does, server runs the DBMS software, it runs the DBMS software also. You can also think it provides the CPU memory. CPU me storage access. Storage access. Okay. So this is your server. Okay. The server should be uh so in the server only we have to connect to run the DBMS. Yes. Any confusion here? Are you able to understand now? Okay. Bobby, is there a confusion or anyone having confusion? Okay, great. Okay. Now, if I talk about the DBMS, right? If I talk about I'm just removing this part. Okay. Now, if I talk about the DBMS, okay, so there are multiple DBMS softwares are there. Okay. Okay, there are multiple DBMS softwares out there in the market. Okay, but we are going to discuss about RDBMS. Okay, so these are the types of DBMS. So we are going to study in this course for your SQL certification that is your relational database management system. Okay, relational database management system. Now what happens here? Your datas are stored in the form of tables. Okay. In the form of tables where you have okay multiple rows where you have multiple rows and columns okay multiple rows and columns because RDBMS stores the data in the form of tables here. Okay, each row so it is stores the information in such a way that each row should depict or should give us some information. Each row should give us some okay and in over here right we are going to discuss about so there are multiple RDBMS software are also there okay but we are going to discuss about MySQL in this course we are going to discuss about the MySQL it is not new it is mostly used in the organization it is more than 50 years old it is more than 50 years old and it is still being used okay in most of the in we mostly go for the MySQL. It's highly valid in today's edge as well. Okay. And as I mentioned, okay, data are stored in the form of tables. Why is it relational? Okay. Because there is connection between the tables. There is connection between there is a relationship exist between the tables. So that is why it is known as relational database management system. Okay. MySQL is basically a DBMS database management system software. Okay. MySQL is a database management system software. SQL is a programming language. Okay. Am I clear? Give me a moment. Okay. It is a database management system software and SQL is just a programming language. I am sure that heard of like Python or then you have heard about Java. So similarly you have this data uh sorry my SQL. So SQL people call it SQL also, people call it SQL also. Okay, that is a programming language to communicate with the database to query the database. RDBMS if I talk about the RDBMS datas are stored in the form of tables. So as I give have taken the earlier information right of the customers and the orders. So what will happen here? Suppose the customer's table customer details will be stored in the customer table. So this is your c all the information of the customer will be stored here. Okay. And suppose this is your orders table. Okay. Orders table. All the details of the orders will be stored here. Right? And there is relationship between if I want to b basically extract the information the customers who have ordered something. Okay, in Excel, what happens is that, okay, let me just give you an example here. Just give me a moment. Uh, in Excel, we store the data, we store the data in a single sheet like this, right? We store the data in a single sheet like this. All the information whatever the customer have ordered and all those things are stored in a single file are stored in a single file, right? In a single sheet. But in SQL we actually break that into different multiple different tables small small tables we store the information. Am I clear now? Yes. There are uh different types of DBMS as well. Okay. So like we have uh your um key key value pair as well. So here what happens? Okay. I'm not going for the detail because this uh course does not cover that. Okay. If you wish I will be also sharing any like the uh notes or something on the on your uh LMS okay but other types if you want to know for it it's basically one is your key value pair okay so what is your RDBMS then you have your key value pair so what happens your information the data is stored as key value pair then you have the document database as well right then you have the where the in datas are stored in the form of documents. Then you have the colum uh columner as well. So lots of databases are there. Lots of databases are there. But we are going to focus on the RDBMS. Uh there is an alternate for MySQL. So you can go for MySQL server. Okay. You have the Oracle Postgra SQL. Okay. So not there for RDBMS as well. There are multiple softwares are available. You have PostgraySQL. Okay, you have MySQL server, you have Oracle as well and you uh so I missed out the server here. Okay, so these are the different database management softwares. But we are going to learn here this because it's absolutely free. Okay, but the syntax in most of the cases are same. The environment also you will almost the environment might be a little bit different but the query right the query you write the SQL queries are exactly the same. Okay, these are all the MySQL. Obviously, this is very useful. So, uh because when we go for organization as an analyst, you have to query the database, right? You have to extract the information a lot. So, for that you need the MySQL, right? It is really useful. That's what I have mentioned even like it has been using for we are being using MySQL since last 50 years and it is the most beneficial way of storing the information right in the form of tables right what happens in the Excel what even if you go to organizations excels are mostly used but what happens in the Excel is that excels the datas are stored in a very complex way in a single table you are not able to store this those information in a like you know you are not able to store more information there. It's pretty complicated. But when you have a data and we can only store small data, limited data in your Excel. But when you talk about the big data, you will go for MySQL. Okay. All right. So now we are going it is not outdated. It is not outdated. It's still in use. I started with my MySQL journey okay more than 10 years back okay but still it is being in used so as I mentioned it's more than 50 years old okay let's go for the installation okay RDBMS is a type RDBMS is a type of database management system okay where your tables are uh stored right where data datas are stored in the form of tables Okay. And MySQL is a type of RDBMS. MySQL is a type of RDBMS. I hope I'm clear, Gandhar. Okay. Now, please check here. We do have the lab here. Okay. But before we proceed with the lab, we the lab has certain limitations. So, be able to work on the lab for only um 5 hours in a day. Okay. And since most of us will be working on the lab, it may also uh get hanged and it is bit slow as well. It is bit slow as well. So for now, okay, you can also go for installing it. You can also go for installing it. I have shared this links with you in your LMS as well if you're aware of that. Yes, Raki. Great. So please let's go for the installation. I'll show you. I'll take up your might me one of your screen and I'll show you how to install it. Okay. After that if you're not able to do it not to worry we'll just spend 10 minutes in the installation. After that what we are going to do I'm also going to show you with the lab. Okay. So please click on the link. Please click on the link. Any Mac users are here. Any Mac users are here. Mac system. Okay. Only one. Only Malvika. iPad. I'm not sure whether you will be able to install in the iPad or not. Okay. So, please check here for the Mac users. Okay. For the Mac users, I have uploaded one video in your LMS. I'll show it to you. Okay. So, my system I'm using is the Windows. Okay. So, please for the this is for the Mac users. Okay, for Mac users, you have to install two things. For the Mac users, you have to install two things. First, you have to download two things here. That is your MySQL community server and your MySQL workbench. You have to download both. This is for the Mac users, right? Go for installing both. I mean downloading both. Okay, you have to download both MySQL Community Server and MySQL Workbench. You have to first go for the community server and the workbench. Okay. After that what you need to do Windows please wait for some time. Okay. After that I have shared one link in your LMS. Okay. Please check the window u my SQL installation for Mac. Please go through the video. Please go through the video. Am I clear? Anjali Malvika please watch the video I have shared hardly 3 minutes video okay yes so I'm a non-Mac user so I'm using for Windows only so that I will be uh showing you you here okay for the Windows user okay for the Windows user you have to install you have to download only one you have to download only one. Okay, please everyone for Windows user please check MySQL installer for Windows you have to download only one. Click here. Click here. Okay. And you have to download the So once you click on the link right you have to select or download this one the first one 2.1 not the other one not the second one okay you have to go for Microsoft Windows then Windows installer MSI installer you have to go for this 2.1M okay now if you click on the link okay if you click Click on this download link. You don't have to do anything. Just click on the download link. You will be getting this page. Okay? You don't have to get a Oracle account there. Just go for Just go for no thanks. Start my download. You can go for no thanks. Just start my download. You have installed two. Second one. Nicl. Is it already installed? Okay, if it is installed then not required. So please check here. I have already shared another link. Okay. So please go for this. I have shared the link. Give me a moment. though for the Windows user you have to go for window uh sorry MySQL installer for Windows MySQL installer for Windows okay click on that then scroll down you have to select the first option you have to select the first option that is your this one okay 2.1M Windows installer the first one you have to download Click on that. Click on that. You are getting to this page. My SQL community downloads. You don't have to get an Oracle account or anything. Just what you have to do. Just what you have to do. Give me a moment. You have to go for no thanks. Start my download. No thanks. Start my download. If you click on that automatically you will realize it has start downloading. Check here small file. Your one is a bigger file. Uh our one is a small one. Smaller one. Okay. Are you done downloading? Are you all down done downloading? Just a small file. Anjeli and Malvika, please watch that video. Okay. Please follow the steps uh provided in the video. Okay? Or if you are not able to follow for today's class, you can go with the lab as well. That also works out. Okay? it it in the LMS. Uh punam I mentioned I don't think we can do it in the uh iPad. Okay. You don't have to go for opening an please listen to my instructions properly. I didn't ask you to open an Oracle account. You have to go for no thanks. Start my download. You don't have to go get an Oracle account here. Am I clear? Pavia, did you get it? No thanks. Just start my download. No, there is no way of downloading the lectures. Okay. Recordings that is not possible. I believe that is not possible. The you can also you can only watch the recordings. I can't find the video ma'am. Uh Malvika, are you aware of the LMS? Are you aware of the LMS? A punam simply learn for what? Okay, great. Okay, those who have downloaded it, those who have downloaded it, uh my screen might not be so much visible it out. Double click on the file, please give me a moment. Okay, I got stuck here. Please, once you have downloaded it, just give me a moment. Wherever you are having the downloads, right? Wherever you are having the downloads, go for doubleclicking it. You will be getting the installer right. Uh Bhavia, are you working on the MacBook or you are working on your uh Windows? Kindly confirm me. Bhavia, are you working on the Windows or the MacBook? Then if you if you're working on Windows, you have to install only one thing. Listen to my instructions carefully please. Okay. Now please check here once you have downloaded and once you have downloaded you doubleclick on that screen double click on that uh exe file right you will be getting a choosing a setup type there you need to select custom you have to select custom and click on next anyone willing to volunteer I can help with the uh if anyone can just go for the screen share can anyone okay Chandana is there so Chanda please wait I'll be taking up your screen right now yeah Chanda can you please share your screen go for sharing your entire screen okay please go for sharing your entire screen I'm also unmuting you okay can you go for choosing your setup type now first option click on the first option option please. Yeah, please everyone check here you are get after you double click on that right you will be getting the custom option please click on next once you click on custom click on next please click on next okay now click on the MySQL server plus symbol again plus symbol in the MySQL server again plus okay select the first one first one Yes. Click on the green arrow. Yes. Okay. Now, similarly, click on the minus symbol and go to the applications over here only. Okay. Can you scroll down, please? Tend. Yeah. Okay. Go to the application. Applications plus class plus. Please click on that again. MySQL workbench. MySQL Workbench Plus. Okay. Again, MySQL Workbench Plus. Okay. Again, the first one. Select the first one. Okay. Yes. Click on the arrow, please. Yes. Okay. You have to select two. Okay. Everyone, did you notice what did I do? Please tell please wait. Okay. What did I do? I went to this first one. Okay. My SQL server selected the first product. Okay. Similarly, my applications then MySQL workbench first product. Okay, you have to just click on the green arrow and then we will be uh going for this products to be installed. Once this is done, we'll go for next. Please click on next. Okay. Now go for you are getting this. Please go for execute. uh that is not possible. Okay. Dhana Lakmi and Puja what I'll do I'll take I will show you from the slide. I'll show you from the slide because uh she is already downloading it right now. It's not possible for her as well. So Chand just I'm unsharing your screen. I'm sharing my slide again. Let them uh help uh let me help them and I'll take up your screen again. Okay, please be on the screen. Let it download. Okay, please be on next. I'll take up your screen. Just let me help them out. Okay, everyone. Okay, let me Yeah, my screen is shared. So, those who are unable to follow that, please check. First, you have to select the custom double click on once you have downloaded it, double click. You will be getting the choose uh choosing a setup type. You have to go for custom. You have to go for custom. Once you have gone for custom, you have to click on next. You have to go for next. Okay. Once you click on next, what you have to do? You have to go for selecting a product type. Selecting a product type. So here you have to select the server as well as the application. So you have to click on this plus symbol here, MySQL server. You will be getting the MySQL server here. Click on plus symbol again. Okay? Until you get the first product and then you will notice that this arrow will turn into your green color. Just click on that. Similarly, you will be get doing it for the application and the workbench as well. You will be getting two products here. MySQL server and MySQL workbench. Am I clear that I am repeatedly mentioning custom? Are you able to understand that it is custom? Puja and uh Dhakmi is it clear? Puja Dhanalmi is it clear both of you? Bhavya is it clear? Okay, totally up to you those who are not doing what to choose custom I mentioned right you have to go for the custom here once you go for see this is the custom you have to choose the first option that is your custom after that go to the next okay you have to go for the server and the application that is the MySQL workbench yeah That's okay. Uh you have to go for the lab. We'll go for the lab. Those who are not able to do it, we'll go for the lab. Malvika, I believe you are going for Mac, right? Uh Mac will not be doing it because I am not using it. So it would be better that if you follow the steps in the mentioned in the video MySQL server and MySQL workbench are you there? Okay, please share your screen. My SQL below is sliding. Okay, once you please everyone focus on the screen. Please everyone focus on the screen. I have already taken one screen. Okay, so once you get to this point, once you have downloaded your two products once you have downloaded the two products, you have to click on next. Okay, go for execute. So this will take some time. This will take some time especially the second one the workbench one. Bhavy I'm muting you. Unmuting you. Okay. So let me know what is the issue you're having. I'm not getting it. Bhavia what is the issue? You can unmute yourself. Uh yes ma'am uh I'm unable to install this uh this options are not coming. Uh can I share my screen? >> Okay Tana you can unshare your screen. Yeah for now let it install. Tana you can un share your screen. Let me take Yeah, you can share your screen now. >> Yes ma'am. This one. >> What did you choose for this? Can you just cancel this please? Cancel this. Cancel it out. Fully cancelled. Which one you have downloaded it? >> Which one you have downloaded? Can you show me that 9.6? Let's go to that uh website, please. >> One second. >> So, we'll not be taking too much time on the u installation part. Which one you have downloaded it? >> Yeah. I'm going to tell you. I'll tell you you are Windows users right and you have went for the community download I have asked you for Windows users we have to go for >> 2.1 mm amp so you have gone for the wrong file >> okay uh which one the second one or the first one >> go back go back to the earlier screen go back to the website downloads >> yes >> the last option you have the myql installer for windows yes you have to install only It's a 2.1 amp. You can check the small file. >> Okay. I'll I'll try and get back to you, ma'am. Thank you. >> Please listen carefully. Okay. Okay. Please unshare your screen. Please unshare your screen. Baba, please unshare your screen. Unshare your screen please. Chana, are you there? Can you please share your screen? Jana Yoga please wait. What is the issue you're facing? I'm unmuting you. Jana, please share your screen. Yeah. Okay. It will take some time. Okay. Okay. Yogend. What is the issue? Please speak to me. You can unmute yourself. >> Okay. Hello. Ma'am. >> Yeah. >> Actually, what instruction you have given? I have followed the same. But uh still I'm not able to install the actual what I am trying to >> I'm not getting the same are you not getting the same option like uh Jandana? >> No I have getting the same option. Okay now uh what to do further? >> No if at which stage you are right now it's the same check requirements check requirements check requirement >> check requirements. Okay Chandana please unshare your screen. Sorry I'm doing that repeatedly. Can you share you can you share your screen please? >> Okay sure >> it will take some time for you. Okay because uh that workbench installation does take some time for everyone also. You can you can share your entire screen. Go for sharing your entire screen. Entire screen check requirements. Okay. Can you adding community installer? Okay. Can you go for the select setup type please? Can I just remove the stop sharing part somewhere else? You have to Yeah. Can you just hide that? Hide that. Hide. Hide. Just next to that hide is there, right? And yeah, not this one. Not this one. Your zoom zoom screen. Okay. Can you show me the installer again? Installer. Installer. Not this one. Not zoom. Yes, this one. Actually I'm not able to see your that screen you know lifeclass simply.com can you just remove that part not this one not this one not this one or should I say uh can can you just move your live class right you're not getting that part that screen sharing part is there right stop sharing hide option is there right so can you hide that can you no hide hide yes now you share that screen installer go for the installer Now installer. Installer. Okay. Again your I hide that. Please hide that. I cannot see your complete screen. Not this one. Stop sharing. Hide. Yes. Now go for installer. Installer. Installer. Not this. Not this one. The earlier screen. The installer you have, right? The blue color installer. Just click on that installer. No, no, no, no. You have on your taskbar. You have it. Go to the taskbar, please. Yes, this one. Okay. No, it was correct. That was the screen, right? Why are you doing it? It was correct. Okay, go for custom. Select the custom. Next. MySQL server class. First one. First one. Yes. Okay. Go for the application workbench. Yes. Yes. Next. Okay. Execute. Execute. Yes. Okay. The following products have failing requirements. Installer will attempt to resolve them automatically. Requirement marks as manual cannot be resolved. Okay. Click on each item to Okay. Please can you click on the first one. First item. No. Not. Yes. Here. Click click on this. Okay. Click on the status. It's not happening. Okay. One one item go for. Okay. It's doing it. It's happening. It's happening. It's happening in one person. Yeah. Let it happen. It will take some time. What happened is that you need the visual C++. So probably that is the case. Yeah, it's happening. It will take its own time. Okay. Similarly, you have to do for the others as well. Are you getting my point? Okay, you are on mute. Yeah, can you please unmute yourself? Can you please go to the Zoom screen and unmute yourself? Where is your Zoom? Yes, unmute yourself. Yeah. So, let it happen. Okay, Yogender J. >> Okay, let it happen. Okay, it will take some time for you. >> G. >> Okay. So, I'm on sharing your screen right now. Uh, Chana, did it complete? Vikas, are you able to get it? Same thing. If you are getting the redistribute, you have to go for do doing it manually. Select one by one product automatically it will execute. Okay. Okay. No worries. So, those who are not doing it. So, all the steps are done. I'm I can't able to add the application option 86% great. So it will it may it might get stuck at 89%. Okay. For 89% it will take the longer time. After that you only need to set the password. So if anyone completes that it's okay. Okay. 86. Sai are you done sai uh is your that portion completed then I'll take up your screen okay most of you it's 86% okay one of you mentioned regarding jodikica please wait no worries I'll be take have the lab also we'll work on the lab it's done okay Sindu can you please share your screen please can you please share your screen why I am showing the installation right now. So installation you can do it yourself or we have the lab as well. But why I'm suggesting because you can practice it. Yes. Okay. This is done. Okay. You have not downloaded it. Once this is done go for next. I thought the earlier one was done. Okay. You have to go for execute. Okay. So it will take some time the workbench. Okay. For me it was done. S can you go for sharing your screen? Please have some patience. I'll discuss about the lab. Why I'm showing this one? Because you have to use it. Okay. Once it is complete, right? Once it is, you are getting the status like this. Everything is complete, you have to click on next. Just go for next. Okay. Again, go for next. Here. Go for next. Go for next. Just keep on clicking on next. Go for next. Here you have to set up a password. You have to remember this password because this is the Okay, you can give a simple password because if you forget this password then you have to reinstall it. You have to reinstall it. You can just give 1 2 3 4. Okay. Fine. 1 2 3 4 again. Res repeat also. Okay. Go for next. Next. No. No. No. H next. Go for next. Go for next. Next. Go for execute. Okay. Finish it, please. Finish. Yes. Next. Finish. No. No. Don't stop sharing. Don't stop sharing. Can you go for your uh the MySQL workbench? I think it has opened for you. Yeah, workbench will open for you. Just check. Are you getting it or not? Yes. So, please. So, you all will be getting it like this. You all will be getting it like this. Okay. So, this is your MySQL workbench. Okay. Thanks. S. So, why did I show you here? Those who are not getting it, not to worry. You can watch the recording. How to do it. Okay. How to do it? You can watch the recording. So now I'm going to show you the lab. So please focus on the lab. Those who are not getting also not to worry. Okay, you can just maybe do it tomorrow. Let me go for give me a moment. Let me share my screen again. So we don't want to uh you know waste lots of time in the installation because we have to go for the hands-on coding as well. All right. So those who are not able to install it not to worry. You can take your time and do it tomorrow also. Why I'm asking you? Because it's always uh better to uh go with the offline version. Okay. So everyone have your uh LMS right details the user ID and the password you have to login there. Okay. Once you log in please follow the steps of the lab. Okay. Please follow the steps here. There you go to wherever you have the SQL, right? Wherever you have your SQL course, go to the SQL course. Go to your SQL course. Okay. Okay. Confirm me once you are in the LMS. Pavia you can watch the recording later okay or if possible I will also share this uh PPT with you all okay now please check just for the uh uh just for for your uh information okay so all of you you can see your LMS here right the live classes link you will be getting all the materials right attached here under the my class section Okay, you will be seeing the recordings will be available here and also your u the materials which I will be sharing you will be getting it here only. Okay, so for today I have shared the download link right the MySQL download link one data uh one data set and I I have also shared you the uh MySQL installation for MacBook. Okay. So every day you will be getting the recording also here and also the attachment before the class. Okay. Now coming to your lab. So you will able you will be able to see the practice lab option here. Yes. Are you able to view it? Practice labs. Please click on that practice lab. Please click on the practice lab. Once you click on the practice lab, you will be able to see this launch lab option. Kindly confirm me. Are you able to get it or not? Launch lab. Okay. So, click on that once again. I'll get twice. Launch lab. Launch lab. Two two times. Okay. Not to not an issue. Okay, Marci. It's okay because I'm launching the right lab right now. So, I will not be able to show you. Please launch the lab twice. You have to click on launch. It's okay wanker. Uh it will take some time. It will take some time. By that time launch the lab and we'll work on the lab. We'll start working on the lab. Yeah. For first launch. No, every time for launching the lab it's take it is it will take some time. Okay. So for the offline version not to worry from tomorrow onwards people will be ready I know that or if you're working with the lab make sure that you before the class starts right you launch the lab 10 minutes before you can you please have some patience I will be discussing everything let the lab be launched okay so please you have to understand that there are around 118 participants are there and I'm one right so make sure if I'm able to I'll be answering all your queries but but please you have to have some patience yes MySQL workbench because you are giving the permission to uh create a shortcut for the MySQL workbench okay So everyone I would just request you one thing. So launching the lab also takes some time right and also here it is little bit different. So I would request uh you to kindly follow the screen. Okay you can concentrate on the screen focus on the screen to what I'm doing because again see if you missed out any steps I have to relaunch the uh lab again and at that time it will take more time for me. Okay. So like most of us are working in the lab. Those who have those who are already having downloaded the offline version like SI you can work on the offline version. You don't have to go for the lab. Okay. So it'll take some time to set up the virtual environment here. So this is a Linux environment you are getting right now. And this is your application. This is your MySQL application here. Once your lab is launched, right, you will be able to get that here. And then you have to double click on that. You have to double click on that to open it. Go for double clicking it. And once you do that, you are getting the MySQL workbench. You are getting the MySQL workbench. Kindly confirm me. Are you able to see it or not? Is a lab is launched for you? Whether the lab is launched for you? Okay. S you don't need it. Okay. S you have already installed. If you have already installed, you don't need it. Okay. Okay. All right. Then I can discuss. So for the lab, right? We have to just uh what we have to do, we have to play with the system settings a little bit. Okay. Otherwise, we will not be able to see the full screen here. So I have to resize this website screen. So that is the problem with the lab here. Just let me go for resizing it. Okay. So this is how the lab looks like. So here you have the Okay, let me go for this lab. I'll show you with the offline version also. Okay, just give me a moment so that uh I don't have to you know minimize the screen. So this is your workbench. This is your workbench. So basically it is the graphical user interface okay of your DBMS. So you can see here it's the official graphical user interface. So here this is the basically where you are going to write the code. This is your this is your DBMS. This is your DBMS database management system. Okay. Where you are going to write the code. Here you will be able to notice this local instance. Okay. So if I click it's local instance is nothing but like your one drive. You store all your details here all the data here. Okay. Local instance is like a one drive or like a folder where you have all the information. So if you click on that local instance it will be you can see here first focus on my screen you can see connect to the they are asking you for the password here they are asking you for the password here you have to connect to the this is basically your GUI workbench is a GUI and if I want to connect to the MySQL server I have to share the password I have to share the password here. So you can think of it as the server is basically the engine where your my DBMS runs. It is basically the engine where your DBMS runs and wo