0
Z odpowiedzią

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

Sally C 5 lat temu Ostatnio zmodyfikowane przez Michał Kołodziejski 5 lat temu 1

Odpowiedź

Odpowiedź
Z odpowiedzią
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.
Odpowiedź
Z odpowiedzią
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.