The creator explains basic SQL commands by first stating the problem (not having 'huzz'), then demonstrates how to create a table, explains primary and unique keys, inserts data for 'huzz' and 'chuzz', and finally shows how to query the database to find specific 'chuzz' using a WHERE clause, all while using slang to make the topic more accessible.
Post caption
Short explanation the purpose of SQL explained in a JOKING manner. Standard Query Language is what we use to create and interact with databases. This video takes a quick glimpse on Creating, inserting, and returning specific results from a table.
Transcript
You don't got no has because you don't use SQL. You need SQL in order to create a database no you good communicate with the has or even the chas. First thing we're gonna do, we're gonna create a table so we bad store and keep the HUD's data organized. This table, we're gonna store ID, the first name, the phone number, and the description. We're gonna make ID our primary key. And what that does, it stops us from having duplicate IDs in the ID column. And we're gonna make the phone number unique no we won't have duplicate phone numbers. When we run this, we create a table for the huhs. But you see we all got no huhs or no chas in the table yet. So if you wanna add the huhs or the chas into the database, we gotta use the insert query. As you're putting data in the table, you gotta make sure the data you're putting in there corresponds to the data type that you picked for that column. We could run this and our table is not empty no more. Now we're gonna try putting tier in a table. You wanna find all the in the table, but you're gonna use the where clause and you're gonna type where description is equal to chuzz, and that's gonna return all the chuzz in the table for you, for you specifically.