Transcript

Hello everyone, for those who are still trying to learn SQL or those who are still find it difficult to navigate their way around SQL, I'll be showing you through. I'll be teaching you 3 functions. That are very useful if you want to be very good at SQL or if you want to find it easier around find it easy in SQL. And those functions are from select and. Asterisk. The the the the the from has to do its table name. This is just telling you from what table do you want to select from from how to do from what column? Sorry it has to say from what column are you selecting this from and Asterix has to do with you are trying to bring out the information in a whole table. The whole information in the table, like for example if it's a a country table, you're trying to bring out the whole information in that table in that kind country table. I don't know if you are following just like you're saying. I want to bring out a from the alphabetical order. Give me a from the alphabetical order. He understand. OK, let's use an example. Let's illustrate with the data sets. I have a data sets less illustrate with this so you guys understand what I'm trying to say. OK. OK. Hey I have this data sets so I want to like. I want to do this. I have this data set over here and I want to use this data set to illustrate or to make you understand what I'm trying to say. So let's say I want to get them. I want to get. Let's say I want to get the the name or letter. OK, let's use this. Let's say I want to get the the category ID. And in name. Category ID and the name from this uh from this table which is category table. This is category table just like I explained. Be from has to do with the table and they select has to do with the column. This is the column from what column? This column from categorical? From this column from what table? Category table. OK, OK, let's move ahead. Uh, let's, let's, let's start by saying please, I want you to be to make sure you're always case sensitive. Make sure you are very very careful with case sensitivity because SQL is very sensitive about case. Or packages lower case and they have to be in uniform. If you are starting with upper case, use upper case. If you are starting with lower case use lowercase. And you also have to where you are going to the data sets to try to bring out what's that? What information you want to bring it up bring out from the data set. Make sure the information in the data set rhymes with what you are trying to input. And you're in your query, your query. Your current dashboard or whatever they call it. So let's start by saying. Select. Select. Select. Just as I said, we are going to be using select. Category. So he's going to be small later because it's going to be used the small data because what is here it's small data. Category ID is in small either name is in small either. So we are going to be using small either category category. Go away. Under score ID. Category under score ID. Comma. Then what we want to we also want to see the name. Name. From what table? You're just trying to say what's table now? OK, you want to see the information in this and you want to see the information in this. From what table do you want to see this information? OK, I'm going to say from. Category table. Since Marlita category. Category. I hope I spelt it correctly. Category. So we are going to end this by putting the semi colon and we're going to run this script. Let's see if it's going to run. Yeah, we got it. So this is just simply how to like get information from, you know, your columns and your table in SQL. For those who are still finding it difficult or those who have seen yet to start their SQL journey, it's not that a big deal. It's just, you know, taking your time and understanding and assimilating what whoever is teaching you is teaching you. OK, let's look at now. We already know how to do this. They select and the. You already know what it is for, so let's see what the functions of our what what we can use Asterix for in SQL. OK, let's say for example we want to find. Let's use another table. Let's use like the customer table. Let's use customer table. Select. Select. Put the asterisk. Asterisk. From. From. Select. Well, just like select the whole table. Select the whole column. Sorry sorry sorry, select the whole column. But from what table are you selecting the whole table? What's table? So we want to select from let's say customer. These are all the informations in customer. I want you guys to see it so. These are all the information. Try to bring down my column. OK, you can see all the information. So I don't, I don't want you guys to be surprised or try to say you don't understand what I'm teaching. So let's say customer will type in our customer want to see all the information in customer semi colon. I will run these scripts. Can you guys see it's just as simple as ABC? It's not that difficult. I hope I've been able to impart something today. Thank you guys. Thank you for listening. Thank you for showing interest. I really appreciate. Bye guys.