SQL Full Course 2026 [FREE] | Advanced SQL Course 2026 | SQL Tutorial For Beginners | Simplilearn

What if you could look at a huge table full of business data and find exactly the answer you need to know in just a few seconds? Whether it is customer details, sales performance, product trends or employee records. That is exactly what SQL helps you do. Hey everyone, welcome to this course on SQL training. Today, data is at the center of almost every business decision. Companies collect information from website, app, payments, customer interactions, operations and much more. But collecting data alone is not enough. The real value comes from knowing how to retrieve it, filter it, organize it, and turn it into useful insights. And that is where SQL becomes one of the most important skills you can learn. This course is designed to help you understand SQL from the ground up in a very practical and simple way. You will learn how databases work, how tables store information, how to write queries, how to filter data, join multiple tables, apply calculations, and manage data properly. So, it's not just about learning commands like select or where. It is about learning how to ask better questions, work with structured data, and use SQL as a tool to solve real problems. Let's look at the agenda now. First, we'll understand the basics of databases, why they are needed, and how SQL helps work with large amounts of structured data. Next, we will learn how to retrieve and filter data using commands like select, where, and, or, and like. Then, we'll move into table creation and data manipulation where we will explore insert, delete, alter, and the role of data types. After that, we will understand joins and relationships, including inner join, left join, right join. So we can connect data from multiple tables. We'll also look at the aggregate functions, group by having to summarize and analyze data more effectively. And finally, we will explore important concepts like primary keys, foreign keys, constraints and transactions using commit and roll back. Also, if you are interested in building a strong career in data analytics, I highly recommend you checking out data analyst certification course by simply learn. This course gives you an industry recognized master certificate from Simply along with individual certificate from Microsoft that you can showcase to potential employers. A real boost for your resume. You will master key tools like Excel, SQL, Python, Tableau and PowerBI working on real projects to build practical skills and learn how to turn raw data into insights that drive better business decisions. Plus, job assist helps you prepare for interviews and get noticed by top hiring companies. So, what are you waiting for? Hurry up and enroll. Now, the course thing is mentioned below. Here's a quick quiz question before we get started. Which SQL clause is mainly used to filter rows based on a condition. Your options are order by, where, group by, or join. Let me know your answers in the comment section below. So, before so SQL is a programming language. Okay. Before we move to the programming part, we have to understand few uh terminologies. Okay, we are going to understand few terminologies and then we are going to move to the coding. Okay. Hello everyone. So without wasting any time, let me just share my screen. 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 also one more thing you have to remember so I can see at now currently there are 94 participants leaving me and the Allison okay so at any point of time you are not able able to understand anything. You don't have to wait for the poll. You can directly ask in the chat. Okay. So, every my eyes will be on the chat. Maybe I may I will be explaining something. I may take 5 minutes and I'll then take go through the chat. Okay. All right. With that thing in mind, okay, let's understand now. 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 data 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 please check here everyone focus on my screen 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 running 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 lakh 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 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? Zepto and all those things. All those things every if I talk about this websites also, they do 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 that 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-uh. 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 for storing huge volume of data. Right? You for storing huge volume of data you need a database. 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 datas 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 ate 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 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 a 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 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. Give me a moment. Okay. 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 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 persons is 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 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. 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 it's basically decided by the DBMS it's decided by the DBMS okay are you getting my And SQL and DBMS will 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 is 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 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 to 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 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. 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 to 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, 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. Ex 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 too. 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 these people will be present. Okay, if I talk about you need a library infrastructure, 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 memor. Okay, the server should be uh so in the server only we have to connect to run the DBMS. 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, there are multiple DBMS softwares are 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 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. 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 data 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? Okay, it is a database management system software and SQL is just a programming language like I'm 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 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 customer 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 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 one is your RDBMS then you have your key value pair. So what happens there are 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 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 Postgra SQL. 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 little bit different but the query right the query you write the SQL queries are exactly the same. Okay. These are all the MySQL. Yes, we do. Yes. 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 hap 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 be 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. All right. So now we are going it is not outdated. It is not outdated. Is 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 are 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. 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. 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 are 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. Only one. Only Malvika. Anyone using Mac system? Okay. Aneli is there. 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. 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 MySQL installation for so I'm a non-mac user so I'm using for Windows only. So that I will be uh showing here 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 M Am I clear? Okay. Now if you click on the link, okay, if you 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 or 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 NL 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. 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 it. 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. 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. 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, 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. 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 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 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? Can Yeah. Okay. Go to the application. Applications plus 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. Yes. Click on the arrow please. Yes. Okay. You have to select two. Okay. Everyone did you notice what did I do? Please turn please wait. Okay. What did I do? I went to this first one. Okay. MySQL 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. So, Chandana 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. Typical customer or complete to choose it. Am I clear that I am repeatedly mentioning custom? Are you able to understand that it is custom? Totally up to you. Those who are not doing what to choose custom I mentioned right you have to go for the custom 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 a 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 will go for the lab. My SQL below is sliding. Okay. Once you're done, 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. Yes ma'am. This one. What did you choose for this? Can you just cancel this please? Cancel this. Cancel it out. Fully cancel. 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'll 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 m. 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. The last option. You have the MySQL installer for Windows. Yes, you have to install only one. It's a 2.1 m. You can check the small 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, Unshare your screen, please. Chandana, are you there? Can you please share your screen? Chandana Yoga, please wait, wait, 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. Yog again. What is the issue? Please speak to me. You can unmute yourself. Okay. Hello. Good evening, ma'am. Actually, what instructions you have given? I have followed the same. But uh still I'm not able to install the SQL. What I'm trying to getting the same are you not getting the same option like Chandana? 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 again you share your screen please? Okay Chand it will take some time for you. Okay because that workbench installation does take some time for everyone also. You can you can share your entire screen. Go for sharing your entire screen. Enter 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, live class uh simplearn.com. Can you just remove that part? Not this one. Not this one. Not this one. What should I say? Uh can can you just move your live class? Right. You're not getting that part. That uh 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 you hide that. Please hide that. I cannot see your complete screen. Not this one. Stop sharing. Hide. Yes. Now go for 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 Okay. Now, it was correct. That was the screen, right? Why are you doing it? Okay, go for custom. Select the custom. Next. MySQL server class. First one. First one. Yes. Okay. Go for the application 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 can the first one first item? No. No. Yes. Here. Click. Click on this. Okay. Click on the status. It's not happening. Okay, one one item go for it's doing it. It's happening. It's happening. It's happening 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? You get 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 Yeah. So, let it happen. Okay. Yogender. G. Okay. Let it happen. Okay. It will take some time for you. Okay. So, I'm unsharing 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 s 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 jodika please wait no worries I'll be take have the lab also we'll work on the lab. It's done. Okay. Okay, Sindu, can you please share your screen, please? Sindu, can you please share your screen? Why I'm 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 ne 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. S 1 2 3 4. Again, repeat also. Okay. Go for next. Next. No. No. No. No. Next. Go for next. Go for next. Next. Go for execute. Okay. Finish it, please. Finish. Yes. Next. Finish. No, 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 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. So now I'm going to show you the lab. So please focus on the lab. Okay. Once you log in, please follow the steps of the lab. Okay. Please follow the steps here. There you go. Wherever you have the SQL, right? Wherever you have your SQL course, go to the SQL course. Go to your SQL course. Okay. Confirm me once you are in the LMS. 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 uh 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 left. Launch lap two two times. Okay. 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 You are getting the MySQL workbench. Kindly confirm me. Are you able to see it or not? Is the 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. 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 you 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 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 slide. 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're 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 workbench is the graphical user interface. No, let it install. Let it install offline version you can use the lamp you can use a lot not an issue. So those who are working with the offline system once you set the password right like you have seen for Sai you have to share your password here like 1 2 3 4 for me also it's 1 2 3 4 only otherwise I might forget right. So once I go for this 1 2 3 4 I'll click on okay so this is a coding environment so you don't have to understand this. So for now this is my coding environment where I will write all my codes here. Okay. So I've shown you the interface here. Now let's go back to the lab. Okay. So this is for the lab users. You are also getting the same thing. The GUI you are able to see the graphical user interface. You are able to see it here. Okay. Now you also have the local instance here. See for those who are able to get it the If you click on that are it is asking you for the password for the lab. Now this is not the password. You cannot use 1 2 3 4 here. Okay. This is the system password. So where will we get the password? Where will we get the password? So please check here. You can see the three dots here. You can see the three dots here. Can you see that? Can you see the three dots? Please drag that. Yes, I think you have already got it. Vikas has got it. Great. So those who are not, this is the lab. Okay, here you have to basically drag it. Once you drag it, you will be able to get the password. Here you have to drag the three dots. Okay, you have to drag the three dots. You will be able to get the admin password here. Yes. Are you getting it? You can cancel that. We do get it for the first time. What you can do? You can click here. Click to paste. You can click here. Okay. If you once you click here, you will be able to notice that you are getting the password. You are getting the password here. Just click on okay. Just click on okay. See, because I'm also getting it. That's okay. Help. let me just drag it for further more. If you are not able to get it in the uh desktop, what you can do, you can go to the start button. Okay? And then go for it. Okay? Now, please check here. Those who are done, please check here. You have the administration, right? You are getting the administration here for the lab users, right? Please this is from the database administrator. Basically what happens is that uh your database right my SQL can be used from the administrator point of view also where we share the privileges we give who persons can what persons can do right if someone joins the organ organization what privileges we do give to that users and if someone leaves the organization we take away the permissions. So these are the things that are done by the administrators right but we are going to learn it from the analyst point of view. So those who are working on the lab you are getting this administration here. We are going to learn from the data analyst point of view or data scientist point of view. So I'm clicking on this arrow. You will be getting the schemas. You will be getting the schemas here. Okay. Similarly, those who are working on the offline, those who are working on the offline, you might be only think that is a change in your GUI. So you is present here. You have administration here. Okay. Not you are getting you have to click on the schemas. those who are working in the offline sai and then I think mentioned puja I believe right who have installed it so please click on the schemas here so this is your code editor so this is your code editors this is your give me a moment code editor where we We are going to write our quotes or you can write your you can this is known as your SQL script. This is known as your script. Okay. Great Raki. So Raki did you get the schemas? great. Now see for you you must who have downloaded it right now or you are using the lab you will be able to see only a single database that is the system database. Okay, we cannot store the data right uh we cannot store the data or we cannot have the uh we cannot store anything without a database. So this is a system database we are right now we are having here. Okay, this is a system database and we are not going to do any changes in the system database. Why? Because if we do any changes in the system database, it may just completely mess out the working of other uh workbench. Okay. So, we are not going to do it. So, we are always going to create our own database. We are always going to create our own database. Okay. Am I clear? Great. Wet. So, wanket please click on the schemas. Okay. You are currently on the administration. Click on the schema. Okay. So, please those who are unable to get the administration of the schemas here. What is the issue? You have to reset your screen size. So, for the lab, right? You have to reset your screen size a lot. See, I'm also I'm not also able to view it. Now, if I go for minimizing the screen little bit, reducing the screen size, I'm able to get that. So, if I want to go for writing any comments, okay, for single line command, I can use this symbol. I can use this symbol. What is this hyphen? Then space this is basically used commenting comment for single line you don't have to write all those things I will be sharing okay and if you have multi-line command okay if you want to display multi-line comment you have to use this symbol Okay, that is slash star and then also you are closing with this and this is your multi-line comment. This is your multi-line comment. Okay, I'll give you some time to do first understand it. And one more thing you have to understand my SQL is not case sensitive. What do I mean by case sensitive? That is there is no difference between so I have to use a multi-line command here. Okay? because it's coming in multiple lines and and small letter and capital letter. Okay. Yogenda can you please work on the lab comment means if you want to display anything if you want to display any line. So you are that is your comment single line comment. Okay. You are you want to give a message. You want to give a message. All right. Now please check here. Why did I mention that? Everyone focus on my screen. Before we want to do anything, right? We need a space for that. We need a database, right? To store the information. So how do we store the how do we create a database? For that we have to write a query. That means we have to write a code. Okay. To create a database. Okay. So the keyword the code I write is basically create and you have to give a name to the database. So I'm giving the name as SQL uh today's fee right? So I have multiple batches. So I'm giving SQL fab as your database name. First write this only write this code please create database SQL fab or you can give any name you can give any name I have given SQL fab because it should be a one word you cannot have two word okay you cannot have two word so I have since I have two word here I have joined it my using an underscore and we should always end the code with the semicolon Can you write the code please? Just write the code. You don't have to write the comment as well. So write it. I will be taking a doc file. I'll be sharing anything. Great. Great. How to comment until lab is how to comment on lab going on. You have this lab, right? You can go for this comment. This database it's slow right now because all of us are working together, database. So, what is the code? Create uh SQL fab, right? SQL PB. That's it. Yeah. Yeah. Please can I continue to use offline? I have already. If your lab is not opening, you have to launch the lab again. Relaunch the lab again. And those who have the online version, please go with the offline version. Now, please check here. Now, please check here everyone. Are you able to write the code? I'm sharing that in the chat for now. Check it out. So once we have written the code, you have to also execute the code. You also have to execute the code. Okay. So how do I execute the code? How do I execute the code? So please check it out. You will be able to notice this thunderike icon with the I symbol. Yogenda, can you quickly message uh the LSM and try to maybe she will maybe she she may try to help you out if you are not able to do it for the lab. Yes, everyone please check. Once you have written the code, you have to execute it. You have to run it, right? How do I execute the code? Thunderlike icon with the eye icon. Thunderlike icon with the I icon. Please execute it. Yeah, you can go for control + enter as well. Please click on that. Yes, there is a difference between that thunderlike icon and I'll discuss later. great. So you go for this you will be able to notice that a message is displayed. A message is displayed in the action output. So Vikas you have already created it. So since you have sorry Nikl you have already created it uh but since you have executed it twice you are getting an error it's already created for you okay check here though we have created it we are not able to see that fab SQL here or SQL fab here are you able to get it are you able to get it no right in the schemas schemas are nothing but databases only okay schemas are thing but in MySQL it's a database it's a container yes okay so what you have to do even though we have executed the query correctly you will not be getting it so you have to go for refreshing it you have to go for refreshing it please click on the refresh icon that is your refresh icon code is enough. You don't have to write the comment check. If you go for this, you will be able to view the Feb SQL right now. So, let me show you in the lab as well. So, for the lab, see this is the one. Let me go for removing this things. So go for this. Okay. I have not executed it. Let me execute. Done. Once I done, I will be able to get this uh SQL FB here. Are you all getting it? Okay, now the thing is we have created the database. Let me drop all those date. Okay, let the database be. Okay, now the thing is we have created the Now we also have to now if you check the structure of the database. Okay. So as I mentioned this is our database. Let me go for the lab only. You will be able to view it properly. So if you expand, you can see this expand icon here, right? You can see that expand it icon here. If you expand it, you will be able to see under the database, you have the tables, you have the views, you have the store procedure and you have the functions. You have the functions, right? So that that is why you know this what is a schema? Schema is basically a logical container which is basically storing the groups of tables, views, stored procedures and functions. We are going to learn about all of this in the coming days. So tables are storing your actual data. tables are storing your actual data So all of you are done creating the All of you done creating the database. Okay. Now once we have created the database to use the data we have to select it. Okay. We have to select the database then only we will be able to work on it. How do I select? Two ways. Okay, two ways of selecting the You can double click on the database. Please check here to select. One of the shortcut is double click on the database. Double click on the database. You can see your database is highlighted. That means your database is selected. Or you can double click on the database or you can write the code. use SQL fab. Okay, this is my name of the database SQL fab. I will go for executing it and again. So you can see my SQL fab is selected. My SQL fab is selected. No, no, there is no shortcut kit for the comment. If you wish to write, you have to go for uh two time hyphen then single line comment right under a space. Okay. Now please everyone see as a analyst we'll hardly go for uh creating a table right. We are always we will be having the getting the data and we are going to work on that. Okay. So how do we we will be able to load the CSV file in a MySQL. We will be able to load the CSV file in a MySQL. So how do we do that? Okay. So only thing that will differ for the offline users is basically the path. Okay. Other thing that for the lab users and the u offline users it is exactly the same. Just give me a moment. So please check it out. How do we do it? So everyone please focus on my screen. We are going to import the import the table here for the lab users. First check for the lab users and then I will show you for the offline users. Okay, it's the same thing only the thing that will differ is the path. So offline users if you're able to do it you can do it. The path will vary. Okay. So please everyone to import the table here what you need to do right click on the database right click on the database that you have created SQL fee right click on the database that you have created okay I right click here I will be able to get the fifth option as the table data import wizard table data import wizard Are you getting it? Table data import wizard. Please focus on my screen. Are you able to get it? Okay. There you have to click on the browse. You have to click on the browse. Once you click on the browse, you have to go for the desktop. Go for the browse then the desktop and there in the desktop you will be getting the data sets. Let me know once you are able to get it Are you able to go to the browse desktop data sets? Okay. Anyways, I think I have to repeat only. Click on the data sets. Double click on the data sets. You will be getting here the first option as the assisted practice data sets. Assisted practice data sets. Double click on that and click on lesson five. You can check the path here. You can check the path here. Whatever I have selected desktop data sets, assisted practice data sets. Then lesson five, you have the EMP table CSV. You have the EMP table CSV. Yeah, for offline that is the same thing. You have to download that file. Just give me a moment. I'm sharing that file with you all. Even it is present in your LMS. Just give me a moment. Let me share it here as well. Offline users also I will show you. Just wait for some time only the path will differ. By that time you can download this file. Okay, I'm sharing chat box. Yes, everyone check here. Once you get this file, right? Once you get this file, what I'm going to do, I have to minimize my screen a little bit. Still minimize more. App should have taken up to a new screen only. Okay, I'll just increase it. Okay, once you have got the data file, right, EMP table, you have to click on open. You have to click on open. This is for the lab users. Okay, I will show you for the offline users as well. Once you select the table empath here, please confirm me. Are you able to get it or not? Are you able to get it or not? The lab users. Okay. Then just you have to go for click on next next. Okay. Nothing else. Just go for let me just minimize. Okay. Just you have to go for next. Next. And finish. That's it. And refresh it. And refresh it. Okay. Lab users. Uh, Naim, did you install it today? Did you install it today or are you working with the lab or are you working with the lab or uh this one? Lab you have to relaunch it. If it is disconnected, please go for relaunching it. Okay. Others those who are working with the offline, please check here. Go for this. Go for wherever your database is present. Right? Your database is selected. Right click on that. Go for table data. Again the same thing table data import wizard. Here you have to browse to the file. So that is basically the file I have shared in the chat box. So wherever your file is present right browse to that location. For lab it was present. This was a virtual environment but for you it might be present in your own system. So you would be probably knowing it. Great. Right. So go for next. Sorry. Sorry. Sorry. Okay. Go for clicking on next. Nothing new. We have to do just click on next. Next. Next. Next. Finish. Both the lab users, offline users, are you able to load the file? Are you able to load the file? Yes. Once you are able to load the file, you also have to refresh it. Once you have loaded the file, please go for refreshing it. Go for refreshing it. Have you created that Gori? Have you created the SQL fab database? We have created the SQL fab by writing this create database SQL fab. Have you refreshed it? Have you refreshed it? After creating it, have you refresh it? Okay, great. Similarly, after you have imported the table, you have to refresh it. Then only you will be able to notice the table here. See emp similarly, I'm going to show it here as well. See, I have imported the table. I have to refresh it here as well. I have to refresh it here as well. See if I refresh it. See, I will be able to see the EMP table. Kindly confirm. Are you all done with this? till this part. Okay. Now check if you wish to display. Okay. Display anything. Okay. If you wish to display anything, you have to write the select statement. Okay, you have to write the select statement always remember. Yeah, it will take some time. So those who are facing any issue with the lab, I would request directly ping the LSM for this. Okay. Any issue with the lab. Okay. So directly ping the LSM. So what you have to do na so either you can bring the LSM or you can go for refreshing it. So once your lab is disconnected it will take time. So go for relaunching it again. Refresh it. Refresh your screen. So what happens is that I want to just because you as you can see we have now more than 100 participants here right? So if I just go for uh taking up everyone one by one it will just break the flow. Okay. So for the thing if anyone is fac facing issue with the lab I just want you people to connect with the LS. Okay. I can help you with the technical part. Is it prepare import or import file? Uh is it prepare import or import uh data file? So you have the import table data this one right table data import wizard. So you have to go for that table data import uh import wizard. So go for that. Yes, we can go to next. All right. Now please check here if I what I was saying if I wish to display anything we have to write the select statement. Okay. So if I write select asteric right asteric then from table name. So this is the syntax. Okay from table name. So that is in our case our table name is emp table. Okay. Now what does asteric refers to? All columns it refers to all columns here. Once you have imported the table, you have to refresh it as well. Once you have it as well. Then only you will be able to see the EMP table over here. Right? So if you wish to display all columns, you have to go for select star that is asteric symbol from EMP table. That is the table name. If you do that and if you click on execute, you will be able to see a result grid opening up for you. A result grid opening up for you. You are also able to see how many rows are there. So there are 20 rows. Okay? And you can also expand the result grid here. You will be also able to see it. Are you able to see it? Few more responses. Refresh it. N refresh it here. This one you have to refresh it. Even in your lab you have that then only you will be able to get the table. Okay. This is done. Okay. Now please check this is asteric symbol is used for getting your u you know all columns. It is used for getting all your columns. Yes Hindu will answer that how many rows we'll get there. Okay. How many rows are there? So you will be able to get it here. Give me a moment. If you just expand it. Okay. If you expand it, you will be able to see in the output grid this 20 rows. Are you getting it? Now, basically to display, give me a moment. Asteric is display basically to display all columns right we can also go for displaying specific column okay now if you wish specific column you have to write select select and whichever you want see I'm writing simply like this emp letter anything also you can write capital as well Last name suppose role only this many I want from EMP table whichever columns you want you can name that and from emp table and execute see we will be getting it right out right out let me check out this as If you wish to display everything all columns right then you have to use the asteric symbol. If you wish to go for specific columns you have to mention. Now to display all columns we are going for asterric. To display specific columns we are going for comma. name of the comma sorry name of the column and then we are going for comma here right now suppose now suppose if you wish to get specific rows I want to get only five rows I want to display five rows instead of 20 rows right you check here we are getting here 20 rows all if you just expand it you will be able to see it here you will be able to see it here right so if you wish to display only suppose five rows. How will you do that? I will write the same query. Please check. I'm writing the same query to display five rows. Only thing I'll change is okay. Let me write it here. I will use limit five. So limit is basically the statement which is used for limiting the rows for limiting the number of rows. So now this time we will only have the five rows. See 1 2 3 4 5. You can also check the count of it in the output. See five we are having here. Okay. When you mention select star, select star, that means select everything. that means you are selecting everything. You cannot write like this. Okay, suppose if you wish to go for some other thing that is okay. But you don't go for like this because already already you will be having this already you are having EMP ID over here. So you don't have to go for this. You don't have to because you are going for selecting all columns. So please check here what will happen in this case. You are getting empice. Okay. So that's what is happening. Don't go don't go for that. You are selecting it right now. So are you able to get the purpose of the limit? Are you able to get the purpose of the limit? So if I wish to go for select star from emp table limit 10. So you will be getting 10 rows. You will be getting 10 rows. to always end the SQL statement with a semicolon. Always end the SQL statement with a semicolon. Okay. Now suppose check if you write like this. Please focus on my screen. you will be getting some time to do. Okay. If I write like this suppose limit three comma comma 2 that is starting from the third row I want two rows. I don't want it from the first row. Okay. So check from the first row I'm getting as Roy. Okay. is E20 E260 right we have the Roy colins and that's what we are giving getting here but now if I go for limit 3 comma two so please check what happens here how many rows am I getting only two only two okay so that's what we have mentioned we are not getting the first three we are not getting the first three Three means from which row you are want to get the number from. So you check here. Okay. So I will show you one thing. If I want to limit three rows. Okay. So here we have till we have till Katrina here. Okay. But the thing is that I want to skip this. Okay. I want to skip the three rows and I want to from the start starting three I'm skipping here and I want to get suppose four rows. So I want to get it from four 5 6 7. Okay. So check it out. Yes. Index. Okay. So here we are getting here we are getting four that's the index here starting from one only index zero yeah after three You can also use so I have used all columns right I have used all columns you can also go for specific as well let's go for the unique identifier that is your emp ID Okay, let's go from starting from zero, I want two rows. Let's go for this. What do I get? Starting from zero index, I want two. Okay, so it's the index. Index always starts from zero, right? So I'm pasting it and check try it out. Try it out all those things. Okay. So you have already the link of the file. Please try it out. So there are I I think more than like I can see 99 participants are there or 8 n people have only joined the doc file. Can you please explain? Okay. So this is basically the index number. This is basically the index number. 3x 2 3 is the index. So index always starts from zero. Index always starts from zero here. Right? So if I go for this suppose 3x4 here. Okay. Okay. Let me first explain you this first 10. Okay. So let me first explain you this first 10. Check out Z let me write here. 0 1 2 3 Right. This is Jennifer is three. You can check here. This is 0 1 2 3. Now if I execute if I execute this one select star from EMP table starting from 3 4 right. You are getting third index four rows. No, not from Steve. It's from Jennifer. It's from Jennifer because Jennifer is the third index. Jennifer is the third index, not Steve. Because index starts from Z. Index starts from zero. Yes. Yes. Dhani you can write your doubt please got the purpose of limit. So it's not only you are able to get it by the number of rows you can also get it by index as well. You can get it by index as well. Last thing for today. Okay. One last thing for today. Index as in the line number. So line number we do not consider as the index. Okay. So index is basically at what position. Okay. Start at position. The position starts from zero position. Okay. So index is basically the position it's stored at. So it's stored at the zeroth position. That is your index. index number. Okay. Now check here. Now check here. Select. Select. Let's go for this only. I'm not going for limit. Okay. I'm not going for limit here. Only this. Okay. And here I'm going for order by Okay. order by salary. Okay, before we go for the order by salary, if you check the salary, suppose if I go for this, if I go for only this, I can see the salaries are not arranged in proper order, right? Not arranged in proper order, right? No ascending order or no descending order. We are having 7,000 6,000 500 3,000 2,800 again I'm getting 5,000 7,500 so it's a random order right but if you wish to sort it if you wish to sort the data you have to write here order by okay you have to write order by and then the column name so I want to sort it by the salary if I don't if I want to sort it in ascending order that is okay order by salary. So now check. I'm getting it in ascending order. Order by Order by is used for sorting. Order by is used for sorting. Uh Zero is the first row. N zero is the first row. That is your Roy I believe. Right. Yes. By default it is by ascending. By default it is by in ascending. Okay. Please focus on what I'm teaching right now. You can ask me your doubts later. Okay? Just because we are now discussing regarding the order by let's focus on the order by. You can ask me just uh like after 1 minute you can ask me regarding the confusion you have in your limit as well because that time you did not ask. Okay. So if I don't mention anything it will be sorted this it is basically sorting in ascending order. Okay sorting in ascending order. If you want it by the highest salary you have to mention DC. Okay, you have to mention Let's go for this. This time you can see the data has been sorry the data has been sorted in descending order. For ascending you don't have to mention anything. For ascending you don't have to mention anything. So order by is basically used for sorting. Okay, I'm sharing it here and then I'll be taking up your queries. ASC is not required. Okay. So by default it will be in if you don't mention anything only the column name it will be in ascending order. It will be Okay. So the thing is that if you have confusion regarding Okay. That's all from my side. I don't have any uh question regarding like I'll not teach you anything new right now. Okay. So we'll also discuss about uh tomorrow's class. We are going to discuss about the operators and all those things uh in tomorrow's class. Today stay back uh if you have any confusion. Others I would request you all to share the feedback form. Your feedback link has been shared. If you have liked the session, you can rate the session as five or anything less than five, you can mention the comment as well. So please check your name. If I go for select star from EMP table, right? So if I go for displaying everything, what is the first name? I'm having Roy Collins, right? So if I want this is the zerooth place, zeroth index, right? The first name is stored at the zeroth index. Now please check here if I write here limit starting from the zerooth index I want only two rows. Starting from the zerooth index I want only two rows. If I execute it we have discussed about. So I'll just go for the demos first. We now know how to a database, right? We now know how to create a database. After that, how to use the database? How to use the database? And then we will be we have also learned how to import import CSV file into a table, right? And we have looked into once we have done this, we have also looked into few clauses like we have looked into the select statement, right? We have looked into the select statement. We have looked into your limit to limit the number of rows. We have looked into your order by. This was what we have covered in yesterday's session. Those who uh don't have it, those who don't have it in your installed in your machine, the offline version, please go for your lab and that is also expected. I did mention that uh you should get your lab ready 10 minutes before the session. Okay, totally up to you. Okay, totally up to you. Okay, we'll look into that. Okay, aka Okay, now shall we proceed? Have you all have your data imported? EMP table imported? Those who are working with the lab, have you imported the EMP table? Have you imported the EMP table? Because those who are working with the lab, those who are working with the lab, you have to do it every day. After 5 hours it gets reset. So now let's go for doing an example solving. We'll do a revision now. Okay. Please check here. Retrieve the employee details. Retrieve the uh employee details. Okay. Having having Okay. Retrieve retrieve five employee details. Okay. who are having or who are getting the highest salary. Can you try it out? Retrieve five employee details. What is the issue? Punam others please check. Retrieve five employees who are getting the uh highest salary. let it happen. Let me show you here. Okay, for me is executing. So you can see here retrieve five employee details who are getting the highest salary. I did not mention the column name. I did not mention the column name but yes I did mention regarding the employee details. So what I can do I can simply go for select star that is all columns from EMP table. Right now I will be going because I have to get the employees with the highest salary. So for that I have to arrange the data. I have to arrange the data. Sort the data. I'll go for order by order by salary and I'll go for DC descending I'll go for DC descending order right after that I want to display only the five employee details only five so I'll go for limit five always uh remember that limit is used at the last limit Limit is used at the last. Okay. After order by we can go for the limit. Limit is specify how many rows you want. Right? If I go for this see these are the people. So first we have 16,500 14,500 11,000 10,500 and 10,000. Is that okay? Okay, you if…

Transcript truncated. Watch the full video for the complete content.