SQL For Data Analytics 2026 | Essential SQL Commands | SQL Tutorial For Beginners | Simplilearn

Meanwhile, if you are able to hear me, if you're able to see me, uh let me quickly know your introductions on the chat. So, my name is Apernna. I'm going to be your uh host for today. And we have a very interesting session lined up. I'm really excited about the session as well. Yes. Hello Louis uh Kyani, Anil, Anita, Shiva, Timothy, Shreas. Hi. Hi Shreas Gustavo. Okay. Okay. A lot of people from different parts of the world. It's actually Amazing to see you all. Great. Great. Keep those introductions coming. Yeah. So, I'm just waiting for a few more people to join. Um, you know, um, meanwhile, you could share your introductions. Yes, Anand, we're ready to start. Just a few more minutes. Rudra, hi from YouTube. Okay. Vashnavi, Virupaksha, Ryan, Rajir, someone from Liverpool. Okay, Dennis from Liberia. So people on LinkedIn, if you are able to hear me, see me, just leave your introductions on the live chat as well. Remember, you'll be interacting with us there. Okay. Yes. Yes. Yes. Yeah. Okay. So a quick agenda for today right um while people join in and uh more people are are just uh you know just just kind of joining the session there's some agenda for you this is how we're going to go about the session right we have a lot of uh people from different parts of the world who are here to understand how SQL is really important um what is the role of SQL in data analytics it's probably one of the building blocks of of data analytics we understand that um and Sadi is going to help you understand some essential basic fundamental SQL commands and later after the session we are going to help you understand how this fits uh into your data analytics journey how the program which is the professional certificate in data analytics helps and we'll also take you through the enrollment steps right and uh towards the end we've got three giveaways for you including the webinar certificate. Okay. Um, so what these giveaways are, I'm not going to reveal right now. We'll wait till the end of the session to understand what they are. Yes, remember three giveaways and third one is actually the webinar certificate. Um, so make sure you stay till the end uh because these giveaways are as amazing as the webinar itself. Okay, so a lot of you are already here. We've got close to 300 people in this session. Um and it's going to be really hard for us to keep track of the chat messages. So remember this is what you're going to do. Okay. Yes. 300 people. Absolutely. So uh including I mean this is excluding audience on uh LinkedIn and YouTube of course. So in case you're joining us from Zoom, please remember to put your questions in the Q&A box and not on the chat box. Okay? Uh because again you can yourself see the amount of messages that we're getting. So in case you have a question for Sadik, please make sure you put uh a question on the Q&A box and we'll address that towards the end. Yeah. Now remember the session is is going to be a live demonstration of what SQL commands look like. So it is going to be pretty interactive and you'll have to anyway uh you know keep talking to Savic on the chat. So you will be able to address these answers towards I mean during the session itself. But let's say you have a question related to your career. It can be anything else. Please use the Q&A box for this. Yeah. Are we clear with the with the ground rules about what to do when you have a question and when we'll answer them? Yes. Yeah. Just a quick yes. We'll do if you've understood the agenda how we're going to go about. It's going to be a 1 and a half hour long session. So we are uh at 9:00 p.m. India time. So another one and a half hours including the giveaways that I mentioned and also the Q&A. Okay. Right. Yes. So about till till about 10 to 10:15 you know we'll only be doing the SQL commands and then after that I'm going to be taking you through the enrollment steps the Q&A and then the giveaways. Yeah. Right. So we've got enough people now in the session and uh you know before we start it's it's always good to know the audience a little better. So what I'm going to do is launch a very quick poll on Zoom. Now people watching us on LinkedIn and YouTube what you can do is please use the live chat to answer this poll question. People on Zoom just just let us know how much are you aware of SQL? Have you used them? you already know about these commands, use them extensively. Um, this will help Sadi again, you know, frame his conversation accordingly on the on the poll. It'll be really helpful if you can answer this question on the poll. Yeah. Okay. We already have uh a few questions on the Q&A box. Pri, thanks so much for your question. Hopefully you know when we talk about the course should be able to get your u road map um people on zoom please please please use the poll only. Okay. Yeah. And for best results it's it's best if you join via the zoom app. If you don't see the poll just go to more click on the three buttons there should be able to see the poll. Okay. Anyway I'm just going to end this right here uh and share these results with Sadi. Um sadik you should be able to see the results now lot of them are actually beginners about more than twothirds of the class is actually um you know beginner or a third of them are kind of you know already use them extensively so got it got it around 70% of them are uh very beginners and um around 25 yeah 30 32% is like you know I've been working with SQL correct sadik actually your video is not uh visible. So maybe you can actually remove the background or Yeah, you're visible now. Okay. Yes. Yes. Yes. Yes. So it's time to start. Uh yeah, I'll just quickly introduce you and also Simply Learn. I think we'll we'll quickly get started after that. Just another um five minutes then we should be ready. Okay, great. So I'm just stopping the u you know sharing of results as well. Just some introduction uh before we start just some introduction about simply learn and what we do. So simply learn offers skills in various domains um data science machine learning AI cloud computing cyber security. We've also got courses in uh and certifications in agile and scrum product project management, product management um and also tech, right? So we've got multiple courses that have the genai components included and in fact the course that we're going to talk about today also has the genai component included. Right? Um so that's just a bit about what Simple Learn does. We've touched more than 8 million careers worldwide across learners from more than 150 countries. The proof is the audience that is there in this webinar. Right? So we've got a lot of global accredititations as well and a lot of amazing and qualified trainers who help you in your upskilling journey who help you learn and gain these skills that are required for you to achieve your career goals. Right? Simply learn. Let me just also introduce our speaker Sadi to you. Sadi is is is is a passionate person and he's a really passionate trainer and he specializes in Excel, PowerBI also Tableau, data analytics. So anything associated with data analytics, the end to end process, he he's he specializes in that and he's delivered a lot of uh training to professionals, learners like you. He's also actively involved in uh developing and improving Simply Learns curriculum. So he's he's also kind of uh you know a mentor of sorts for for incorporating topics that are trending and that you know that also coming up in the data analytics field. Um it's great to have you again Sadi. I think a few learners Thank you from the earlier session. So I think I'll hand it over to you from here can take over. Yeah. Hi very good morning to everyone. Yeah, I think. Oh, why is this poor? Okay. No, I think it's it's perfectly fine. Sadik, you perfectly audible. Okay, fine. Thank you. Yeah. Yeah. Yeah. Yeah. Yeah. Hey, very good morning, good evening, good day to everyone. Okay. Respective whichever the zone you are. Uh let me introduce myself as Apr has already introduced about myself. Uh I'm myself Mohammed Sadi. I'm into teaching almost from uh 25 years more than two decades. Yeah. Uh so I've been certified from Microsoft as Microsoft certified professional as well as from the Oracle as I've done my OCP Oracle certified professional uh for the Oracle database administrations and then u I do handle programmings on multiple technologies like net programming. I take uh I take on the databases like Oracle, Microsoft SQL server as well as MySQL. I do take uh take trainings on um what do you say the Excel um the emerging the new Excel futures like kind of thing the Excel 365 expert yeah apart from that yeah I do handle trainings for BI technologies like Tableau PowerBI and even for Python for data analytics pandas numpy and so on okay so more on data analytics kind of a things apart from the programming language of net uh so today's session uh so we'll be doing something on SQL so I'll go the help of the MySQL platform which is actually a open-source uh platform for writing the queries. Hey guys uh so let us start off with SQL. Okay. So I'll stop my screen share. Sadik I think you will need the screen share now. Just stop my screen share. Yes. I'll just share my screen. Hey guys. Uh what is SQL? Uh generally when you talk about SQL, SQL stands for structured query language. That means is a query language in a structured way. Okay. Means a language to talk to a database and get some answers solved. Okay. Now let us take an example of understanding this particular how do we write this SQL commands. Okay. So what I will do here is I'm just going to use this particular data set. So as I said SQL is a language to talk with the database and get the answers from there. Okay. Um thanks. Um so I'm going to use this particular data set here uh which is about the employees. So when you first let us try to understand what is there in the data set here we have the employees data is something about the HR where I have the employee ID every employee is uniquely identified using the employee ID every employee has the first name the last name of the employee what is their gender either it's a male or female and what is the role they working as either it's a manager CEO lead data scientist okay and things and also we have the information like you know what department they work with um every employer has the experience how long they have been working with the organization. Um so we have some location details like you know which country continent they belong to. We have some measurable values like you know what is the salaries they earning, what is the kind of ratings they have. Hey also we have the information length to whom they are reporting to. Okay I just have this data. Now when I just say hey we have this particular data I just want to start questioning on this data. So it might be the first question is I want to see this complete data or I want to see only some selected columns or I want to see only some selected rows. Okay or I want to get some kind of aggregated datas. Hey like you know what is the total salary expenses or I want to see this particular aggregated data but I want to see based on some kind of a dimension like say example how much we are spending for the employees working in each department. So for retail department how much we are spending for automotive department how much we are spending this kind of a questions you want to put on this particular data and you want to get the answers for that. Okay uh for that you know so we generally use the what do you call it as uh SQL as a language to work with. See we can put this kind of a question even on Excel and we can get the answers. Yes, Excel is really very powerful. We can do that. But when it comes to SQL is a place where I can store and manage a very very large amount of data with a better security. It supports multi-user um um uh platform where uh we can have one dedicated server where the complete data is stored in one server and the clients from the different place they can connect and they can interact with the database server. Okay. And yeah that is the main things again you know you talk about the big datas and all the things where the database server may what data you have stored that can also be split across multiple distributed computing so that is where it can handle a very very large amount of datas you have heard about big datas and all those things okay so what I will do is since I see the kind of a questions what was been flowing so they just wanted to know I'm from economics whether I'll be is it going to be relevant or something see for then in general I'll tell you Um database is something which is core for everything even it is a a developers or you talk about um uh the emerging technology what is happening the trends what is happening you talk about a data science a business intellisense you talk about a data analytics you talk about a data engineering you talk about a machine learning okay you talk about artificial intellisense all the technologies are purely dependent on the data okay data is like a fuel for that and when I say you have this particular data so that means the data is very large And you should have some kind of a skills of questioning the data. Okay. Getting only the information what is relevant to you. And SQL is one of the language which is used to talk to the database and get your answers. Okay. Answered. Okay. That is what is your SQL means it's a query language structured query language. That means a query language in a structured way to put a question to the database and get your answers. Fine. So now uh we have this particular data. So I have given this name of this particular table as EMP in Excel. Hey, if I want to see this complete data, what is that we do? Uh in Excel is very simple. We just say is equal to EMP is it? So we just get that complete data. So this is how we get it. Okay. Now I'll try to get the same thing in your SQL. How do we write the query to get this particular data? Okay. So I have this particular SQL. Uh I have a database by name sadic. Okay. So here I have a database by name sadic. here when you observe okay uh see I'm using a MySQL platform so you can use any kind of a database it can be my SQL Oracle Microsoft SQL server or anything uh when you talk about a MySQL MySQL is a opensource database so that means you don't have to go for a licensing for the learning purpose I feel my SQL is a better one because you don't have to invest in the licensing or anything and apart from that it's a lightweight uh compared to the Oracle or Microsoft SQL server it is much lightweight and the third thing is yeah my SQL is available on mult multiple platform. It is available on uh Windows, Linux as well as on the Mac machine. So when you go to this Microsoft SQL server, you'll have this kind of things. It can it is supported only on the Windows platforms. Here it can support on multiple platforms. So that is something like you know the advantage. So I can say for the learning purpose my SQL is a better one but in the industry yeah so u see like you know what happens um this is a license free. So the costing is very cheaper. So most of the organization they go with MySQL but apart from that so when they the enterprise companies the big organizations yeah obviously they work on Oracle and SQL server Microsoft SQL server irrespectively the SQL command remains the same okay uh we'll see the general SQL commands of how we can access the data okay um so I have this particular table called as employee employees okay I have a table called as employees and I want to see the data so we have a direct view to see the data here I just hit on this one so I can get the data. Hey, this is like you know uh kind of a graphical way to see the data. So I don't want to do the graphical way because here I want to learn SQL. Okay. So if I have to do with SQL what is that we do is we write a command like this. We say select star from the name of the table from the name of the table. Okay. So when I just say select star from employees we can see we are able to see this particular data. Okay. Now this is a simple this is one of the simplest command what we write in the SQL to see the data. So what this command does is hey this gets me the complete data from the database. This gets me the complete data from the database. Now the command goes something like this. Select is to I want to see the data. So select is I want to see the data. Select will be followed with the columns. What columns you want to see. So when you go for this particular tables we have the columns like employee ID is one column. vertical sections or columns is it and horizontal section or rows is it? So I want to see all the columns like employee ID is there, first name is there, last name is there, gender is there and all the things. Fine. I want to get all those particular columns. So now instead of writing all the columns with the comma separator, I can use the shortcut key called as a star. Star represents all the columns. Star is representing all the columns from from where you want to bring this particular columns. I want to bring this particular columns from the table called as employees. That means there is an employees table has many columns. Get me all the columns from the employees table. Okay. So this command is going to show me the data from the employees table. Fine. Okay. Uh this is how we write a simplest command in SQL to get the complete data from the table. Now what happens is uh okay fine. Um uh since a webinar so I'll not be able to give the hands-on or something. So during the sessions they'll be hand on hands-on guys. So during the sessions you'll be having the installed software. Uh I'll be sharing this particular data set. I'll show you like you know how do you import this particular data set into your database and then start working on it and then I give pause there and so that you can practice on those particular things since webinar. So I'll move ahead here. Okay. uh things I'll show you next command as what hey I'll always love to go with uh Excel and try to uh uh do the same thing with Excel and try to do the related to SQL because uh why I'm doing this one is um see any person who goes into your SQL I say that it is always better they play around with Excel because Excel is a very good platform where you can play around with the data okay because you don't get any kind of errors no programming everything based on the tick tick ticks and the jobs is done that is just on the few clicks we can do a lot amazing things in Excel. Okay. So, I'll try to go with the same way. Okay. Um, yeah. Now, the first thing is, hey, I don't want to see all the columns. I just want to see the employee ID, first name, last name, and salary. I'm interested in only seeing this. Uh, if I had to do this in Excel, what is that? We do. Uh, we do something called as a stacking. Is it? We do a stacking. So I just want to get some few of the columns 1 2 3 and say example I just I'm interested in seeing the salary and the department. Yeah. So I want to see the employee first name last name department and salary. If I have to do this in Excel. So what is that we do? If my manager says hey sadic I just want to get only few of those particular columns. Uh what is that we do? Hey I just write like this you know uh I just say is equal to horizontal stack. Okay, just say from the employee table I want to get the employee ID. I want to see again from the employee table I just want to get the first name and then I say again from the employee table. So this is what generally we do in uh Excel. No uh last name and I just want to see from the employee table again I want to see the department. Fine. And I also want to see from the employees table I want to see the salary. Is it? So I just say salary right. So when I just say I want to see this one only few columns and press enter I'm able to get only this columns. So this is showing the employee first name last name department and salary. I know this is very easy in Excel. You already studied all those things in Excel. Fine. Um so I'm going to teach you the same thing in SQL. So now what I want I don't want all the columns because you know uh sometimes you know you have um 70 80 plus columns and uh I want to see only some columns which is needed for me okay unwanted columns I want to keep it dummy okay so in that case so what is that we do in SQL that's actually very easy here uh so as I said star is representing all the columns now I don't want to see all the columns I want to see only some selected columns okay so in that case I'll just write the query again to you so that I can share this query So instead of star I'll just mention the column names. Okay, I want to get the employee ID. I want to get the first name. Uh I want to get the last name. Okay, and I want to get the department. And I also want to see the salary. Fine. That's it. So what did I do here? So previously I had written the command as star. Star was getting all the columns. But I say no at this time I just want only some selected columns. I want to see the employee ID, first name, last name, the department and the salary column. I just want only this five columns. I've mentioned this five columns using a comma separator. Okay. And then when I run this particular query, you can see I'm just going to get only the data what is needed for me. So I'm able to get only those particular five columns. It's a very easy way to uh get only the selected columns. Got it? Yeah, guys. Yeah. Hey, you can make a note of those particular things or and your recorded session will be available to you. Yeah. Uh fine. This is something like you know um star was giving me all the columns. Okay. When I run both the queries, you can see uh star was giving something like you know all the columns from the table. But um star was giving all the columns but I don't want all the columns. I want only some selected columns. So just mention those columns with the comma separator. Okay. Now I can also use some expressions here. expression is when you talk about this particular salary. Oh, this is the monthly salary. Uh but when I'm displaying I want to display the annual salary. Okay. Uh I want to display the annual salary. So we know that a month uh sorry year has 12 months. Okay. So if I say annual salary is whatever the monthly salary is there you multiply into 12 it is going to be the annual salary. Yes. Okay. So what I will do here is I'll just say I want to display the actual salary plus I want to display the annual salary. I just say salary into 12. So there is no column as annual salary. So I just say salary into 12. So you can see here. So the actual salary of the employee was 3,000 here and we are getting 36,000. Okay. 3K we getting 36K. Pete he's earning 11K but here you can see 132K. Okay. 11K into 12 is 132K. Okay. So when you see any employee so this employee is earning 7K but annual salary is 84K. So into 12 has been multiplied. Fine. So I can also something like you know not see what I mean to say here is this column is not there in your table. This is not there in your table. In your table source data it is not there but I want to show the annual salary like I want to calculate the taxing and all the things. I want to know what is his annual income based on based on that you know. So what is the kind of a taxing amount has to be done. So we have to calculate. Okay. So that is where we do this. You know one thing here is when I say salary into 12 it is showing the heading as salary into 12. I don't like this kind of expression to be displayed in the headings. I want to say hey this is the annual salary. So what is that we want? I just want to rename that column as instead of salary 12 I want to say that as annual salary. So what you do just give a as keyword and say what is that you wanted annual salary. Annual salary. So when I give this one so what has happened here this expression instead of showing as salary into 12 it is showing as annual salary. So what is this? This is called as aliyah's name. Aliyah's name is what? When some people have a long names so they have a short calling name is it. Um yeah something like Samuel Benjamin and we call him as Sam. Yeah we call him as it. Yeah something like that. When you have people has a long names I don't want to call with a long name but I want to have a short calling name. So something like easy name or something. So I didn't wanted to uh display this kind of expression but I want to display this particular kind of a alias name. So I can give what is the name you want to display. Fine with this. Okay fine. So the next thing is um cool uh what's next? Yeah. Now um we have this particular data here. Uh what is that I wanted is let us try to put a question here. I just want to know uh what are the different departments are there. I just want to know we have employees working for retail department. We have employees working for automotive. We have many employees working for automotive department. We have many employees working for finance. We have many employees working for healthcare. But my manager says hey sad I just want to know what all the departments are there. Just let me know what are the different departments are there. Uh what is that we do in Excel? If you have to get the departments uh we generally do like this is it we just try to copy this particular department. I just say Ctrl C I copy this. I just paste it somewhere and then I just go to the data tab. I just say data and then I have to go to the remove duplicates and I say yeah make that as a header and say okay or we get this particular thing. So this is the different five different departments are there. So we have to do all this exercise is it? Okay. Or in Excel we have something called as a unique will get you all those particular things. Yes. Yeah. I know that will be done. That is more easier one. So I say is equal to unique. So if you know this particular function I just say from the EMP table take the departments. You find this also will get you the unique departments. Now this is Excel. I'm not teaching you Excel here. But I'm telling I'm just trying to relate it in Excel so that you people have already worked with Excel. Is it fine? So now what I want is I want something like this. I just want to know what all the different departments are there. Okay. So what I will do here is um I'll try to when I just say star it shows me all the columns but you want a specific column just mention the columns that the columns don't mention that will not be displayed is it? So I'll try do that select department from the table name. What is the table name here? Employees. Okay this is going to get all that is it has removed the other columns but it has retained only that column. But what I want here is the repeated values has to be shown only once. That means it has to show me the distinct value. Okay? Uh repeated values has to be shown only once. So what you do is just before the column prefix with a keyword called as a distinct just before the column prefix with a keyword called as a distinct. What this particular command will do is it is just going to get me the distinct departments. Okay. Hey this query gives the answer for my boss question. So my boss wanted to know hey sadik I just want to know how many different departments are. What are the different departments are there? Cool. We are able to get this. Okay. Fine. Yeah, I can do something like this. So, I hope you're able to get it like you know what you can do with their skill. So, you have the data, we can pull the data. So, when you're pulling the data, you want the complete data, you want only some selected data, you want to have some kind of a derived column, some kind of a calculated columns. Yes, you can do that. Or you want to get some kind of a unique values. Okay. uh again the second question can be again uh say we have employees working uh from different countries I just want to know what are the different countries from where we have the employees that's it okay so in that case what you do just write the same thing select instead of department I say country right so that's going to tell me hey we have the employees from this are the different countries we have the employees so that means we have a large amount of data say lacks of rows of data and we might have employees working from um say um hundreds of different countries but you know from the lacks of rows of data you finding will be very difficult okay but this query will easily give the same result okay irrespective of the size of the data so just for your understanding I've taken a small set of the data but in the real time you'll have millions of rows of data so the same queries the the query same uh remains the same irrespective of size of the data okay fine uh we'll move ahead Okay. So now the next thing is um so we have this. Now next is uh I just want to get the data horizontal rows. Okay. What I mean to say is um so imagine like you have huge amount of data. I just want to search for a particular employee. I want to search for a particular employee. Might be his name is um Eric. I just want to get his details. Okay. I want to see the employees whose name is Eric. I want to get that one. So what is that we do in Excel? In Excel we see for everything Excel has a solution. Is it? So I just want to list out the employee whose name is Eric. I just say a ric is it? Uh I just write a query something like this. Say is equal to filter. Uh we use a filter command and say in the emp table I just say I want to go for the employee table. uh where I'm looking at the first name and the first name should be matching to this value say Eric uh this is going to get me the details of Mr. Eric. Okay, his name is Eric Collins and so on. Okay, now the same way if I say Steve, this will give me the details of Steve. Okay, what is his name? What is his gender? What is the role of that employee? What department he works? How much of experience he has? Which country, continent, salary, experience, all the data has been shown. Okay. Now I want the same thing in our what you say my SQL. Okay, in the SQL I want to do this. So what is that I wanted? I just want to see the employee whose name is Eric. So let us see how do we do that. Uh if I had to do this, I'll just write a command like this. I just say select star from the employees table. So this is going to get me the complete data. But I want to filter the data horizontally. So if you have to filter the data horizontally, what we do after the table name, we use the wear clause. I just say where and I want to filter based on what column? I want to filter based on the column called as first name and that should be a matching to a value called as Eric. First name should be matching to Eric. So I say where I'm filtering on this particular column first name should be matching to a value called as Eric. E R I C. That's it. Now this is the text data. So I have to enclose within the quotes. Fine. So when you run this particular query we can see it is showing the details of Eric. So employee ID, first name, last name, gender and all the things. Now if I just say Steve, it gives me the details of Steve. Interesting. Yeah guys. Okay. Yeah. Fine. Um so this was something like you know what you can do with SQL. Okay. Now the next thing is um so we can use lot of relational operators. Okay. So equal to and if I say not equal to and all those things or you can even work with the numbers datas like say example I want to see the employees who has uh more than uh 10 years of experience. Okay I just want to see that hey if I have to do that what is that we do? Uh I just say experience 10 years is that okay I want to see only the employees who has more than 10 years of experience. So we have employees with 7 n and things one year also we have and we have many employees with more than 10 years. I just want to list only those employees who has more than 10 years of experience. Uh see in Excel we do it in this way also is it? So we say number filter go to greater than or equal to we say 10 um we either do like this or if the same thing it's a functional language we do it uh if using the formulas we write like this is it is equal to filter on the emp table so I just say I'm filtering on the experience and I'm just going with greater than what is that experience 10. So this will show me the employees who has more than 10 years of experience. If I say five, it shows me the employees who has more than five years of experience. So if I say this as 12, so it shows me the employees with more than 12 years of experience. It's cool. Okay. Hey, this is what we do in Excel. Yeah, I'm not teaching you Excel, but yeah, I know you people have worked with this kind of formulas in Excel, is it? Nevertheless, in SQL, uh SQL is much much easier. Okay, but you have to write a kind of a language. Um so you have to see the employees who has more than 10 years of experience. So what is that we do? So I just write this. I want to see the data from the table. So I just say select staff from the table name. This is going to get the complete data. Okay. But here I don't want to see the complete data. I want to filter some rows. Since you want to filter the rows, what I do? I'll just use a where where I want to filter on what column here. I want to filter on the experience column. So I'll just say where experience is greater than 10. So this will show me only those particular employees who has more than 10 years of experience. Fine. Yeah, guys. Yeah, you can change here. If I say five, it shows me the employees more than 5 years of experience. If I say 12, it shows me the employees more than 12 years of experience. Yeah, same like in Excel what we do and we are just doing it here. Yeah guys. Yeah. Now um so we can use a lot of relational operators here. So when I say greater than it shows more than 12. If I say hey I want to see the employees who has 12 and more than 12 of years of experience. I want to see the employees with 12 and more than 12 years of experience. So in that case what I do I say greater than or equal to. So this will show me the employees with exactly 12 and more than 12. So you can see it is showing the employees with 12 and more than 12. So when we had only greater than it was above 12. So when I say greater than equal to that means 12 and more than 12. Okay. Including of 12. The same way I can use a less than operator. This is 12 and below 12. Yeah. So employees with 12 and below 12 years of experience and I say just less than not 12 but less than 12. So something like this. So this kind of operators can be used for filtering the data. You got it? Clear? So the way you are able to question on the data and get the answers. Okay. So let me just take up the questions here. Okay. Yeah. Uh next is what if if I want to go with two conditions. Okay. Um see here we are telling us 12 years of experience or more than um I say more than um say 8 years of experience I'll say. Okay. So I want I'm seeing the employees with more than eight of 8 years of experience. Fine. Now out of this I just want to see only the male employees with more than 8 years. I want to see only the male employees with more than 8 years. So I want to go with two criterias. So one is the gender should be male. The second thing is experience should be more than 8 years. I want to see male employees with more than 8 years of experience. Okay. How do we do that? Um so generally in Excel I see where people do like this. Is it uh in Excel? Uh I do a lot of things in Excel. Yeah. uh we use filter and I say uh you're filtering on what EMP table yes I want to go with two conditions so if I have to go to two conditions I have to write something like this okay so include what uh the first criteria is from the emp table so I take the gender um yeah um should be matching to I just select a cell here okay so comma and I just say another um so I just put close this and if you have to go to the second condition I have to put a star then open the bracket again I have to say emp and this time I'll just say I'm looking at u what say uh gen uh what do you say experience and I just say greater than uh it should be something this much yeah so I'll just say this is gender is m and experience is um say 5 years so it is showing only the male employees with more than 5 years. If I say fill, male employees with more than 12 years of experience. If I say F year, female employees with more than 12 years of experience, more than 10 years, more than 5 years of experience, only female employees. Yes. So something like this kind of a formulas we have to write in Excel is that we have to get this kind of a results. Yes, I know Excel is easier thing but we have to get this kind of a answer with multiple criterias. Yeah, we have to write all those kind of a things. Yeah, I know we can do with the help of the tools but that is going to disturb your actual data but if you have to get the answers we have to write a queries like this in Excel. Okay. Anyway, uh we'll have a separate session on Excel guys. Okay. So now uh we will do this in SQL. How do we do that? So what is the question here? I want to see the male employees with more than 8 years of experience. Okay. So I can just take the same query here. Okay. And I'll just say I want to see the employees where experience is greater than 8. And I'll just put a and what is the gender okay is equal to what? M. Okay. So that means two criterias are there. Experience is greater than 8 and gender is matching to M. So when I run this particular command you can see the output here. So it is showing the records which satisfies both the outputs here. One is the gender should be matching to M. And the second thing is what? Experience should be greater than eight. See all the employees with more than 8 years at the same time only the male employees. Cool. Oh, if I say F here, same thing as a female. So female employees with more than 8 years of experience. Okay, I hope all are able to follow. Hope I'm not I might be fast here. Generally the classes doesn't go fast. Okay, I think guys. Hey. Um, so fine. So this is how we can apply the filter with multiple criterias and conditions. Now let me just go with some kind of aggregate functions. Um see it is something like you know SQL is always like you know or even you talk about data analytics or data science I always say it's like you know you should be a cops on the data okay uh how the cops they torture the thief to because the thief doesn't tell you know the culprit person who has done the mistake he never says uh he has done the mistake he never accepts it but the cops knows it like you know how to extract it they torture it okay see what happens you have the data but you need to know the data okay once only you know the data you can get you can create some kind of a dashboards on that and tell your manager telling that okay here things can be improved here things are going the profit has been less over here the profit is more here this product has a higher sales uh in this particular region but this product is not being sold in this region so this so that we can have a better kind of a business decisions okay so it's always like you know how you keep questioning on the data now let us have some kind of a aggregation data yeah okay let us ask some Question might be the first question is how many employees do we have? Simple as that. I just want to know how many employees do you have? So that can be a question. So there we write something called as aggregate functions. Okay. So I just want to know uh aggregate functions. How many employees are there? If you have to find the how many employees are there. So we use something called as aggregate functions. So we write it like this. I say select count of star. Okay. from from employee table. Okay. So when I just say count of star is representing the rows complete rows star is represent column is that but it shows me all the rows. When I say count it does gives a count of that. So and tells me as the output of this one is 21 says we have 21 employees. Cool. That is good. Hey, now we know that every employee is earning a salary. Every employee has a salary, is it? So, every employee is earning a salary. Okay. [clears throat] So, I just want to know what is the total salary. I want to know what is the total. I have to sum up the whole salary column. Uh if I have to find sum of the whole salary column. So, what is that? We do is I just say write this command. Select sum of what salary from the employees table. Okay. So when I go like this what it does? It tells me hey the total salary on the employees table is uh 174k. Yes 174k. 1 lakh 74,000. In India we say call it this as 1 lakh 74,000. So I think you know globally we follow this uh standards of numbering. Is it 174k? Yes. Okay. Or.1 million is it 0.1 million? Yes. Yeah. Fine. Whatever it is because I take classes almost every regions kind of a thing. So western regions they say like you know.1 million or 174k something. Okay cool with this. The same way we can find what is the average salary. So I can just find u just say a vg of salary. It's very easy here. So this tells me what is the average salary. The total salary is 174k and average salary is 8.3k. Okay. What is the highest salary given to any employee? I can just say max max of salary. Okay. This will tell me what is the highest salary given for the employee respectively. So the same way we have a min function and so on. Okay. The lowest salary we can use as min function. Okay. Um so here we are able to find out the different aggregations here. Count we saw the number of employees. So sum um so what is the total uh salary we are spending? What is the average salary given? We are giving for individual employee. Hey what is the highest salary given for any employee? What is the lowest salary that has been given for any employee? Yeah. So min, max, average, sum, we are able to do this. Okay. Fine. Uh this is okay. Uh this is a simple thing we write in this one. No, I just want to know I say is equal to sum of we just say from the employee table. So I'm just taking the salary. Is it fine? So it tells me the salary. Now what I want is I just want to know okay this 174k is the total salary but I say hey sadi I just want to know how much salary we are spending in each department. How much we are spending for automo industries? How much um a department automo department? How much we are spending for finance employees? What is the total salary that we are spending on the healthcare employees? Okay. Each department wise I want to do that. Uh if I had to do this in Excel I think you people do a p tables or you can use a group by function or a p function. So something like that we try to do is it. So I just want a potting something like you know I just want say uh I want to have uh department wise what is the salary? I can just go to this say yeah uh if I want to see for each department I do something like this. No I take a department and the salary this tells me for all department that is there is a department called as all we are spending 49k for automotive department we are spending 31k finance we are spending 24k healthcare we are spending 27k and the retail we are spending something around 41.8k 8k. So maximum we are spending in employees working for all department and then for the retail departments. So I want to get this kind of a things in our SQL. So where we are grouping this each all the you know what exactly is happening is it is grouping uh all the retail department as one group and it is summing up the salary all the automotive department as one group and the summing up the salary again and showing an output. I want to get this kind of a things. So in that case what is that we do is so I just want the total salary is it select sum of salary from the employees table. Yes but I just want to see this grouped by department. So we have a function called as group by. Okay. What column you want to group? I want to see based on the department. That's it. Since I want to see the department and the total salary in the column I [clears throat] just say I want to see the department and the total salary. But this salary has to be grouped for each department. That means all has to be one department. Automotive salaries will be summed up. Okay. Something like that. Okay. When I run this one, we are getting the same thing. Actually, this is much easier than uh Excel is it? Is much easier than Excel is it? It's more a simple language a structured query language that means a query in a structured way. See if I have to do this in Excel we write a function something like this. Um I do it like this is it. Um so we use a group by function. I say is equal to group by uh in Excel visit row field is what I just want the rows from the emp table. Uh I take what department. So I want the department to be as the rows. Fine. Then we have the values. values should be the uh salary from the EMP table. I just want to take the salary. Fine. And then what kind of aggregation you want? I want the sum s u m that's it. So when I do this, we get it. So that is something like we do it in Excel is it? So in Excel we write this kind of a function to get this each department wise what we what is that we are spending. Okay. Now so if you're if you are working in Excel and the question has been asked you write this kind of function and give the answers for them. But you know you're working in SQL and the same thing we write it much easier. So I say see what happens is when I just say select sum of salary from the employees table. Okay. So here what happens is when I say sum of salary from the employees table this is not doing any kind of a grouping. It is showing the complete table as one group and showing as one output. But here when I say group by when I just say group by so you're just dividing this particular total salary by each department and then you're telling that for each department what is that we are spending yeah fine yeah guys any questions from your side also I can take it up as a very vast subject guys. Okay. So we have a lot of things we can learn basic Excel. See we have a lot of things in SQL. Sadik there is just a one uh just one question on how many days would you think a beginner would take to complete learning Excel. Okay. Uh in this case I'll just tell uh when you talk about SQL uh as I said is a structured query language means is a language with the help of which we can talk to a database and get the answers done. Okay. Yeah. And SQL is one language which can be used with any RDBMS softwares. So we have hundreds of RDBMS softwares like we have Oracle is one RDBMS software. Microsoft SQL server, Terra data. So SAP, HANA, there are many even like you know even the cloud databases like SQL Azour is there. Uh SQL Azour is there. Uh you talk about um Hadoop is there. So anything you talk about any this one database hundreds of database. So SQL is the same language which will be used for communicating with any RDBMS. Fine. Now in SQL we have many commands. Okay. Something like we have some commands called as DDL data definition language. That means with the help of this SQL commands we can create the database objects like you want to create a table, you want to alter the structure of the table, you want to drop the table. So those commands are there. Apart from that we do also have a DML data manipulation language. So with the help of which we can manipulate the data. So those are the command deals with the data like how we can add the data to the table, how we can delete the data from the table, how we can modify the data like you know employee gets an appraisal so his salary has to be apprised to a new salary. So how that changes we do it the actual data. So that is what select is not doing any changes on the data. Select is how you're going to see the data. Okay. Uh things and then is your select statements where we can see the datas. Now again in the RDBMS we have something called as normalizations. What happens in the normalization? Data will not be stored in a single table. It will be spread across multiple tables to store. That is to follow some kind of a good RDBMS standard norms to avoid the redundancy. Okay. To maintain the inconsistency to have a better performance when the data goes across multiple tables in that case what happens is we have to write something called as a joins okay multi-table queries either it can be joins subqueries or unions those things are there. So what I mean to say is since you asked this questions we have a lot of things to learn and then um so you have something called SQL has come out with lot of built-in functions text number functions and they have lot of functions with respect to especially for analytics purpose like we call as window functions okay so there we have lot of things to learn common table expressions are there and these are something like you know what is needed for a data analytics but if you go for a data engineering or a data science so your queries has to be written in a more optimized way with a better performance performance. So there you have something called as stored procedures, indexes, um we have something called as a userdefined functions, transactions and all those things. So on that basis like you know um I can say around 40 hours is needed to learn at least those things. Uh if you're seriously learning kind of a things in a formal this one um with the hands-on yeah 40 hours plus is needed kind of a things guys. Understood. Understood. Got it. Um before you proceed to you know the next section maybe could you explain the group by function again? I think a lot of learners are asking that on the chat and on the Q group by in Excel or group by in uh SQL. I think we'll do SQL first and maybe yeah SQL. Yeah. Yeah. Yeah. Fine. See what actually the group by does is uh when I just say select I'm just let me write a simple select statement. select star from the employees table. So what this does this will just give me the total uh this is just going to tell me um this is just giving me the complete data. Now this is okay um things but you know in the real time what happens when you have millions of rows of data I'll not be happy to see the data. I just want a head count. I just want a head count. Okay. I just want to know how many employees are there. That's it. I just want to know how many employees are there. If I have that that is I just want to get that number. So I cannot um say boss I have written the query this is giving me the complete data from here you start counting and telling that this is the number of rows. No I my manager says I just want to know how many employees are there. So what we do is this is giving this one row this is second row and things. I want to get the count of rows. So I'll just add a function called as count. Count is a function and always a function will have a parenthesis. You would have seen in Excel no you write is equal to sum open and close a bracket there also you have a count function so I've just put in the brackets in the brackets I'm putting the star so that means the rows I'm counting the rows so this will tell me how many rows are there so that means how many employees are there so it says 21 employees are there fine so we see that if you count this no so we have 21 employees getting okay now group by is what okay fine that's cool good how many 21 employees are there But I want to know how many employees are working in the retail department. How many employees are there working in the automo department? How many employees are working in the finance department. I just want to get the count of employees based on the department. So that means what I want I want to subdivide this data into smaller groups and then I want to get the count. The group by does the job. So what I do is I'll just say group by. Okay. Group by what? Say department. That's it. So this is automatically going to group it based on the department and shows but I don't know what is that 7 4 32. So you write the department also here. So we'll come to know which department we have that seven employees. In which department we have the three employees. In which department we have that four employees. Which department we have again three employees. We see that retail has seven employees. When you sum up that you should get 27. 21 is it? 7 + 4 is 11 + 3. 3 + 4 is again another 10 is 21. Yeah. Yeah. Got it. Right. Understood. So might be like you know if I say I want to know how many employees are there in each country. I can just put here as country and I just say group by country. Okay. This will tell me in each country. Oh we have this employees from all these countries. So we see France maybe we have one employee. China we have one employee. From Germany we have three. Colombia say we have three. India say we have four employees. From Canada we have four employees. From USA we have five employees. Again when you sum up this you'll still get as 21. Yeah. Uh this is how we do the kind of a grouping functions what we do. Okay. Got it. Got it. Got it. Uh so yeah I think we can carry on with the explanation maybe and uh I'll probably interrupt you again when there are questions. How can you clean the data using the SQL enter into some functions and formulas? Okay. Hey guys, um see uh for cleaning the datas u we have the functions uh we have something called as a substring functions we have a lot of functions and so on. Now let me just take an example here. So since you're asking about this one so we have something called as a common table expressions. Okay. Uh yeah it's little kind of a tricky this one. uh but you know uh since you once you join up for a course and I'll be explaining more into details with lot of examples but yeah we'll see how do we do this one so now let us take this question here is uh we know uh each department we have um in each department this is the total salary we are spending okay now as a data analyst I don't want to see this numbers so they will be more happy to see this in the form of percentage here how percentage of the salary we are spending on the all department. How much percentage of the total salary we are spending in the automotive department. If you have to find out the percent what is that we do? If we have to find out the percent uh it's very simple in the function you know instead of sum you just say percent of this are really amazing in Excel. So they have come out with this function. This tells you in the form of percentage and you can see that it's just a single this one here. uh that's really a great thing in Excel kind of a thing. uh but generally what we do is uh we do we used to do like a p table we know the individual department this is what we are spending and if you have to get a percentage we just say is equal to the individual department what we are spending 49.5k divided with 174.8k 8K into 100. This tells me so in this department we are spending 28% of the salary. For automotive we are spending 31K. That means how much percentage you are spending. We say is equal to select this that is the individual department salary divided by the overall total into 100 will tell me. So for automotive department we are spending 18K. So we cannot drag this. We have to write this is it. So I so this is how we do it in Excel. So what we do is first we try to summarize the data first we try to group the data for each department and then what we do on this we try to apply some kind of a percentage. Okay. So in this case what I will do is I'll use something called as aggregate functions. I'll also use something called as a window functions and I'll also use a CTE. Okay. I'll not be able to explain everything in this one because we have a short of time but since we'll try to answer this kind of a questions okay using a query okay uh might be during the session time yeah definitely I'll go into from the scratch we'll be following the process now we'll do that so first what I will do is I just want to know uh this query okay what is it for each department we are what you are spending okay first let me write this particular query so for each department what you are spending just like a p table so we have this output now I'll Just give the alias name for this as the department salary. C L E A R Y. Okay fine. We have this each department we are spending this much. Now I can we can do it in many ways but we have something called as a CT common table expression. I'll just say with CT common table expression and then we just say as and open the bracket. So now I'll just close this over here. Okay. Um now when I talk about a CT uh CT stands for common table expression. It is just a temporary table. So we have a query or we have a output of this query. This output of this query the output of this query will be stored into this particular table. The output of this query will be stored in this table and further you can write a queries on that. So I can just say select star from the city. So you can give any name for the city. It's not necessary you have to give city. Any name you can give good name you can give. Okay. it just doesn't okay so you're getting the same thing but okay fine so now what is that I wanted is I just want to know the percentage to get the percentage I'll take this department salary divided with the grand total grand total we use something called as over function so what I do I just want to see the department and the individual department what is that we are spending star is giving in this columns I want to have some calculation here so which is nothing but the department salary how much we are spending for each department divided by sum of the complete department salary. It has to sum up the whole thing. So now when I say sum of the whole thing, it has to show the total for individual row wise. What I mean to say is I want this particular total. I want this particular total to be taken on every row wise. I want it over here. I want it over here. I want over here. So that means I want this to be shown for each row wise. Okay. So for that we have something called as a window functions which we'll be learning in during the session time. So I'll make this as a window function. That means for each row it tells me what is the total salary and this is the individual salary for the department. When you divide this you'll get the percentage. And you can see we are able to get this result here. We are able to see uh retail department we are spending 41.8k. So that is nothing but 23%. 23.9%. In the automotive department we are spending 31.8 which is nothing but 18%. Okay. Same. Okay. Cool. As salary percentage so I can just keep this within the quotes percentage salary. Yeah. Fun something like you know we use window functions and so on. Okay guys. Yeah. Uh see like you know here I'm skipping a lot of things. I have not explained you what is CDE what is the window functions and things. We'll be learning those things. Yeah. Since you asked me like you know how do we write this kind of a data analytics functions. Yeah, this kind of a functions can be very easily written. So a lot of functions like this which can be very useful for the analytics can be written and these are like you know the basic kind of a commands. So at the end of the day I can just say SQL is the language with the help of which we are talking to the database. So we are trying to get some job done from the database. That's it. Yeah I think that should be fine. Yeah. Yeah. Um, yeah, I think we just have a few more questions if we can just answer that. I was just typing the answers. Um, okay guys, I already answered questions about recording and certificate. So, we're not going to take that. We'll instead answer some questions about your careers and this and we also have to proceed to the next section of the webinar. So, I'm just going to keep this short and then we'll continue the Q&A towards the end. Um, so Magna has this question. Sadik, she's preparing for a business analyst role and okay, she's asking for courses. So, MNA um we'll help you answer this question towards the end. We're already talking about a data analytics course. So, right now I'll just dismiss your question. Um Gotham has a question. Excel is the foundation for data analytics and having a there are lots of formula that you can learn and you know there there's no one can really memorize all the formula. So my point is how can one really become an expert in SQL commands? How does one handle that? Uh there's a question for me is it? Yeah. Yeah. Yeah. Yeah. Yeah. Hey guys. Um see um uh one thing your first thing question was like you know somebody asked like is Excel kind of a things base? I always say that Excel is a base. Uh see the reason is like you know um Excel is a place where I can see whatever I did here. Whatever I did here we could do with the help of Excel like I wrote a group by functions no need of using a p also we can do this lot of things amazing function. So with the performing function this function we could do it in a single one single go filters we could do it. So everything you can do it in excel and excel is something like you know where you can play around fearlessly. So whatever the kind of a uh filters we did even we could do it over here. So we have this kind of a graphical tool. Hey I want to see uh the details of Steve. I can just go here. I say text filters and uh I go for matching equal to okay uh Steve S t so it shows me the details of Steve it's very easy to get it fine so that is why I say like you know Excel is very easy uh it's completely a graphical things to is given to you u so fearlessly you can play around with the data you can understand the data so because you know at the end of the day understanding of the data is very very important okay then only you can start torturing the data start questioning on the datas okay on that basis I Okay, excel is something which is really very mandatory. The third second thing is like you know um how do we learn SQL? Okay. Uh see guys uh this is more of a mathematical subject uh like math not like um history or um uh geography or any other subjects. I always say this is like mathematics. Uh in this you don't have to by heart anything. A very good thing is you don't have to buy heart anything. You have to be logically strong. So it's like you know mathematics like you know if I say um see any kind of this one you just have to know the numbers you know I have five chocolates and I have um I my friend gave me two chocolates I say 5 + 2 is 7 we do this uh thing something like you know you need to have ideas like you know so I say I have five chocolates and friend gave me two chocolates so they ask you how many chocolates we have so here when they give we have to know that you know if something comes in we have to do the addition of that or when I give something so I need to subtract it so I need to know that kind of a logic so when we hear also like you know as as soon as a question has been given to you. So we need to be logically strong enough to take a decisions like you know how we can answer this particular questions. So first I always say is don't start writing the SQL commands. Don't start writing the commands. Try to understand like you know what was the question is been asked and how do we answer for that particular question. Plot it. Okay. Um was something like you know they wanted to see the data they wanted to modify the data or they wanted to see the data for that is in that data they just wanted some kind of aggregation. So if the data has like you know okay how much we are spending in each country okay so here clearly says I want to see the data but I want to summarize the data aggregated data so where I have to see the country is a groups and for each country how much we are spending okay things so in that basis like you know um that is a things what we need to know and second thing is like you need to know like basic things like so when you're selecting the data we say select and that is going to be followed with the columns and if it is all the columns we say star if it is only selected columns mention the columns with a comma If you have to get some kind of a calculations, yes, we have the calculations things. Okay, we have lot of functions also. You can concat first name, last name and make it as one name and so on. If they ask you, hey, I just want to know how many different countries are there. Um or what of the different countries are there? We got a distinct. But I just want to know how many different countries say we have employees. So we can put a count on this. And when you put a count on this, so we'll come to know out of the 21 employees, we have the 201 employees coming from seven different countries. Okay, when I say distinct count, it was just uh listing out the country names. But I just want to know how many different countries say we have employees. I'm just using a count. This particular thing what we got it the same thing I'm surrounding with the count. So now we know what is a count, what is a distinct, what is a country column does. See simple. I'll show you one thing. So if I just give country, so what it does, it removes the other column, shows me only the country column. Fine. That is what exactly is happening. It is showing all the countries. But I don't want the duplicate values. So if I want to remove the duplicates, we have a keyword called as a distinct. You just need to know this few keywords here. When you use a distinct, it removes the duplicates. But I don't want to show this particular name of the countries. I just want to get a count of it. So in that case, what you do? We have a function called as a count. And when you use any function, function will have a parenthesis. Just put this in the parenthesis. Okay. I think this is how you have to uh learn uh SQL. So it's completely like mathematics. You don't have to buy heart anything. But you need to know the basic things. What is the each clause doing? From clause what it is doing. So after from will be followed with the table. After group by will be followed with the column. Again in the you know when you talk about a data analytics we have something called as the dimensions and the measures. Okay. Aggregate functions is done on the measures and grouping is done on the dimensions. This is what happens in your pivot table also. No. So when you take a what do you say department or country or anything by default they go to the rows because they are dimension. They cannot do a calculation. But we talk about a salary or experience by default they come into the values and they do an aggregation is it? So see it's like a built-in AI you know okay before we used to manually drag and drop in Excel. Now we can see there is a lot of built-in you don't have to really go with a chat JP or a copilot or anything. So this things you should know this particular things that's it. So here is again when you're doing a group by so aggregate function is done in the measurable values and grouping is done on the dimension discrete values. Yeah, if I answered this. Great. Yes. Yes, we definitely answered it. Um, so I think sadic we'll just proceed with a Q&A uh you know towards the end. Maybe we'll kind of uh I'll just take the screen share back and I'll just uh have a few questions for the learners as well. I hope it was informative for the learners. Definitely. So yeah, I think the learners you can answer how informative it was. Just just let us know on the chat. Okay. Yeah. all if you can respond on the chat. Yeah. Yeah. Yeah. Amazing. Great. So, Sadik, one request that a lot of learners had uh was they wanted your data set. I know they can use any other data set as well, but I think because you showed them this and we're also um you know sharing the recording, it'll be helpful if you can share the data set with me. Um so, learners, you will receive the data set, the recording, everything else uh on Monday, right? And Monday end of day you should have all these resources with you. Okay. Remember Monday end of day you will have all these resources. Yes. All right. Great. Great. Now another question that uh we have for our learners which which pretty much I know what the answer is but in case you guys can let us know on the chat will actually be helpful. Sorry on the poll. So, I've just launched a very quick poll and uh audience on LinkedIn and on YouTube, in case you're wondering what the poll question is, let me just share my screen again. Just a moment. Yeah, sorry. Yes. So, if you can just answer, what is that one thing that is stopping you from becoming a data analyst? and people posting questions on the Q&A box. Just wait for a while because we're still about to discuss a few more things, right? And maybe then you can ask your questions, right? Because we are almost approaching towards the end of the session. I may not be able to address everything. So, just make sure your questions are really selective, powerful, and not repetitive. I've answered nearly 80 questions while the session was going. So, I'm sure you'll find uh your answers in those 80 questions, right? Um, please take a look before you actually post one. Right, right, right, right. Keep keep those answers coming. Um, yeah. Yes. Yes. So, a lot of you learners now feel that you don't have the practical exposure you need, right? And some of these this session it actually helped you understand how you know how practical exposure is really important right and why you have that gap. It made you recognize that. Now a lot of you learners also asked this question about will Sadi be taking um the training as well. So the answer is yes. He will be taking uh classes associated with the Excel the SQL topics particularly anything associated with Tableau PowerBI. He will be actually your trainer if you end up taking the professional certificate in data analytics and generative AI. Right now the these classes are much longer and an extended version of what you saw today. remember Sadhi kept saying that uh you know I I won't be able to teach you much because you know this is the time that I have and it's hard for him to wait for you to understand or wait for you to practice and load the data set and also practice these queries and commands um so it's hard for you to do that in a one and a half hour long session but remember imagine doing this in a 4-hour long session with the other learners as well along with sadik so that's going to solidify your learning one and also give you that practical exposure that confidence that you know you can also kind of um take the step forward and you know try and do what data analytics analysis analysts really do right so that's how the course really uh helps and it's that's how it's different from what you'll find anywhere else right and not just with the topics that sadic takes so if there are other topics as well you will find that the the sessions are really interactive and you actually learning along with the learners even though it's a virtual setup you're actually learning along with a lot of other peers who are you know who have a similar background as you right um so we start from the basics we kind of uh teach you business analytics with Excel and all that you learn today is actually the fundamental of the course and then you learn some uh Python programming and ETL which is again fundamental of uh data analytics and then you understand how Genai is important, how Genai can be used in data analytics and of course some electives uh as well which is [clears throat] data visualization and uh you know you have you also have IBM an IBM course which is called the prompt engineering course and along with that you have an academic masterass by Purdue University online okay so that's an added advantage that you get uh when you join this course scores is you know offered in partnership with Purdue University online. Okay. Right. So that's exactly how the curriculum is built and you have a bunch of capstone projects as well. So you're not just actually learning these topics live in live classes with trainers. You're also towards the end of the course you're also practicing these projects live along with your trainer and the other learners as well. And all of this the along with the live classes if there's any self-arning content that is available the capstone project is all available to you in a learning environment that's just dedicated to you that's something that you can access okay and you will know your progress you'll be able to track how far you are from course completion right so that's just a bit about the capstone projects we've got amazing trainers uh like Sadi himself we've got Shubhham Sonal and Christopher er who are your trainers as well and a lot of trainers actually for the other modules as well and Patrick J. Wolf is actually um the dean of college of science at Purdue University and he is the program advisor for this particular program. Right? So the curriculum is built by uh people who are in the industry, people who have a lot of experience uh understanding of what should be taught um you know how we can bridge the gap between what the industry requires and what the learners require. So that's how the curriculum is really built and it keeps evolving. That's the best part. So we don't stop at just teaching you what you saw just now. We make sure that the curriculum is you know changing and and changing with the times that are coming right. Um so of course I don't think we need to mention how Purdue can really help. So Purdue is you know globally recognized. It is a leader in higher ed and also particularly leader in technology, engineering, data science courses, right? And it's at the forefront of research and innovation. And actually Purdue University online collaborated with simply learn to um you know bring these courses so that learners are able to upskill without actually visiting the the campus. Right? So that's how produce courses are useful and along with that you get access to master classes. you also get access to uh a certificate that's jointly offered by Purdue and Simply Learn. Okay. And the last but not the least, you also have access to the alumni association of Purdue. Um and you become eligible to actually, you know, access that. Right. So remember I said that you have a learning environment where you can access the course content, the self-arning content. You are also able to access learning support. You have a cohort manager who helps you with your queries, who helps you understand uh you know where you can find the resources, when your next class is going to happen, what you can do if you miss a class, all of that. Anything associated with your learning, there's a dedicated cohort manager and and this is irrespective of the region you live in. Okay? Right? And uh one more thing that we offer in the course is career support. Now please don't mistake this for uh job guarantee is in no means job guarantee but what we offer is mentoring in terms of what jobs you can find what jobs are relevant to your current profile help you with interview prep help you with uh optimizing your profile your LinkedIn profile with the help of AI and of course also you know help you with mock interviews right so that's um that's a part of career support and we've done this in partnership with talent inc for US learners and for India we have done this with IM jobs right so we've got some really amazing features um apart from just the solid curriculum that you get it's it's it's actually the support um the learning support that you get the career support that you get along with the trainers that teach these courses and of course you know the format of learning is also intensive it's not like you're just attending a 1-hour session where it's unidirectional like this. Okay, so remember you get a lot out of this course and totally depends on how you utilize it as well and that's how you gain success out of the course. So this is how the certificate looks like. Remember I said that there are some IBM courses as well. So for that you actually have you know IBM certificate as well. I'm sorry the certificate is incorrect but you also have an IBM certificate and of course you know a certificate jointly issued by Purdue University online and simply learn. Yeah. Um some success stories from our learners who actually made use of the program and eventually uh you know went on to become successful in their career. So you can actually see that this person uh you know has has kind of switched to data scientist uh through this course. Um this person Mari has actually learned Tableau. Ravindra has actually you know completed this course and he kind of made sure that he used it in in finding a new job. So you've also got some career transition stories here. Some of you here are actually non-data professionals. So if you can see these people have actually went on to become data professionals with the help of uh our course right and all of this information is actually available on the course page. So I'm not adding random screenshots. I will share the link for you to refer uh all of these stories as well. Yeah, you're free to actually connect with these people. Uh you know some of their LinkedIn profiles are available as well. You're actually free to connect with them. And uh let me see if there are quick questions. Um so I think there is Slack uh Erin if I'm not wrong uh it must be Slack. Uh there's no WhatsApp group uh course brochure. So Sudhar I will share the link you can download the course brochure there and uh yeah I'm actually coming to the point about the course fee. There is no job placement Sonica. Like I said there is career support. Okay. And let me see quick questions about the course. It's going to be hard for me to track questions. There's so many of them and so many learners here in the class. Uh let me see questions about the course. Okay, nothing else on the Q&A box. I'm just coming to the enrollment steps as well. Um so how you enroll is you can fill in the application on the course page. um you know we fill in your information, your basic information about when you graduated, your job, um your profile and everything and then someone reaches out to you if you're [clears throat] shortlisted and then eventually you know we'll be sending you the payment link and that's how you start learning, right? But an easy way out instead of going to the course page is to actually do this on the poll that I'm about to launch. Okay. So here's the course fee, right? So the course fee for India learners is 1 lak 50,000 rupees and for US learners is $3,500. Now the easier way to pay or finance this course is to use our financing partners and have installments as low as 6,700 rupees or $350 a month. Right? So this just eases the burden on your pocket and you're able to afford this course uh without actually burning whole right. So maybe you can upskill and reach your career goals with the help of these installments right now. So remember I said that there are three giveaways towards the end. Now the first giveaway is actually the scholarship. Okay. Now before I do anything else I want to give this uh you know giveaway here which is to get 20% scholarship for all webinar attendees. Now what you do to avail this scholarship remember there's going to be a lot of polls and information on the chat. So just be very very mindful of the poll questions and uh people watching us on YouTube and LinkedIn you can still avail this by heading to the course page and uh putting in your query and reaching out to the learning advisor. But if you're watching us on Zoom, you make sure you click a yes. And when you click a yes on the program, you are eligible for the scholarship. A 20% scholarship over and above I mean on the course fee that you just saw. Right. So 20% lesser than what you see here is what your course fee is. Yeah. Right. Now if you're this is if you're interested to talk to a learning advisor only then you select a yes. Otherwise, you can select a no or not do anything. There's no compulsion. There's no nobody forcing you to enroll into the course. Right? So, that's giveaway number one. Okay. Now, while you give these poll entries, let me just clarify a few more things. If you live in the US, you will receive the call in the next couple of hours. But uh let's say you actually live somewhere in India or anywhere else in the world, you will receive a call tomorrow or even Monday, right? But remember the scholarship is still valid. Um just make sure that you use the opportunity and join the upcoming cohort. Uh when does the cohort start? The cohort starts on the 16th of June, which is about 11 days away. Um so you can actually use the scholarship uh you know quickly because on from Monday it's just a week away get the cohort started. So it is an [clears throat] 8-monl long program and these are your timings if you're wondering when does do your classes happen. So they happen in the evenings suitable to anybody who's working as well. Okay. Right. So I hope with this anything associated with the course is is is out of the way. Uh course is paid. I did show you the uh course fee guys. What about students? Like I said if you're not able to afford there is no compulsion for you to enroll. All you can use is the installment option. But again uh it's not it's not compulsory. Right. How is AI affecting the data? Uh yeah, so AI is going basically going to help you get better at data analytics and in fact this course is actually also going to help you understand how you can leverage Genai in data analytics, right? Uh yeah. So for people asking me the course um link, let me share that with you guys. And please make sure your poll responses are coming in. Um you know, I'm just going to close the poll in the next 1 minute. And then what I've done is I've actually shared the link to the course on the chat. You guys can take a look at it and uh you know let us know if you have a query you can just drop it on the chat bot as well someone will reach out to you. Okay Rajan actually it's an amazing idea if you're already in the domain of banking or uh you know you want to change to IT u it's that's not a problem but even if you are in banking you can still become a data analyst uh in the banking and finance sectors that does not stop you um maybe you can talk to a learning advisor and figure this out as to how should go about this path Right. Right. Got it. All right. All right. Great. So, I'm just going to end this poll right here in the next uh 10 seconds because I have it's it's also time for giveaway number two. Um which is actually very very closely associated with what we just did in the webinar. Right. So, another 10 seconds and then we're done. Okay. I'm just going to end it exactly at 10 seconds. About half of you have already, you know, expressed interest in the program, which is actually amazing. You took the first step to yeah, great. So, I'm just going to end the poll right here and going to share giveaway number two. Right now, this is actually going to be really interesting. Something that, you know, we've not done very much in uh in in in our earlier webinars, right? So, if you guys are ready and attentive, you know, we're going to do this right now, right? So what we've done is uh you know with actually Sadi's guidance we've actually come up with an SQL cheat sheet sort of that that is like a PDF that helps you with all the commands right now because you attended this webinar and stayed for so long it makes sense for you to have this PDF with you right now. It does not end there. There's also another surprise element associated with it. Right. Um, let me first share the PDF with you and I'm going to do that on the chat. You don't have to do anything. Yes. Yes. Yes. I I am going to do it on the chat, but please make sure um you know you save it. One sec. I actually missed the link myself. So, it's actually a drive link. So, I'm um I'm making sure that the access is all set. So you should be able to see the link in the next 1 minute. Yeah, here you go. So you should be able to uh download the file it cuz you have the view access. Okay, so please make sure you bookmark this link. Now coming up is the additional surprise element that I was talking about, right? Please pay attention once you've bookmarked the link. Just pay attention. So this uh simply learn has come up with a GPT of itself. Okay. Now this GPT is obviously free of cost and this is called simply mentor. Now how is this and this is also useful for people on uh LinkedIn and YouTube. So in case uh I won't be able to share the link directly but you can actually check out this GPT on the GPT store on chat GPT. Um so it's called simply mentor. Now, simply mentor helps you with anything uh you know associated with your career, right? So, in fact, uh if you guys actually missed out on the uh cheat sheet that I sent, you can actually ask simply mentor to give you an SQL cheat sheet and it will still be able to do uh do it for you, right? So, let's say how do I shift from software to data science is your question. You can just ask simply mentor and then you know it's giving you all the concepts that you will you'll have to learn um some free courses some paid programs free articles associated what your road map should look like everything um you know is is available with simply mentor right so isn't this amazing some of you are asking me about the road map that you should follow everything that you just said right so basically yeah thank you uh I'll I'll pass it on. I'll pass this feedback on to the team as well who's worked worked hard on this uh GPT. So you guys can make use of it is what I'm saying not just uh in asking your uh career questions. It can be anything that's technical as well. Okay. Right. So that's your giveaway number two. Is that is that now saved everywhere? Uh if you if you can uh please give me a yes if you got the PDF and the simple mentor GPT. Yes. Yes. Amazing. And if you guys have chosen a yes on the poll, you should be able to call I mean be reached by a learning advisor as well. Okay. Okay. Now any further questions will actually be answered by the simply mentor GPT because you know I really have uh we really have to end this session right now. Anyway coming up to the last giveaway which is the webinar certificate which again you will actually be receiving by the end of Monday along with everything else that I mentioned the data set the recording um and also the PDF uh you know that I shared will also come to you on your email on Monday. But nevertheless, if you saved it on the chat, it's great. You also have this implemented GPT now, so you know what to do. Can play around, right? So, how do you get this certificate? All you have to do is to give your um name on this poll, right? And uh once you've actually entered the poll, you uh there's pretty much nothing else left in the session. So, in case you're leaving, you will be prompted to enter a survey. Please make sure that uh you know you give us a rating as well. Okay. Right. So I think with that uh we're also pretty much done. Shadik if you're still here you can just add parting thoughts. [clears throat] Okay. Yeah. Yeah. Yeah. No thank you. Thank you. Hey uh some people were asking like uh is the Excel mandatory or something? So see actually Excel is not a mandatory especially when you go to data engineerings and all the things you'll be directly working with Python, SQL and all the things but what happens you know if you have the knowledge of Excel it becomes easy for you to understand uh even the SQL you know about the data or even Python. So in Python we have something called as a pandas okay pandas does a similar job ping concept is there data cleaning concept is there everything is like data frames. So on that basis I say like you know um the more you work on Excel is more kind of a uh you get a stronger in understanding the data helps you in making a better logical decisions and so on. So those things uh and I see some somebody were asking about the question about the joins. Yes, we can do the joints. Uh yeah maybe during the session time I'll cover more on joints definitely uh yeah I know sadik you also want to kind of teach as much as possible but yeah we have very less time in in in a in a one and a half hour session um so which is why you know you should consider definitely consider taking the course so make sure you are uh answering the poll guys you guys have to use the zoom app for best results which is when you should be you'll be able to access the poll. It comes as a popup. It's much easier, right? Yeah. Anyway, you can scan the QR code here and I I'm I'm actually going to end the session in the next couple of minutes. Um so, please make sure you are giving your response on the poll otherwise unfortunately we'll have to skip your name, right? Yeah. Yeah. Just exactly couple of minutes, guys. Yes. Yes. about 250 entries out of 300. So, another 50 entries to go. Yes. No, no, no. You can scan the QR code. Scan the QR code, Jackson. Yes. Only name. Only name. Nothing else. Okay. I really can't do more than this. This is all I can do to give you the poll. You guys should be able to access that. Uh, you know, it's not really a big deal. Just pops up on my screen. You can still use the camera. Yeah. Okay. Another minute. Oh god. Okay. Let me see. I'm just sharing the link to the poll. But I mean, this is fairly simple. It's not it's not that complicated. I don't know why this is an issue. It's just a popup that you see on your screen. Yeah. Great. So, we're already getting a lot of done. Yes. Yes. In case you've already done, please don't enter your name again. I don't think you'll be able to do that. Yeah. All right. Another minute, guys, and we're ending the session. It was great bringing this session to you. Some really enthusiastic questions. Uh you know a lot of learners had some great questions on how they can use SQL, how they can uh use become a data analyst. So was was great answering your questions as well. Right. Yes. Like I said, hurry um 20% scholarship is what you get as a part of this webinar. Thank you. Amazing. Great. So you guys will it'll it'll really help if you actually give us uh you know some responses on the survey as well as you leave. Make sure you know you fill in whatever you feel about the session. Give us feedback and uh you know I'll see you guys in another session. Thank you so much Sadi for your time. Wonderful hosting you and uh listening to you and Sadi will be in the next session as well. Indrajit already has a request for you. Great. Thank you so much Sadi. I'll see you again. Thank you learners. Bye-bye. Have a great