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

Welcome to the SQL course. Data is at the core of virtually every business decision. Today, companies collect vast amounts of data from website, app, payments, customer interactions, and much more. But collecting data is the beginning. The real value comes from knowing how to retrieve, organize, filter, and turn that data into actionable insight. And that is where SQL becomes one of the most powerful skills that you can learn. This course is designed to take you through SQL from the basics to more advanced concept in a very simple practical way. You will learn how databases store information, how to write efficient queries, filter data, join multiple tables, perform calculations and much more. Step by step, you will gain the confidence to work with real world data and solve business problems with SQL. But it's not just about learning SQL commands like select or where. It's about learning how to ask the right questions, structure data, and use the SQL to solve real world challenges. Here's what we'll cover. First, we'll start with the basics of databases, why they are essential, and how SQL helps you work with large data sets. Next, we will be exploring how to retrieve and filter data using key SQL commands like select, where, and, or like. Then we'll be diving into table creation and data manipulation with commands like insert, delete, alter as well as the role of data types in databases. After that we will cover joins relationships including inner join, left join, right join so you can combine data from multiple tables. We'll also go through aggregate functions, group by having so you can summarize and analyze data in a very meaningful way. We'll also explore important concepts like primary keys, foreign keys, constraint and transactions using commit and roll back. Now, if you're looking to take your skills to the next level and launch a career in data analytics, I highly recommend you checking out the data analyst certification course by simply learn. Now, this comprehensive course will offer a master certificate from simply learn and certifications from Microsoft adding a valuable boost to your resume. You will learn the key tools needed for data analysis like SQL, Excel, Python, Tableau, and PowerBI while working on real world projects. Plus, the course offers job assist to help you prepare for interviews and connect with top employers. So, what are you waiting for? Hurry up and enroll. Now, the course thing is mentioned below. Now, before we move on, here's a quick quiz question for you. 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. If you're asking me about database, try to understand database is a collection of database objects. So I'm writing something right. So this one is okay for you because I'm not good in writing because always I'm using the keyboard. Okay. So but I'm to make the inter interactiveness in the session. So I'm using what is that one? So by writing so something here. So if you are asking me in real world what is the purpose of databases means any application can store data can store data in what is that one? So database only correct that is the first thing if you are developing any application for example so the Facebook application and also Amazon application all these applications they are developing they want to store their data per suppose those for suppose if you're taking Amazon so Amazon wants to maintain the products details in the database. Amazon wants to store or insert or update all those data in the database. Even if you're posting some post in the Facebook also, so all the post details we are storing in the database only, right? We are storing in the database only. But if we are talking about these databases in databases also we have so different types we have types of what is that one? So first one is SQL databases. So or otherwise we can call it as what is that one. So relational and another one is what is that one so non relational so that means we can call it as no SQL and also we have so recently we can see we have vector databases are also available so might be in some articles we can able to observe vector databases. Uh we are using in AI especially in artificial intelligence to store the data in a different format. But we are not focusing on these vector databases. We are focusing on only what is that one? So relational databases but what is the relational database? What is the relationship between this relational and NoSQL? No SQL databases. These relational databases also we can call it as SQL databases. Right? So internally these databases are using SQL. SQL means what? So structured query language. But NoSQL databases we are not using SQL. So we are using NoSQL. So which is nothing but uh we are not using SQL query language instead of that. So these NoSQL databases are providing some APIs but you are all new but I just want to uh give you some information. So what is relational database and what is the at what type of situations we can use relational databases and at what type of situations we can use NoSQL databases. So let's take a scenario simple scenario. So somebody's questioning so relational databases. Okay. So Priti I think you're asking oh you're answering. So if you're it is a relational database it is establishing a relationship between the structured tables. But it's not something like that. So we can try to understand for example. So for example let's say we are having employees database for suppose. What is employees database? For example it contains some employee table and also what is that one? So the employee and also some other tables might be in that according to the application there might be some other tables will be involved in that particular application right there might be some other tables will be involved in the particular application always like one variable in common it's not like that so try to understand so first if you are talking about relational databases this right so we have employee number name or otherwise I'm just taking so another database for your understanding so take any social media application as an example so like Instagram can you please tell me in Instagram we have so the post if you're posting a post so post ID and also the content of the post so like some other details for suppose the post ID and also content and also the creator of the post and also date some fields. Can you please tell me is it a best practice to keep this post uh for suppose Instagram application can be developed by using so the uh relational databases no why what is the reason relational database tables for example if you are talking about yeah rely on what is that one so the schema and the relational databases we are relying on what is that one. So the schema schema means what the structure for example if you are taking so the content so this content must be only one type that might be string or otherwise text we can say only in the Instagram we posting only the content only the text type of content always it's not like that right in Instagram so might be I am posting some text. Some others posting might be video and some others are posting audio. Always we cannot expect so the content should be text. So in such cases so the relational databases are not suitable. So if you're asking me that what type of situations we can go for relational databases is so always whenever we are dealing with what is that one? So some common schema across all the records which we are inserting per post then we can go for relational databases. So but what is database first of all? So database is mainly for storing the data of course for what purpose? Storing and manipulating data. So simple definition is storing and manipulating the data. storing, manipulating and securing. So the data. So for that one, so we have so databases. If you're asking me in real life, what is the purpose of databases? Means we are storing our application data in the database and we are manipulating. So like we are inserting, updating, deleting, all those operations we are performing. Correct? All those operations we are performing even if I want to maintain my calendar for suppose I have a separate okay whatever the meetings I scheduled and whatever the activities I'm attending right so I have a separate application this application is keep on updating so the records in the database but as a developer we have to choose which database is required which database we have to select so that is SQL database or NoSQL database or something like that. For example, if you are asking me if you are going to store employee records for for example employees. So we have an employee table which is capable of holding all the employee records. So we have employee number and employee name and address. If you're asking me so this employee number whatever the details you are entering in the database whatever the operations you are performing right so that operations are mainly for what is that one so manipulating database for example so here I'm specifying so one sur so he suppose so two subu from hydroat Okay. So we are proing some details R3 John from San Francisco. So now tell me so all the records are following so the same schema right? So this record is following the same schema. All the records which we are inserting. So all the records are following the same schema. Schema in the sense the structure. So this one requires employee number. Employee number should be of type integer. So what is the schema for this employee table. So we have employee number whose type is integer and also the employee name whose type is text type and also the employee address whose type is also what is that one the text type. So what I'm saying is whenever we are having structured data structured data in the sense all the records which we are inserting should follow the same schema same rules which we defined in the schema. So what rules we define? So we define some data type we define some constraints all these rules should be satisfied. So each record so then the type of databases we can call it as structured So structured databases yes but uh these structured databases are also relational right if you are asking me first I'm talking about so the structured manner structured behavior with respect to relational databases but after that might be I will think I will talk about so what is a relational database also so first try to understand so this is all the tables are having certain schemas schema will be defined per yearly. So for example another example I am giving for example if you are taking so the department table suppose this one is having so department number and department name and department location this is also what is the data type text data type so what I'm saying is almost all the records which we are inserting so you must follow the certain schema That means you must provide so department number value as integer and you must provide so department name as text and location also you must provide it as text but all the applications just think about yourself all the applications will support this one for example let's say if you are having so HR system for suppose uh or otherwise HRM application in HRM application. So what are the roles uh majorly what are the functionalities we have? So they have to manage the employee details and they have to manage their skill details right. What are the skills that the employee have and they have to manage their personal details? Employee personal details. So that means if you're joining in a company might be you have to fill up all these things in portal right? So your personal details and all those things. So like that there are so many things should be associated with an employee. So if you are taking HR system, so that one is a broad system which contains not only very specific details to the employee. There are some personal details and also compensation details for example especially so compensation details how much the company is paying for that employee what is the variable pay what is the normal pay and all those information will be stored in what is that table compensation details but uh try to think about if you're having all these tables So but what about the data whether the data which is present in the tables should be related right? All these tables contains data for example. So these all these tables contains data but this data should be related. Correct? If the data is not related how can you manage the employee details? It's not possible. For example, I'm an employee for example of simply learn for example. I am having so my personal details and my skill details and what type of courses I am delivering and also I'm having some other details also like my compensation details and also some other details which are relevant to me. Right? So all the details will be show stored in a single table. No. So each detail will be stored in a separate table and they are what is that one? So relationship they are having relationship with one another table. But there are some cases we have to observe. So this is super super important case try to understand. There are some cases. So the structured databases are not suitable. So that means especially SQL databases are not suitable. Can you please tell me what are the cases? If you are asking me for example if you are taking Instagram application or Facebook application simple example Instagram or Facebook whatever the post you are posting whether the post is following so the certain structure certain schema no if you are taking post for example each post is having so different content we cannot expect so the same type of data we are expecting from the user Correct. So one user might be posting audio, one user is might might be posting image and one another user is might might be posting video. So we cannot say all the data should be satisfying that that certain schema in such cases. So we can go for what is the databases? No SQL databases. No SQL means the every record present in the database is having their own schema. All the records are not following. So the same schema like structured databases in NoSQL databases. So every record right so this is super important every record. So having their own schema having their So won't scam. So in the sense for example if you're having post suppose the post will be written as so the JSON object so which contains the post ID so 01 and also uh this one is having so some details right so content might be so this is image but suppose and second post if you're talking about so the post ID two So for example, so this is the first we cannot say. So the first post post structure and second post structure should be same. So this post ID is what is that one? So 02 and the content will be so something text per suppose you are keeping if you are observing. So here this one is image, this one is text and also this one contains some extra attributes also for example so name so technology something so what I'm saying is this is one record this is another record so can you please tell me all the records are following so same schema same structure no we cannot expect it is not following the same structure Each record is having so their own schema. So you have to think as a architect for example while developing the application what type of database is suitable in the particular context. If each record is having their own so not common schema in such cases we can go with what is that one. So no SQL databases. Correct? So no SQL databases but uh so if you're observing so if you're asking me as an application developer per suppose okay so I work with both SQL databases and NoSQL databases but the most of the consumption will be what is that one SQL databases only. So as what is that one? So structured structured data almost I'm getting what type of data? Structured data because if you are working in an enterprise applications almost the data will be what is that one? So the structured data if you're speaking about if you're asking me so there are some situations yes we have unstructured data also. Uh yes unless you don't care what is what in in image just need to record that uh the video or image like that type of data. Yes. Yes. Maria so based upon your expectations we have to decide so what is the database and okay all right so you understand so database but I'm showing in a practical way. So for example so what is database? So simply I can say the definition of database will be in your books might be if you're a refresher might be you're reading through books books right in the books in academic books so there are multiple definitions we have in a practical point of view if you're asking me what is database means database is a collection of database objects database is a collection of what is that one? So database So if you're asking me so what is database means database a database is a collection of what is that one? So what are the databases? What are the objects will be present in database? Anyone can you please guess it? So first one is tables. If you are taking any database, so we have several types of objects, tables, views. So synonyms, what is that? Synonyms. Indexes. Indexes are mainly for performing uh improving the performance of a search query. indexes. So, clusters, so functions, stored procedures, stored procedures, okay, so etc. There are several objects present at the database. But the most important thing you want to we are working with this one is tables. We need to understand so how to create the tables and how to relate the tables but we are not working with some other objects might be we are working on views also and we are working on indexes as well and we are not touching so all the objects which are present in the database first if you are a basic learner you should know about what is that one so how to create tables and how to provide the relationship between the tables that this is the First priority and the second priority will be what is that one? How to create views and third priority will be what is the purpose of creating indexes. So the synonyms clusters so functions. So after that so might be we are discussing so we are discussing about functions but we are not discussing about stored procedures and all those are all some advanced concepts that will be covered in advanced SQL but don't think about all these things. So if you're taking any database for suppose that might be varacle or MySQL or any database these are all objects will be present in the database that might be tables or views or synonyms or indexes or anything. So what are the companies that are providing so database solutions? So Veracle right? Right. So is the one of the enterprise level database. Veracle corporation is providing database and also MySQL is open source. So open source license that means anybody can use without license also and DB2. So which is from IBM actually. So this is also one of the relational So database relational database is a concept actually right. So based upon the concept so the multiple vendors they provided their own implementation. Veracle is providing their own implementation. MySQL is providing their own implementation. DB2 and also Postgress. So Postgress is also providing their own implementation. So the postgress SQL we can call it as but in this session in this training so we are using what is that one the MySQL so which is open source right which is open source and most of the intermediate applications right intermediate level applications we are using MySQL so all the come all these database vendors are providing this database softwares but try to Understand if you are taking any database software that might be veracular or MySQL or DB2. So what I'm saying is the objects will be same. So the tables we have to work on what is that how to create tables and how to insert the data and how to work with views and how to work with indexes. These concepts will be common okay across multiple vendors. Is it clear all of you what I'm speaking? Is it understandable? So these are also different companies they are providing their own databases. But OLTP anyone could you please guess it? Anyone have an idea about sop stands for what? Did you heard about this term? Okay. So, WTP stands for what is that one? So, online transaction processing system. I'm just writing it here. What is that? So, online so transaction so processing systems. So, OLTP stands for what is that one? So, online transaction processing system. So, it's a simple right. So for because if you are working with databases how the database being utilized for example online transaction processing system means it is a data entry system. So we can simply say data entry systems. So might be your in daily life you are observing almost all the systems are what type of systems systems. Can you please tell me some examples for OLTP systems means might be you're booking a flight ticket? So booking flights, right? Booking a flight means it involves several operations. So we are entering your data and also we are selecting flight information and all those things. It is a data entry system only right indirectly. If you are booking a ticket through online, you're making your data entry and you're performing uh so ticket booking. So there are several ways we can consider for example so ticket booking and also hotel booking. Uh we can see uh like uh new AAR card creation or new PAN card creation. So these are all data entry systems. So that type of systems are called as OLTP systems. OLTP systems majorly mainly used for performing. So what type of operations? Insertions, updates and delete. So these type of operations we can perform basically in OTP applications. Almost nowadays if you're observing almost all the types of applications are OLTP applications only but if you're asking me what is the difference between sop and AP systems while AAP means what is that one so online analytical processing right online analytical processing be careful this knowledge is important so you should know about whether the system is OLAP system or OLTP system. So if you're asking me so the oil it's an analytical process for suppose you're having huge amount of data for for example so like Amazon customers data if you're asking me Amazon customers data it's a global business right in a global business there are so many customers are there it's in pabytes or zabytes so from the customer data you want to get some ins sites per suppose. So the people who are actively purchasing electronics, the people who are actively purchasing some other goods per suppose. So if you want to perform some analytical operations and you are generating some reports. So this is super important. If you are generating some report based upon based upon so client requirements here we are not performing any insertion operations or deletion operations or anything. We are not going to manipulate the data. We are just performing what is that one? So we are using the data. So for analytics for analytics and reporting purpose right for analytics and also reporting purpose. So that type of systems we can call it as OAP systems. Now we need to understand the differentiation rate. So database we are using in two purposes. Either we can use that one as OTP systems. So for online transaction processing or either we can use that one for what is that one systems. If you're asking me where we can use for online analytical processing means so might be your manager is asking some insights about what is that one. So some business per suppose we need to provide some insights. So finally we are generating the report. How we are generating the report? Some visualization report might be you are representing the data in a visualized form uh in the form of bar chart or otherwise pie chart or something to differentiate the sales or to differentiate so the data or suppose. So such type of systems we can call it as OAP systems. But almost if you are observing in government offices almost all the systems are what is the OLTP systems online transaction processing systems. That means through applications. So we are inserting the data, we are updating the data, we are deleting the data, all these operations we are performing. Is it clear all of you? What is OLTP and OAP? Do you have any questions? I'm just looking with the chart I think. So previously I'm not addressed any question. Uh when it comes to database objects, we need to create a database from scratch. Yes. So that is correct. Maria can you give some examples for the tables and other types? Okay. So I will give you some examples. No worries. First basic question is can you please provide some examples for OLTP and OJP? Okay. You're working in a company or suppose you are working as a customer support engineer for suppose or customer support. You're working in a customer support. So what we have to do? So we are receiving calls from the customer and we need to raise the complaint or something. Can you please tell me? So raising a complaint is a WTP or OAP. This comes under what is that one? So WTP correct? Yes or no? So raising a complaint comes under what type of system? WTP system. So why we are entering? So complaint details. So what is the cause and everything? So we are raising a complaint as a customer support engineer for suppose. For example, so somebody's questioning, somebody's raising uh asking me as a customer support engineer. So, uh my ado a devops system is not working or otherwise. So, something there is a problem with my laptop. What I have to do? I need to fill out some form right and I'm raising a complaint. So, that type of systems are systems. If you are raising a complaint so automatically what happens? So that complaint will be received by IT team right? So that complaint will be received by the IT team. So again IT team is resolving that problem. So IT team is trying to resolve that problem. So they are updating the status right. So they're updating the status. So updating status is also comes under what is that one? So only because already have that data so they are updating the data. Some other examples might be easiest examples. You are booking a flight ticket. So booking a flight ticket. So booking a flight ticket comes under what is that one? So OLTP correct? So online transaction processing. But after that what happens after booking flight ticket so you're not uh possible to uh continue the journey on the particular day. So what we have to do so we need to update the booking for suppose we need to update the booking. So this is also comes underp. So that means what operations you are performing on the data might be insertion or updation or deletion all these comes under what is that one operations can you please tell me so some examples related to related to operations online analytical processing mostly the data analytics people right so data analytics so these people they are using some tools so like powerbi So, Microsoft PowerBI and also SQL and they are using some Python all these tools they are generating. So, this OLTP oil processing perose means what? So, online analytical processing analytical means what? So, they are going to perform some process. The major outcome will be what is that? So they're expecting for some report. So the outcome will be so they are analyzing the data and uh finally they they are generating some report right for reporting they are using some tools like PowerBI for analyzing the data. So they are using SQL and Python. Okay. Like that in each stage there are some tools will be used but finally expectation will be so they are going to generate some report. This report will be used for what is that one? So decision making. All right. If leadership want to make any decisions they will use this report. So if you want to so generate report by analyzing the existing data. So then we can go forward that one. AP systems there are two parts for you right. So one is you have to work as work as wellp developer per suppose. So WLTP developer per suppose system developer which is nothing but app developers. So mostly app developers which is nothing but web or mobile or any application developers. So all applications comes under what is that one? So the WTP systems only but if you're going for online analytical processing. So if you are going for online analytical processing so mostly data analytics comes into the picture right. So they have to generate the reports they have to get the insights from the data. So most of the professionals will be from so data analytics. So for that one also uh we need SQL right we need SQL we need Python. So some technologies we need Python and we need some tools for reporting. So like PowerBI. So some tools are which are required for reporting and all for app developer. So we need to learn Java or Python. Okay. We need a so what we can say we need to learn full stack development. We can say full stack development. This is one track. But most of the people nowadays trending is what is that one? So this is data analytics right. I can see even in simply learn or outside also the people who are more concentrating on SQL so they are migrating to this area. So like data analytics so the people are from so different domains right so marketing HR so the finance so all this not only finance banking of course finances comes under banking only and also insurance so there are different domains the people are working so logistics management right so management is also one of the important domain so why these people are learning so the SQL the reason is they have to transform their careers into what is that fun so the data analytics yes very good so the medical good question so medical and all those things so what is the Difference between Python and R means there are lot of differences is there but I cannot discuss sak here uh because this is not a Python session right? Python and R R is mainly used for machine learning. Okay. So the Python itself it is providing some libraries like scikitlearn uh tensorflow. So some libraries that are very good in what is that one? So performing machine learning operations. So just for your high level. So I just want to understand your track actually. So can you please post it in the chats? I just just observing what is your track whether you want to become an application developer or your focus should be on so data analytics. What is your track? So could you please post it in the chat? I just want to understand see ultimately I'm getting so like data analyst data scientist these roles are getting demanded nowadays in the market so your focus should be on what is that once working on data only I cannot see the application developer that's gone I worked as an application developer previously also I worked with Java many number of many years uh Java front end technologies I can able to develop the full stack applications very quickly but nowadays you know so like from 10 years uh or 7 years so this data is getting very demanded the people who are having so very good domain experience they can easily handle the data they can easily understand the data like that so that This is a okay I will tell you simple example why you are learning SQL what are the roles might be you are suitable for so if you are learning SQL the first most thing is your domain knowledge so plays important role in your job and second one is your technical knowledge right so what that once your technical knowledge and this technical knowledge after that so usage of AI tools so the third one whether you are comfortable with AI tools or not like that so I think uh Sudha is asking some question for entering day-to-day data so we can use OLTP for generating reports and making decisions. Yes, we'll use OLAP. Correct? Yes. Correct. But when coming to the applications, if you are observing, it's a combination, right? If you're observing some software applications, it contains all the parts. Some of the parts will be OLTP system, some of the parts will be analytical processing systems. If you are logging into the application in HR portal, HR can able to get the analytics how many employees are going to what is the attrition rate and all those things there comes under analytics right how many people are not interested in the company HR should know if you are logging with HR details the application will display how many employees are leaving next month how many employees are leaving next year all the analytics might be HR can able to attrition rate and all based upon the attrition rate. So might be HR can able to initiate some what is that one? So recruitment plans and all in the similar way new employees are getting onboarded in the company. If new employees are getting onboarded means that type of system is OLTP system. Correct? The new employees getting into the company means they have to create new user. So new user for that particular employee all these things will be taken care by the HR people. If you're talking about the HR application that application contains both OLTP and OAP online transaction processing and online analytical processing but try to understand the difference is analytical processing is more about what is that once doing some analytics and getting insights from the data for decision making. might be improving sales and improving the customer experience or improving some other details. These are all decisions which is required for management level right which are required. So at management level is it clear all of you what I'm speaking so that's why most of the people like I can see from your personas mostly you are interesting in what is that one analytics side and also it is not easy right so if you are getting into an application developer right you have to learn Java and all these tag it will take many time many years but uh nowadays it is becoming simpler but what happens means getting into the analytics job so data jobs any data job any data job so it is getting demanded nowadays because because of this machine learning and AI and generative a all these stuff is it clear all of you got some idea so got some insights what exactly your career path and Why I'm taking so might be somebody of some of you might be asking me question so why subu you are speaking all these nonsense so you need to understand your path right so but what are the difficulties in that path also you have to understand what is what is the effort you have to keep also you have to understand so that's why I just speaking nearly 1 hour about what is that so what are the different paths you can choose like that. Is it clear? So can I proceed further? Let's jump into our concept. I'm not going to spend more time with that one. I already brainstormed a lot. What is the path you have to select? I am suggesting so mostly if you're having domain knowledge, you are very good with your domain what you are working better with analytics. If you're having so already so that I'm a good in Java, I am good in so Python or any programming language. So you can go it as what is that one? So the fullstack developer and use SQL and all those. The fullstack developer can easily transform but the based upon the domain right. So I'm in banking or suppose my domain is banking. uh if I want to developing in logistics per suppose I want to develop an application in logistics so I'm new to the domain maybe I have to understand something what are the operations of logistics and how this one works and all okay like that yeah so now when coming to the databases the first step what we have to do is so we are using what is the database we are using so MySQL So throughout this session so we are using so the MySQL database I am encouraging so to install so your personal machines because you can simply learn is providing the lab also but I am suggesting to install so what is that one so in your personal machines as well. So I will guide you how to install so install MySQL. So in your personal machines as well or suppose if you are working from company don't install it. That means your company laptop don't install it. So if you are using company laptop so don't install so the MySQL only in personal machines only you can install. So because there are some IT restrictions are there in the company laptop so don't install it. So if you want to work with databases, there are several databases we have. So maybe you're asking me why you are using only MySQL because this one is open source Okay, we don't want to worry about licenses and all. So that's why I'm using MySQL. So where to access SQL means I will tell you. So just wait for some time. Yeah, where you can install it. All those things I will tell you. So just you can observe. So go to the Google just follow my steps. Even if you want to ask me to repeat I will repeat it three times but please bear with the instructions. Don't write on your company laptops because the company laptops does not allow these installations. So I'm just installing. So the MySQL or 8.1 or 8 MySQL 8 download for suppose you just type in this keyword. Mhm. What is that one? So the my escalate download in the chat you can go to the first link so you can see so any 8 8 version is sufficient so 8.0.45 45 or any version is sufficient no worries. And uh the operating system most of the people are using Windows only. So you can go with the Windows operating system. So if you're coming down we can able to see different sizes of this uh one right or otherwise you can see click download page. I think uh uh nam uh for the Mac we have to check. Okay. So because we have to select DMG file right so in the Mac so we have so the Mac OS also available so we can just download that particular one so installed what you installed actually so you followed some options and installed some setup right so but what happened behind the scenes what are the installations we made so those are all super important things we have to understand if you're asking me so the MySQL or any database software, it's a server software. Please listen carefully. This is super important for any database or anything. Uh so, so that is the problem. Correct? You installed workbench. Workbench is just a client. Okay. Just wait. Okay. I will come back to you. Sims, I need to interact with you. Okay. I think OB yeah I can just wait for some time after the discussion I will come back to you I know so different experiences so try to understand first what exactly you done up to now if you are doing installation right so this is the step if you are doing installation there are two things. First what is this MySQL actually MySQL or Verac or whatever it may be this one we can call it as DB server. What is that? DB server. So in a company if you are working in a company so this installation cannot be done in your personal machine. Your database server is located in some remote machine some virtual server. For example, uh so my company for example I am working in some bank my company main branch is located in Hong Kong or otherwise United States per suppose. So my business is more related to what is that one? So United States. In the United States I need to maintain so my database server right. So for that United States I created one uh virtual machine that means I need to create one I need to maintain one my DB server. So in the real environment I'm talking about so DB server means what? So that is nothing but so the MySQL server. But in your training purpose just for training purpose we are installing server software in this machine. Server software and client software both will be installed in your machine. But try to think about in a real environment server is not in your machine. So database server, database software will be installed in a separate location. So separate infrastructure will be provision, separate infrastructure will be maintained for the particular server. But you are a developer per suppose for example you are an SQL developer. So you want to communicate with that server. Correct? You are an SQL developer suppose or SQL developer or otherwise what we can say you're working on analytics so you want to communicate with the server so we need some tools correct we need some tools to communicate with the server so if you are working with especially MySQL so MySQL is providing one tool called as what is that one MySQL workbench. So it's a graphical user interface. So this is a GUI tool. So by using this GUI tool, so we can able to communicate with the MySQL server which is running on. So might be my server is located in London or USA or Hong Kong or anywhere because when coming to the business where is their business location per suppose the bank is located in somewhere some other location or the particular business is located in some particular region according to that region so they are maintaining their server in different locations but as a developer we need to perform the operations So we are going to connect to that server with the help of some tool some graphical user interface tool. So GUI So graphical user interface tools So with the help of graphical user interface tools so we can able to so communicate with the servers actually. So what is this graphical user interface tool? So that is nothing but MySQL workbench. So whenever we are doing installation right for training purpose what we are getting. So for training we are doing so full setup right full installation we are choosing full installation so while doing full installation so we are getting some MySQL 8.0 zero right so that is one option so which is nothing but server we need server engine so server engine which is mainly for processing MySQL statements and also we need some client tool right so which is nothing but workbench so workbench is called as what is So one of the client tool which is mainly for communicating with the server and also we have so some other tools also some other softwares also will be installed. So MySQL router what is that? So MySQL router for example if you are working as an application developer if you want to connect to the MySQL so the application wants to communicate with MySQL. So we are using so MySQL router but right now as a part of this training this is not essential and also it is providing so MySQL shell. So this is also another tool. So this one is providing some bash shell some Linux shell to communicate with what is that the MySQL database server and also it is providing some command line also. So these are all tools will be provided for you. So most of the situations we are using these two right one is workbench. So what is the reason we are using mostly this one is GUI so graphical user interface we don't want to worry about writing more code the command line so if you want to write the query okay so you can use what is that one so if you want to write a query through command line so if you want to execute the query so we can use what is that one so command line like that. So we have so the all these options will we are getting with full installation but in the company environment we are not responsible for installing MySQL. So that is database server is already running. Okay. So the MySQL server is already running in some other location. So with the help of workbench we have to connect to that server with the help of some protocol called as TCP by IP. So this TCP by IP is a network protocol. What is TCP? TCP stands for transmission control protocol which is mainly for so establishing a communication establishing a channel between client and server applications. But to establish a channel between the two applications, it requires some port number. What is that? It requires what is that one? So the port number. So every application so that may be MySQL or VR or otherwise any application if you're running that application is running on some port number. So during the installation so we can see this port number. What is the port number?306. This is the port number. So by defaultly the MySQL is getting okay. So you don't want to worry about uh attaining the port number explicitly. So MySQL is getting this port number by default. You don't want to worry about anything. Just click next next. Next next. So automatically your installation is getting finished. But the thing is think about it's not MySQL it might be my HR application or it might be some other application. Every application if you are running the application is associated with what is that some port number. Okay. I think Saraki is talking about. what does MySQL server contain? Yes, all client and server all are included. Correct. You can get server software and we can get client software also in your machine itself for training purpose. We are installing both server software and client software both. Is it clear SOG? Okay. So once you done the installation, right? So your server is running or not, how can you check it out? The next question is what is that one? So the next question, how can you verify so whether the server is running or not? So that is the complex question right everybody will have in mind how can you verify whether the server is running or not. So for that one so we have to go to the services. So in Windows if you are running any application right so that application is running as a service for example if I'm running so MySQL so MySQL is running as a service you can go to the services so look at my services see what is this nonsense so there are so many services are listed here the reason is in my machine by default Ely there are some windows services are running along with that one. So there are some applications are all installed. So adab acrobat this one is for PDF opening PDF files right. So that service is running. Yes. Similar way my MySQL software is also one service. Please remember MySQL is also what is that one? One service. So just type M and we can see so MySQL 80 here. Look at this. All of you can find the service name during the installation. So I notified what is the service name it is taking MySQL 80 by default because we installed from MySQL 8.0 version. By defaultly the service name is taking as what is that one? So the MySQL 80. So we can just keep the service name as it is and we done installation. The same service name is getting reflected here. So try to understand and also what is the status? Of course it is running. Running means by default whenever I machine I'm starting my machine right by defaultly the server is getting started. So could you please check all of you in Windows services all of you can able to find this MySQL 80 service those who installed MySQL in your machines and like this message all of you can able to find so MySQL 80 service is running where did you where did how did you uh open this services. Uh yes, I understand. So again I am showing. So please look into this one. So go to search box in Windows and just type services. So we can see all the services and in the services you just click on any service type M. M means what? So I need to display only the services which are related to MySQL. That means M which is starting with M. So we can see so the MySQL 80 service which is running already and just explore try to understand the how the Windows machine is working. What are the other applications are running and all those stuff. So please like that message you can able to identify the MySQL 80 service is running or not. So I'm suggesting so this MySQL service is running or not. So it is running. So the next step is what is that one? So check it. So the client tool, what is the client tool? So MySQL workbench. So look at this. There are so many client tools are available, right? What are the client tools are available? What are the tools available to connect to the server MySQL workbench? So the MySQL workbench. So click on that MySQL workbench. You are getting the screen right. You're getting the screen. So I'm just uh expecting so all of you please open that MySQL workbench and like that message. Then only I can able to understand all of you can able to find that one otherwise I cannot identify. Please do that step and like that message. So still we are not connected. So we have to connect to the server. So how to connect to the server? Can you please tell me anyone? Can you please post it in the chat? What is the which port number server is running? And which port number server is running? 3 06. Correct. Right. See here already some MySQL connection is available here. Can you please tell me another question I'm asking the server is running in my machine or remote server? Remote machine. Remote means some other location server is running or in my machine itself it is ser running my machine itself not remote. S correct right. If you are accessing so simply learn lab. So good question. What is the difference between remote and local? If you are accessing simply learn lab, right? Might be the simply learn server is located in USA. The lab server you are connecting from MySQL client to what is that one? From workbench you are connecting to so the simply learn server. But here we are installing locally. So that means in your in my machine itself. So server is present. So you can just double click on. So this MySQL connections local host it is asking. So the password what is the password? I provided what is the common password I suggested root. So click okay. So that's all. So you are successfully connected. Yes, almost. If server is running means what? So you are successfully connected to that machine. Others here it is populating. So connect to in the MySQL connection it is just showing. So local instance just double click on that one. And what is the password? We have to provide it here. What is the password? So root, right? So click okay. That's all. But by default it is showing administration and schemas. If you want to see what are the databases present in your environment that means in your database environment. So you can just look here we can see so the banking DB employs all these databases right. So like that no you have only three schemas will be there might be HR CIS and secil so in companies do we use same MySQL 80 for coding. Good question. Right. So in companies you are asking me so to use so same MySQL means no there are different tools are there you must be that's why I'm explaining right so client tool is different server is different so the tool there are several tools are available so just I'm naming here some of the tools so might be you can expect if you are working in SQL environment so SQL devel developer is one of the popular tool and also toad but most of the people are using so the SQL developer and MySQL workbench what is that one so MySQL workbench but all the tools are having similar options if you're asking me these tools are very simple right so only we can connect and after that these tools are providing options for you to write the SQL query and execute the SQL query. Okay, so no worries. These tools are very easy to use it. How you are using Microsoft Word? How you are using Microsoft SQL in the similar way? We can use these tools. No worries at all. So writing SQL query is difficult. Writing using the tool it's not a problem, right? It's not a big deal. Yeah. Yes. The procedures will be almost same. uh it's based upon the tool okay so I cannot say like you can easily mingle with the tool that's what I am saying if you know if you you're having knowledge of using so what document how to format what document how to increase size and all right so if you're having that knowledge that is sufficient to use this tool that's what I'm trying to tell you is it clear all of Yeah, see look at this once you are getting so connected to this database server right. So first step is what is that one? So we have to create databases just give me a second. So I'm deleting all these databases which are already present. These are all created by me previously. So employee don't delete any database from your end. So these are all created by me. So for the previous sessions or something. So drop these databases. So I can see like most of the people these are all the default databases which we are getting correct. So these are the default databases which we are getting. Yes. So should preach ready. So you're asking uh how to reset the database. There is a procedure will be there but I cannot discuss here. It will take 1 hour. So it's a complex process. Okay. So that's why I'm requesting. So if you want documentation or anything, I will share you the link. If you want to reset the password, you can raise the ticket also. No problem. But in the session, if you want to teach how to reset the password, it will take more time. Actually, you need to troubleshoot where exactly you are facing problem. Is it clear? So if you want so the same procedure, I will tell you. Okay. what are the steps you have to follow and all. So we have so three databases like HR secila and also sys if you want to create so another database for example so managing employees details. So how can you create the databases? You just right click here. You can just click on so create schema. That is one step. Correct. Or otherwise. So go to here SQL tab here. So if you are clicking so SQL tab. So you're getting so this uh SQL file right here I'm specifying. So create database. So database name. So what is the database name? HR DB per suppose HR DB or otherwise we can say HR database. So this is the query which is mainly for creating a database. So if you want to execute this query, how can we execute this query? So just click on so this uh look at this first select this query and click on what is that one this option execute the select portion of the script or otherwise we can keep the cursor in the same line. You just keep the cursor in the same line and you can click on this one. So execute the statements under the keyboard cursor. So I'm preferring so first select the query and execute that query. So look at this database is created right in the bottom. Yeah, observe my mouse cursor in the bottom. We can able to see create database HR database it is created or not. It is in green color. So we can refresh. So observe my mouse cursor mouse pointer if I'm clicking refresh I can able to see one database right what is the database HR database so I'm just sharing this query in the chart so HR is by default present I am provided my name as HR database like that so different name I am providing it in the chart so please Check it out whether you can able to create the database or not. So if you want to open this SQL file right so how to open if you want to open this SQL editor. So we can open we can just click on what is that one. So this new file. So automatically this one will this will open the editor actually. So this will open the editor. Is it clear? So please create any database for suppose employee database or HR database. All of you please create two databases and let me know. Okay. So let's start with the discussion. So I'm just connecting to the MySQL server. How can you know? So whether the MySQL service is running or not. So just go to the services. I'm just checking so my MySQL service is running or not. How can I check it? So just I'm typing so services. So in the services we can see so many services are running. So especially I'm looking for the MySQL service. Just type M. If you are typing M you can able to find this service right. Could you please check check it in your machine also whether the MySQL service is running or not? Of course in my machine it is running. You can see the status it is stating like it is running. So if it is running means what the server is ready during the startup whenever we are installing. So yesterday we installed the server and after that so we are restarting the machine. So the server is started automatically. So we don't want to worry about restarting the server and everything. So now the server is running. So what we have to do? So we have to connect to that server. So for that one, so we need one client tool, right? What is the client tool we are using? So the MySQL workbench. So this is a client tool. There are several tools are available. I'm not talking about. So only this one is the client tool right. So there are MySQL command prompt is available and also as well as MySQL workbench is available. So there are several tools are available just establish a connection with the server. So from this client tool if I'm speaking what is the client tool actually I'm expecting responses from you. Yesterday already I discussed right? What is the client tool? What is this MySQL workbench? What is the purpose of MySQL workbench? I am expecting responses from you. Please type it in the chat. What is the purpose of MySQL workbench? Very good, Nikita. To communicate with server, right? We have server running in my machine itself. Yes, server is capable of processing. What is that one? So all the details, right? Whatever the queries we are giving, okay, so all the queries will be taken care by the server, my data also will be stored in the But what I have to do, I have to interact. I have to communicate with the server. Yes, it's a engine which is capable of processing your SQL queries and all. Right? So if I'm giving any query, what happens? the query will be executed by the server itself. This is just a client tool. It's an user interface. So from this user interface, we can able to write the queries and send the queries. But I want to connect to that server. Can you please tell me what are the things required for connecting to the server? I think we heard about port number correct and which port number. So the MySQL server is running. Anyone? Could you please guess it? 306. Correct. 306. Yeah. So just establish a connection with the server. So you just double click on this MySQL connections which are already present. I am going fast might be. So I'm just decreasing my pace. I understand. If I'm just double clicking on this MySQL connections automatically it is establishing a connection with what is the service MySQL at the rate of localhost 306. You can look at this service here. This is trying to establish a connection with the MySQL service which is running on what is the port number? So 306 SS will move. So I'm just uh specifying what is that one. So root password. So root is the password. I just connected to the database. So now we have so so many databases. I'm just removing whatever the databases that are present. Okay, how to remove the databases? You just right click on whatever the database you created and we can able to see all the options right which are related to the database. I'm just deleting the database. So, drop schema. Drop schema means what? So, it is deleting whatever the databases whatever the database you selected it is dropping the database. So now we have to create a new database for suppose. So let's create a new database. So for that one we are using SQL right? So can you please tell me what is SQL? Most of the people don't know we are new to this SQL. So SQL stands for what is that one? So structured query language I'm just maximizing this one. SQL stands for what? Structured. So query language. So by using SQL so we can able to perform so different types of operations. So what are the different types of operations we can able to perform? So based upon the operations right. So this SQL also can be divided into what is that one? So some other languages. So I think Maria your advanced learner might be uh just bear with me because most of the learners will be you know uh if I'm going fast right what happens means if I'm not recapping whatever the contents which are already present yesterday discussed yesterday most of the people are missing the connectivity okay that is the problem no worries okay so we'll try to main what is that one? So all the entire cohort right so SQL stands for what is that one? So structured query language what is the structured query language can you please tell me it might be you already in your academics you written some programs but suppose you are having a file text file if you want to manipulate the file how many lines of code you have to write it for example I'm having a text file which contains the employee data if you want to insert data delete data how many for example in C language might be most of the people are go gone through the C language in your academics long back so please remember at least minimum 10 to 20 lines of code we have to write it but what is the specialty of this SQL is with a single line of code with a single line of query we can able to perform what is that one so complex operations that's Right? This one we can call it as fifth generation language very very important thing please remember we don't want to write 20 lines of code everything will be getting abstracted abstracted in the sense you just write the query for example I want to retrieve the data from employee table so you just write so select star from MP we are just writing the simple query right with the help of the simple Simple query we can able to fetch the all the employee details. We can able to fetch all the employee details. That means what is the logic behind the scenes? We don't want to worry about what is that one. So writing 20 or 100 lines of code, So writing 20 or 100 lines of code like that. Could you please increase? We could see zoom a little bit. Yeah. So definitely I will do that one now. It is okay. Fine. I think Maria. Oh, okay. Great. So please give me the sations that type of might be if you are not that uh content is not visible or If I want to write a simple SQL query, right? Here I'm writing simple SQL query. So behind the scenes there is a script will be executed. The script is going to perform operations on the table. It is going to fetch all the records. But one good thing with this SQL is we are just writing two or three lines of script per suppose SQL script. With the help of the script we can able to perform some very complex operations. complex operations in the sense might be fetching the data from the server or inserting the data, deleting the data or might be we are creating a new or we are dropping the database. Okay, all these operations we are going to perform through SQL. But how it is possible? How it is possible means all the database management system vendors. Can you please type it in the chat? Who are the database system vendors? That means who what are the companies that are providing database as a solution? Veracle. Okay. So the MySQL is open source DB2. DB2 is provided by IBM International Business Machines. So these companies already developed some scripts. We don't want to worry about what is that one. So writing some complex program to perform these operations of course. But uh if you want to work with SQL based upon the query we are writing might be all the situations I am not uh retrieval only right. So based upon the operation I am performing these queries can be divided into different languages. One is called as what is that one? DDL. So DDL stands for so data definition language. So data definition language and also DML. DML stands for what? So data manipulation language. And also we have so DRL. So data retrieval language or this one we can call it as DQL also. So data retrieval language. So majorly so there are some other languages also we have might be whenever we are working as a database administrator right. So might be we have to set the permissions and all but the major these three languages we should know data definition language data manipulation language and also data retrieval language. Okay let's observe try to understand so what is exactly so data retrieval language if you are speaking about so data retrieval language sorry data definition language first we are talking about so DDL right so DDL stands for what data definition we need to understand the difference between so data and data definition what is that so data and data definition. You need to get some clarity about this one otherwise you don't know what operations we are performing on definition and what operations we are performing on so data. For example, let's assume that so we have an employee table. This employee table contains some fields, right? So employee number and also name and also address. So we have data employee number one and name is subu and address so some chai for suppose and employee number is to James. So USA can you please tell me what is from this table? So try to understand what is data and what is metadata. I need to know about two terms. What is that one? So what is metadata and what is data? So if you are speaking about so the metadata right metadata deals with what is that one? So the struct schema. So simply we can say so schema what is the structure of the particular table. Yes. So from the academics might be you know the definition of metadata. So it is nothing but data about data. Right. But in a practical point of view if you want to understand so what exactly metadata. So if you are taking employee table so this is the table name. So for example employee is the table name which contains what are the fields employee number of course whose type is integer type and name it's a vat type. So generally in the case of every column right what are the columns for this table employee number name and address. Employee number is integer type and name is ware and also the address is also what is the type? So ware type this is we can call it as metadata of course. So the table name and also followed by column names and what data type we are providing to that column and what constraint we are applying on that column. Constraint means what? So now you don't know about what is the constraint but uh again I will come back I will discuss about what is the constraint and all but uh here try to understand so where carar means what is that one so string so now itself you can feel like uh var means what so simply a string I will discuss about what is the difference between so the car and wcar okay but high Well, integer means all of you know integer means what? It is accepting it. So numeric values only without decimal point. So name means what? It's a string which is a group of characters and address is also a string. If you are working with any programming language, there are different data types are available. In the similar way in the database terminology these data types will be represented as what is that one so the var so int from database to database these data types will be different okay I'm not saying I cannot say in mysq also these are the data types whether these data types are same in other databases means that means in veracle also it would be same no in veracle Instead of integer so we are representing number. Instead of var we are representing var 2. So like that. So don't worry about so remembering all these data types because nowadays nobody is relying on what is that one. So data types and all syntaxes and all everything will be taken care by the AI tools. Okay. only just we have to understand what is the concept so but try to understand so what is data definition data definition if I'm simply saying practically data definition majorly deals with your schema schema is nothing but so the table name followed by the column names and its data types and also So additionally if you are applying some rules, additionally if you are applying some constraints or additionally you are applying any other components these are all comes under what is that? So the metadata but what is data here? Data is nothing but this is the data actually correct. So whatever the records present in this table. So this is called as what is that one? of the data. Is it clear? So all of you understand. So what is the difference between data definition and uh data? Data definition majorly deals with the structure of a table. That means what is the table? What exactly what type of data it is allowing? Because if you are working with these databases, right, MySQL and all these are all relational So these are all allowing structured records. Structured records means what? All the records present in this table. All the data present in this table must follow this metadata. Must follow this metadata which is nothing but every record must contain employee number, name and address. So that's what I'm trying to say. Miy again I will come back. So what is where care and what is the difference between so where care and care okay so no worries right now we can just try to understand high level. So based upon this one so you understand so data definition and data. So if you are talking about DDL right? So DDL stands for what? So data definition language. So here this DDL language is providing some keywords to perform operations on what is that one? So operations on schema for suppose if you want to perform any operations on schema then we can go with what is that one? So DDL schema means what? So the overall structure of your table. If you want to perform any operations on overall structure of a table not with data that's what I'm saying please remember you are not working with data we are working with what is that one so data definition what type of operations generally we can be able to perform so if you are thinking we can create a table right so create and also alter and also drop. So if you are observing these three keywords right so create, alter and drop. So create means what? So what we can say we can create any database object correct. So create is mainly for what is that one? So creating any database object I'm not talking about. So only table yesterday I already discussed what is database correct database is a collection of database objects. Database contains tables, views, synonyms, clusters, indexes, so many things. If you are creating any database object that might be either table or view or synonym whatever it may be correct So for that one so we can use what is that one? So this create is mainly for creating any database object. It's not which is specific to the table. That's what I'm trying to tell you. And alter is mainly for so think yourself for example we are already having so a table for example. So if you want add an extra column right if you want add or drop a column or you want to change the data type of a Okay you want to change the data type of so column or you want to change the size of a You want to change the size of a column. So these are all comes under what is that one the alter alteration is nothing but what? So making some changes to the schema. We have already some schema already table is present or any object is present for suppose might be uh that might be either table or stored procedure or function whatever it may be. If you want to make some alterations we can use this alter command. Alteration in the sense it's not creating so entire thing from very scratch. You just want to make the changes to the existing one. So that one comes under alteration. And finally, so the drop. So drop is nothing but so dropping a table, right? So dropping a table. So dropping a table in the sense completely we are removing. So try to understand the terminology here. Mostly in the DDL only in the data definition language only we are using so this drop operation deleting data if you are deleting if you are working with data per suppose you are deleting one record as per that terminology we can call that one as delete but if you want to drop any object so try to understand from my voice also from my mouth also it is coming drop why I'm using the drop because I'm dropping an object entire object. So whenever we are dropping whenever we are removing entire object any database object from the database we can use this drop command. So we have another option also truncate but right now I'm not talking about truncates I will discuss please note it down that one. So whenever I'm discussing tr at that time I will discuss. So we have another language called as what is that one? So data manipulation language. This is super important for you. So data manipulation language. So DML stands for what? So data manipulation language. So what exactly data manipulation language? So we are working with data. So that insert. So update right inserting. So updating the data. just a second. So insert, update. So delete. So these operations we are performing on data. It's not performing on schema. Yes, sab you are asking question. These operations are done on data. Yes, it's not on schema. Correct. Your thinking is correct. Sir, we are not going to work with schema. we are going to work with what is that one? So the data whenever we are working with data right so most probably we are performing these type of operations what is that one so insert update and delete. So I hope all of you understand what is the difference between so the schema and what is data right first we have to build a schema according to that one. So we have to insert the data right because whatever the data you are inserting so that uh follow certain rules for example if you're taking so here we are inserting one record this is following what is that one so certain schema so we have so employee number and also name and address this employee number is of type what type integer type and employee name is string type and address is also So what is the type? So string type. So we need to make sure that whatever the data we are inserting so that would be bounded with the particular schema. So let's jump into the practical and we can create one first table first of all. It's not a part of okay so our lab practice and all okay just we can for your understanding. So I'm just creating the table. Once you are comfortable with creating table, right? I will share you one document. So for creating table and all once you are getting comfortable with the concepts, we have to do it on your own. Okay, that is the requirement. All of you are ready. Can I jump into a practical part of creating a table? Okay. So let's jump into the so we can create so employee database first of all so these queries are super important initial queries see if you're asking me how many databases are there in my system correct I just want to check what are the databases are present in my system so it is showing four but I'm not looking here. I just going to SQL. I just want to write an SQL query to see how many databases are currently in my server. So you can make use of what is the command show databases. So the show databases every query should be ended with semicolon. So just select this query and execute it. See in the result we can see all the databases right it's more than four because we are not refreshed it seems so we have so whenever we are issuing show databases uh let just a second I will zoom in zoom this for this. So the zoom option is I'm getting so edit Then the query editor. So appearance H. So font. So any size will be there here. Reset grid that is okay but it is not showing any size here. So instead of that one so just ask charg or otherwise how to increase the size. Okay instead of writing this one just go to the Google. So, so go to charge GPT. So, we cannot find so the certain option right. So, we can always ask what is that one? So chargeability how to increase the so font size in MySQL workbench. So it is automatically giving the response right. So we follow the steps but suppose edit preferences under SQL editor change the font size and click okay. Method two. So result set grid adjust the font under result set grid it is saying. So the same options we choose go to edit. So preferences under the SQL editor. So you can just go to the query editor. So go to fonts and colors for suppose. What is the options under fonts and colors? Adjust the font under result set grid. So here so we specify so to home suppose 20 let's see so whether this one is getting so increased or not this one is not getting increased right go to preferences So fonts and colors. No, you cannot zoom it in the touchpad. So we cannot find any option. So the zoom option here, right? We can find any option zoom option here. This one is just find option. It is not. So the zoom option like that. Okay. Anyway, I'm sharing this uh query with you all of you. So, please follow this query. I will just try to increase. Just give me a second. Okay. Don't be hurry for anything. Yes, definitely I will do that one. So, just wait. So, instead of that one, so let's make my differences here. Okay. So result grid the suggested right that is for result grid and SQL editor also I'm just increasing so the size for suppose the 30 let's close this once and reopen the editor so now it is coming so properly right it is visible now all of you yeah so show database ASES see it is providing intelligence also if I'm clicking so show show databases so that automatically it is getting populated if I'm selecting this query and I'm executing it is displaying so all the databases for me HR HR database and all so this is the query which is mainly for what is that one so displaying all the so if you want to write any comment line. So command line means what? So or suppose if you want to write any command lines you can use hyphen right not hash actually. So iPhone so display all databases. Okay. So like this. So this is the actual query which is mainly for displaying all the databases. Little bit I am decreasing because it is very difficult to perform operations. I'm just going to so same preferences and I'm just decreasing. So the size in SQL editor. So 30 I provided I'm just making it as 20. So let's make it comfortable. So now it is fine. or otherwise so you can just open. So the fresh one so go to SQL. So now it is fine. So show it is visible right now it is comfortable for you and all of you. So now I want to create what is that one? So HR database for suppose or otherwise some employee database. How can I create it? So create a database so called employees or otherwise employee DB. What is the query? So just a simple query is create database. So what is that query name? So the employee DB while providing the database name right. So don't give any spaces. So just provide the database name that's all. So just I'm providing so employee DB. Don't provide any spaces or anything. If you want to specify underscore that is fine. Just I'm selecting this query and I'm executing this query. How can you know whether this query is executed successfully or not? In the output we can see in the last one observe my mouse pointer in the output we can see last one so create database employee DB it is green color green color means what so successful for example if I'm missing semicolon so if I'm trying to execute this query so then what happens it is giving error so it is showing red color red color means what What does it mean? So the database is not created. So of course already it is created. Okay. So always your query should be ended with what is that one? So the semicolon. So all of you please create. So this employee DB quickly and after that so we will try to understand. So what is table and all. So once you create an employee DB so you can just put done message in the chart. So in show DB why extra DBs are showing? So extra DBS means might be you can able to see the secular database and also CIS database and HR database right three databases by default we are getting these databases by default provided by the MySQL for you if you're asking me what is SIS database means SIS database is a system level database that means even if you are creating a table here employee if even if you are creating What about the metadata for this employee DB? This employee DB metadata also will be stored in system databases, system tables. In system database, there are many tables we have. If you are looking here, there are CIS config table, right? So internally whatever the objects you are creating that may be either database or table or synonym or function all those information will be maintained in this system database and these two databases right HR database and also Shakila database these two two databases will be provided okay these two databases will be provided for your practice purpose that means this is we can we and call it a sample data set with the help of sample data set uh we can able to uh perform operations right but we are going with the simply learn data set what it is provided and also my customized data set whatever the topic I'm explaining that's why we don't want to use the secular database and all okay like that is it clear so what is the database we pro created employee DB. So whether this employee DB is present or not. So how can you check it? How can you check it? What is the command to check whether the employee DB is present in your databases list or not? What is the command we have to execute? Show databases. Right? So command level I'm asking. So show Now why what is the purpose of creating database? Yesterday…

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