+ 5

What is the point of SQL?

SQL course on SoloLearning is Very basic. I'm fairly sure that there's more to it than what SoloLearning tells us, but what is SQL really useful for? I've seen that it has something to do with data and it has a lot of tables, but I still don't see the the big picture.

23rd May 2017, 6:06 PM
Leigh E. O.
Leigh E. O. - avatar
8 Réponses
+ 5
To store persistent data for programs and softwares we use databases.Databases is a collection of tables. Sql is a language used to retrieve manipulate data from the tables .
23rd May 2017, 6:08 PM
Nantha
Nantha - avatar
+ 6
what about the sololearn SQL course? is that all there is to it?
24th May 2017, 1:02 AM
Leigh E. O.
Leigh E. O. - avatar
+ 5
It's a query language. You use it to manipulate/receive/append data of/from/to a database.
23rd May 2017, 6:09 PM
Tim G
Tim G - avatar
+ 5
@Maaz Khan, absolutely
23rd May 2017, 6:41 PM
Leigh E. O.
Leigh E. O. - avatar
+ 2
sql provides a standard way to access data in datsbases. before relational databases and sql, data were stored in a ad hoc way in files and hierarchical databases, and all the logic was in programming / application code. ( so it was less scalable and harder to maintain)
24th May 2017, 2:21 AM
ifl
ifl - avatar
+ 1
SQL is the language used to interact with the most structured form of the database, the Relational database. A relational database is extremely important if you want security and integrity in your database. SQL is also very useful for distributed databases where the data is stored in parts at different locations. First understand how the data is stored in tabular form in the database and then learn how sql is used to interact with that data. I hope i am clear.
23rd May 2017, 6:37 PM
Maaz
Maaz - avatar
+ 1
@Leigh E. O. Yes it is very helpful and is a complete source for learning about SQL
23rd May 2017, 6:44 PM
Maaz
Maaz - avatar
0
SQL is very useful, you will need in any application the requires database
23rd May 2017, 9:24 PM
Dawood Ahmed Kehinde
Dawood  Ahmed Kehinde - avatar