My disposition maybe wrong pardon me. or maybe because I know it. I don't know why people spend several hours trying to learn SQL.
It is so straight forward such that the English lang is always the use case.
1- You need a folder 📁 what do you do? You Create One (folder in this context is DB).
2- You need a file arrangements inside your folder 🗃️ 🗄️ , what do you do? You name those files and arrange them accordingly(Files in this context is table).
3- You need your employees name to appear in the files, what do you do? you "INSERT" their names respectively.
4- You want just an employee's detail to appear. What do you do? you "SELECT" from the corresponding file/table.
4- You misspelled one of the employees name in the file/table, what do you do? You "UPDATE" the corresponding file number with the appropriate employee name.
5- You no longer want an employee's name to appear in the file 🗃️ and Folder 📁. What do you do? You "DELETE/tipex" the name in the corresponding file.
6- You no longer want a File 🗃️ in you folder 📂. what do you do? you "DROP" the file off the folder 📂.
7- You no longer want the entire folder 📂 and file 🗃️, what do you do? You "TRUNCATE" all.
Example of Commands:
Insert into File/table set = "employee name" where ID = 0000
Update * file/table set = " New name" where ID = 0000
Delete * from file/table where ID = 0000
Select * from file/table where ID = 0000
SQL is the simplest lang to struggle with just like HTML and CSS.
Top comments (0)