[VexorLoophole]

As someone who is writing in go for some time (still deciding if i should learn something like C or JVM-based to get better at understanding big programms), i also want to get into Databases (never really learned to code. Everything is self tought). Do i need to approach a not-language specific way to really learn the SQL concept, and if yes, where do i start? In Chatroom i always read super complex stuff about databases and meanwhile i was never able to handle a SQL Database right, because i wasnt able to wrap my head around the documentation, and used something simple like bolt (in go) for my db needs.

[sethammons]

I would recommend getting familiar with using your db from the command line. If you are in MySQL or Postgres, learn the basics. selects, inserts, updates, deletes, and joins. After you have a bead on those, get used to subqueries. Learn what denormalization is (might want to do that so you can play with joins). Learn what transactions are. At this point, you are probably better than most. After that, start digging into deeper parts by going through public docs and seeing what neat functions they provide.

After you know the above, you can use that SQL knowledge in any language you want when accessing the db. No need to learn a new ORM per language or anything.

Also, at this point, you are likely to start understanding more about scaling systems which involve intelligently choosing indexes, replication, and sharding. Now you are on your way to Jr. DBA status :)

That was my path at least. There are likely better ways.