0
Résolu

Can I use Vertabelo to learn SQL ? If so, what is the best way to get started ?

Sally C il y a 9 ans mis à jour par anonymous il y a 9 ans 1

Solution

Solution
Résolu
Well, I think it'd be much more useful to learn about database basics and good DB design rather than SQL. We even created a series of videos called "Vertabelo Database Academy" that you can find on YouTube:
https://www.youtube.com/playlist?list=PLghpIrBTN3RJdlnubOCuCmQMQOkgKAYWI

If you want to learn SQL, you can look at the changes in generated SQL while adding tables, references, indexes, keys, etc to your model. This might help you to understand the structure of DDLs. However, it won't be much helpful to learn SQL queries. Here, I'd recommend SQL Fiddle, which allows you to run queries against database "in cloud". You can use SQL script generated with Vertabelo to create a DB structure in SQL Fiddle and then play with inserting, updating and querying the data.

Hope this helps.
Solution
Résolu
Well, I think it'd be much more useful to learn about database basics and good DB design rather than SQL. We even created a series of videos called "Vertabelo Database Academy" that you can find on YouTube:
https://www.youtube.com/playlist?list=PLghpIrBTN3RJdlnubOCuCmQMQOkgKAYWI

If you want to learn SQL, you can look at the changes in generated SQL while adding tables, references, indexes, keys, etc to your model. This might help you to understand the structure of DDLs. However, it won't be much helpful to learn SQL queries. Here, I'd recommend SQL Fiddle, which allows you to run queries against database "in cloud". You can use SQL script generated with Vertabelo to create a DB structure in SQL Fiddle and then play with inserting, updating and querying the data.

Hope this helps.