What is the importance of SQL?

Question

I decided to improve my skills with SQL and I've not been able to apply the knowledge anywhere else

Answer 1

Let's use an example: Imagine you want to keep track of all the dvds you own.
You can open a text editor, or better an excel sheet, name some columns like title, director, type, year, etc. and start filling it up.
The problem is that:
--if you have a lot of dvds, a search will be slow,
--anybody can open and modify the base, you can't easily set privileges,
--if somebody is using the base already, nobody else can,
--if you give your file to a friend who doesn't have excel, he won't be able to read it,
--if you inadvertently delete your file or if your system crashes, you loose all your hard work,
--you are going to have lots of repetitions in some columns (like type or year), which is tedious,
--you are bound to make some spelling mistakes or forget filling a cell, which is going to create problems when you do a search,
--etc.
By splitting this big file into small tables linked between each other and using SQL all those problems go away :)
But I agree that unless you have a relatively advanced website of your own (and no dvds ^^), SQL is not really useful for you right now.
Yet, it is what is used every time you go to your favorite shopping website and click on an icon to sort items by descending prices or to get to see only your size of shoes.

Answer 2

Lots of times you need databases for your design, like james said. For login sections, weblogs, shopping site,employees list and ...
When your database becomes too big, simpler ones (a text file can be database too) gets too hard to manage and have less safety.
There is when SQL comes in, it's designed for handling any size and kind of database with ease and safety.
So no matter the coding language, it is a good idea to learn it.

Answer 3

SQL is just for databases. Like if you have many values that relate together, if you are collecting profile information or survey response.

Answer 4

sql is simply used to insert, delete, update and sort database with ease. sql is just the standard for query language. we have other platforms dat support sql standard. e.g Sqlite for python because it comes by default when u install Python, MySQL etc. But its important to install sql inspector or database browser on your PC.

Answer 5

Also, it is not that important as there are no challenges in it :((

Answer 6

All sql statements are the same depending on any of the platform u use. They may vary a little.