0
What software should i use ti develop sql
2 ответов
+ 4
I recommend SQLite for small or medium projects (not involving huge datasets and extreme client/server traffic capacities).
www.sqlite.org
+ 2
First, sql is a language used for manipulating data, e.g. creating/defining data structures, selecting which data to retrieve, use filters or set the order in which the data is returned etc. Try Sololearn's sql fundamentals course, it can help a lot to understand.
Secondly, it's not something you use to develop applications, people use sql to manipulate data, you need to learn it so you can later develop applications (with a programming language of your choice) that can interact with database servers.
Anyway, I think you can start by installing a database server, most of them usually support command line interface. You can start from there.
I personally recommend you to try mysql first, as it is one of the most popular database server and has its own strong community from where you can learn more interactively.
There are other database server apps out there that has their own extension sets for the standard sql, like Postgresql, and Microsoft's sql server with its t-sql. I recommend you start experimenting with the standard/basic sql first, then continue on with proprietary/specific sql.
Happy learning