Tutorial for web designers tool from scratch

I am new on one identity manager web designer tool.
I want to know how can I make new web application/portal using ODM web designers tool?
Also want information for how sql query works? and what's the difference with MSSql 's query?

Is there any online site which can help to new developers to understand basic concepts ?