SQL is simple but not simple as it is???

Question

I have finished sql course and i see it's very simple but in real project or exam in my school it's very hard and many things i've never seen before like transaction and @@trancount,... So i want to ask where to learn those thing. Thanks for reading my question and sorry for my bad English

Answer 1

Hi!

I think the best way is to read the official documents depending on which DBMS you are interested in. I'm learning tsql at the moment, so I read a lot of documentation on their site.
Try to make a project- small social network like mini instagram or some web shop, consisting of 7-10 tables, think about relationships and queries you could create to retrieve data from it.

Play with it, basically.

Answer 2

Same here when i really want to use it😂
SoloLearn only supply basic concepts, so for some advanced usages, you may have to read the official documents or ask others for help😁