DEV Community

OLAYEMI OGUNRINDE
OLAYEMI OGUNRINDE

Posted on

Why should you struggle with SQL?

Image description

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)

16 Libraries You Should Know as a React Developer

Being a modern React developer is not about knowing just React itself. To stay competitive, it is highly recommended to explore the whole ecosystem. This article contains some of the most useful React component libraries to speed up your developer workflow.